A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.
SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
Getting Cannot open database requested by the login for NT AUTHORITY\NETWORK SERVICE? Map that login to your database under User Mapping.
Joining Two History Tables at a Point in Time With FOR SYSTEM_TIME AS OF
Use FOR SYSTEM_TIME AS OF to join temporal tables at one UTC instant, compare range forms, and index the history lookup correctly.
SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
Jacob Sebastian interviewed me on Beyond Relational: what the term means, and why it builds on relational databases instead of moving away from them.
SQL SERVER – Measure CPU Pressure – Detect CPU Pressure
How to measure CPU pressure in SQL Server and tell whether your server needs a faster CPU or more CPUs, using simple scripts and signs.
Evaluating a New SQL Server Version in One Week
Evaluating a New SQL Server Version in one week works when you install, restore, run a real workload, compare results, and write a decision.
SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.