Attaching a database gave me Error 948: a downgrade path is not supported. Here is why a database from a newer SQL Server version won’t open on an older one.
Pester the Tester: PowerShell Bugs, Beware! – Notes from the Field #129
Pester the Tester: Robert Cain shows how Pester, an open source testing framework for PowerShell, helps you catch bugs before they catch you.
SQL SERVER – SQL Profiler vs Extended Events
SQL Profiler or Extended Events? I compare how each one works, why SQL Trace adds overhead on a busy server, and why Extended Events is my choice.
SQL SERVER – FIX – Linked Server Error 7416 – Access to the remote server is denied because no login-mapping exists
Linked Server Error 7416: access to the remote server is denied because no login-mapping exists. What the message means and how to fix the login mapping.
SQL SERVER – Event ID 7000 – The service did not start due to a logon failure
SQL Server did not start after a reboot and the event log showed Event ID 7000, the service did not start due to a logon failure. Here is the cause and the fix.
SQL SERVER – Installation Error – The wrong diskette is in the drive. Insert (Volume Serial Number: ) into drive.
Installing SQL Server 2008 SP4 on a cluster failed with: The wrong diskette is in the drive. Here is what the setup logs showed and how we fixed it.
Who Changed This Row? Temporal History With FOR SYSTEM_TIME ALL
Read FOR SYSTEM_TIME ALL with LAG to compare row versions, choose temporal window boundaries, and record an actor when identity matters.