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.
What is a Master Database in SQL Server? – Interview Question of the Week #076
A reader told me he had dropped his master database. So here is the basic question: what is a master database in SQL Server, and why does it matter?
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.
SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)
SQL Agent would not start in a cluster and SQLAgent.OUT said SQL Server Agent terminated (normally). Here is what the log showed and how I fixed it.
Oracle Number Data Types: The SQL Server Mapping Table
Oracle number data types need the right SQL Server match during a migration. Here is the full mapping as a table, and the implicit converts a safe bet of Int or BigInt caused for one product team.
SQL SERVER – Maintenance Plan Folder Missing Under Management in SQL Server Management Studio
A reader wanted scheduled backups on SQL Server 2016 but found the Maintenance Plan Folder Missing under Management in SSMS. Here is my answer.