SentryOne Team Blog (

Tag: Best Practices

Bad Habits Revival

Bad Habits Revival

Aaron Bertrand (@AaronBertrand) breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.

Photo credit: badgreeb_records

T-SQL Tuesday #99: Missing Indexes and Index Key Order

T-SQL Tuesday #99: Missing Indexes and Index Key Order

Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.

Top 7 Things Every DBA Should Do Before They Go On Holiday

MS MVP Kevin Kline walks through two ways to prepare for a peaceful and uninterrupted holiday: technology and process. The former involves things we can do with our databases to make our lives easier while away from the office, while the latter are steps we can take in advanced to reduce the need for our coworkers to call us. 

What Does HIPAA Mean for the DBA?

What Does HIPAA Mean for the DBA?

Get an overview of HIPAA regulations along with compliance tips and best practices from a healthcare legal specialist from the point of view of the DBA.

Slides and Scripts: Baltimore SQL Server User Group

Slides and Scripts: Baltimore SQL Server User Group

Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.

#BackToBasics : CAST vs. CONVERT

#BackToBasics : CAST vs. CONVERT

Aaron Bertrand (@AaronBertrand) explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.

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!

Dynamic Data Masking and Row-Level Security Features in SQL Server

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, they'll be released first to the cloud platform (Azure SQL Database) and, later, to the on-premises version of SQL Server. READ MORE… Originally

SQL Saturday #467 Pre-con : Being a DBA, A Day in the life

John Martin (@SQLDiplomat) talks about the upcoming pre-con he is presenting alongside Richard Douglas (@SQLRich) at SQL Saturday #467 (Southampton).

Stronger Security Via Always Encrypted in SQL Server 2016

Prior to SQL Server 2016, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data

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

Best Practices : Properly referencing columns

Aaron Bertrand (@AaronBertrand) continues his series on bad habits and best practices, this time focusing on the benefits of referencing columns in a query.

Should I use NOLOCK against #temp tables?

Aaron Bertrand (@AaronBertrand) addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.

Bad habits : Clinging to old compatibility levels

Aaron Bertrand (@AaronBertrand discusses a common scenario: behavior is different between two SQL Server databases that may be the same version but have different compatibility levels.