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.
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.
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.
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