Microsoft MVP Allen White shares an Environmental Health Overview trick for a multiple server environment.
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.
Aaron Bertrand (@AaronBertrand) continues his "Back to Basics" series, this time discussing SQL Server's synonym and how it can be used.