l Best Practices - Blog Category - SentryOne Blog

Category: Best Practices

Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries.
Itzik Ben-Gan starts a new blog series on T-SQL bugs, pitfalls, and best practices, leading off with some common issues involving determinism.
March 13, 2019 | SQLPerformance.com | T-SQL, Best Practices 0
Aaron Bertrand 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.
February 28, 2018 | Aaron Bertrand | Bad Habits, T-SQL, Best Practices 8
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.
February 13, 2018 | Andy Yun | Best Practices, SQL Server, T-SQL Tuesday 0
MS MVP Kevin Kline walks through two ways to prepare for a peaceful and uninterrupted holiday: technology and process.
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.
Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.
Think of this series as a brain dump for all of the career advice we'd give to an aspiring DBA. Register now!
March 14, 2016 | Kevin Kline | Best Practices, SQL Server, Career 0
Stronger Security Via Always Encrypted in SQL Server 2016.
The Top 10 Mistakes Made by SQL Server DBAs
1 2

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial