SentryOne Team Blog (blogs.sentryone.com)

Tag: basics

Surprising but True: the Basics are Still Difficult

I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." READ MORE… Originally Posted April 07, 2017

#BackToBasics : A Challenge for 2016

#BackToBasics : A Challenge for 2016

In every month of 2016, Aaron Bertrand (@AaronBertrand) will attempt to publish an introductory blog post about SQL Server.

#BackToBasics : Definitions of SQL Server release acronyms

Aaron Bertrand (@AaronBertrand) explains some of the more common acronyms you may see flung around in blog posts, Connect items, and Knowledge Base articles.

#BackToBasics : Dating Responsibly

As part of his #BackToBasics series, Aaron Bertrand (@AaronBertrand) gives four quick tips on using date and time values effectively in SQL Server.

Get in on the New Webinar Series, "Who Wants to be a DBA?"

Think of this series as a "brain dump" for all of the career advice we'd give to an aspiring DBA. Register now!

#BackToBasics : The Beauty of the Synonym

Aaron Bertrand (@AaronBertrand) continues his "Back to Basics" series, this time discussing SQL Server's synonym and how it can be used.

#BackToBasics : The "Runaway" Query

Aaron Bertrand (@AaronBertrand) describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.

#BackToBasics : Common Table Expressions (CTEs)

Aaron Bertrand (@AaronBertrand) presents his first "BackToBasics" post of 2016, giving an introduction to common table expressions (CTEs).

The Top 10 Mistakes Made by SQL Server DBAs

THE TOP 10 MISTAKES MADE BY SQL SERVER DBAS The SQL Server world has its own set of challenges when it comes to database administration. One of the biggest challenges is that there are never enough skilled DBAs. Consequently, many people who are not true DBAs are pressed into service, perhaps a Windows SysAdmin or