Jim Holden has some fun explaining the fundamental aspects of one of the gems in the SentryOne Platform : Event Chains.
Category : BackToBasics
Microsoft MVP Allen White shares an Environmental Health Overview trick for a multiple server environment.
For both T-SQL Tuesday and his #BackToBasics challenge, Aaron Bertrand (@AaronBertrand) provides some fundamental information about SQL Server backups, and why your restores can be just as important.
In every month of 2016, Aaron Bertrand (@AaronBertrand) will attempt to publish an introductory blog post about SQL Server.
Aaron Bertrand (@AaronBertrand) explains why he always opts for one of these options over the other, even in cases where it shouldn't matter.
Aaron Bertrand (@AaronBertrand) explains why he codes defensively – matching the case of data type names, even in scenarios where it isn't strictly necessary.
As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS). While SSMS is an outstanding administration and T-SQL programming tool, it does have its minor qualms and quibbles. Learn more about all of […]
Naming conventions for stored procedures is the topic for Aaron Bertrand's 9th post for his #EntryLevel series.
Melissa Connors (@MelikaNoKaOi) walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.
In his 8th #EntryLevel post, Aaron Bertrand (@AaronBertrand) takes a look at one of the classic debates in SQL Server : whether to support Unicode.
Aaron Bertrand (@AaronBertrand) continues his #EntryLevel challenge with July's entry, a treatment of DATEFROMPARTS() and similar functions introduced in SQL Server 2012.
While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't heard of temporal data values (or for some, "bitemporal"), here is a brief explanation. READ MORE… Originally Posted June 09, 2016
Continuing the #EntryLevel challenge, Aaron Bertrand (@AaronBertrand) talks about optimizing the "kitchen sink" procedure using dynamic SQL and, optionally, OPTION (RECOMPILE).
Aaron Bertrand (@AaronBertrand) explains some of the more common acronyms you may see flung around in blog posts, Connect items, and Knowledge Base articles.
As part of his #BackToBasics series, Aaron Bertrand (@AaronBertrand) gives four quick tips on using date and time values effectively in SQL Server.