A Saturday fun puzzle with DATETIME2 and CAST in SQL Server 2012. Run each script one at a time, guess the output, and learn something new.
Deprecated Features and Breaking Changes: Plan Your Upgrade
Breaking Changes are only one of four kinds of change that an upgrade brings. This guest post by Nakul Vachhrajani explains the four kinds, how to find deprecated feature use with Extended Events and the Deprecated Features counters, and a checklist for planning the upgrade.
Upgrading With Log Shipping for a Short Cutover
Upgrading with log shipping stages a newer secondary with NORECOVERY, applies logs in order, and leaves a short, rehearsed final cutover.
SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433
Rick Morelan’s Joes 2 Pros books go from opening SSMS to core architecture. Here are five SQL in Sixty Seconds videos from this SQL Exam Prep Series 70-433.
SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME
Many people join sys.tables and sys.schemas to get a schema name from an object ID. The OBJECT_SCHEMA_NAME function does it in one simple call.
SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.
Columnstore Indexes for Reporting Tables
Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.