Category: #BackToBasics

Jim Holden has some fun explaining the fundamental aspects of one of the gems in the SentryOne Platform : Event Chains.
Microsoft MVP Allen White shares an Environmental Health Overview trick for a multiple server environment.
December 27, 2017 | Allen White | #BackToBasics, EHO, SentryOne 0
Surprising but True: the Basics are Still Difficult
For both T-SQL Tuesday and #BackToBasics, Aaron Bertrand provides information about SQL Server backups, and why your restores can be just as important.
Aaron Bertrand explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.
November 2, 2016 | Aaron Bertrand | #BackToBasics, T-SQL 7
Aaron Bertrand explains why he codes defensively - matching the case of data type names, even when it isn't strictly necessary.
October 4, 2016 | Aaron Bertrand | #BackToBasics, T-SQL 0
Learn more about all of the newest features added to SSMS from Kevin Kline's latest article on DBTA.
Microsoft MVP Aaron Bertrand goes back to the basics with this post on the two core issues to consider when choosing a standard for stored procedure names.
September 1, 2016 | Aaron Bertrand | #BackToBasics 1
Melissa Connors walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.
In his 8th #BackToBasics post, Aaron Bertrand takes a look at one of the classic debates in SQL Server: whether to support Unicode.
Aaron Bertrand continues his #EntryLevel challenge, discussing DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
Temporal Tables in SQL Server 2016
Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
Aaron Bertrand explains some of the more common acronyms you might see flung around in blog posts, Connect items, and Knowledge Base articles.
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