Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
Estimating Cloud Database Cost From Your Workload
Cloud database cost depends on measured compute, storage, backup retention, and network egress; build a workload-based estimate before migrating.
SQL SERVER – Get Latest SQL Query for Sessions – DMV
Want the latest SQL query for sessions on your server? Join sys.dm_exec_connections with sys.dm_exec_sql_text using most_recent_sql_handle.
SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
A reader’s job failed after upgrading to SQL Server 2008 because TRUNCATE_ONLY is gone. My notes on SHRINKFILE and TRUNCATE Log File, and what to watch for.
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
Dual Core was a brand, not a core count. What actually matters for SQL Server is cores, clock speed and licensing. How to see what you really have.
SQL SERVER – What is AdventureWorks?
What is AdventureWorks? Why I use this SQL Server sample database in my examples, how it replaced Northwind and Pubs, and where to get it.
SQL SERVER – Disable Clustered Index and Data Insert
A client’s DBA disabled every clustered index before a bulk insert, and the application stopped working. What happens when you disable clustered index?