Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
The money Data Type: Where Division and Rounding Go Wrong
Dividing money by money loses digits before any cast can save them. Here is the one-third demo, and how to find the leftover penny.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
SQL Server would not start: TDSSNIClient initialization failed with error 0x2, status code 0x38. Process Monitor and the SuperSocketNetLib key helped.
Reading a Benchmark Somebody Else Published
Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.
SQL SERVER – Connecting Specific Database on Starting SSMS
Here is how to connect to a specific database on starting SSMS, a small setting many DBAs miss. It keeps stray objects out of the master database.
SQL SERVER – Why One Table Cannot Be Deleted From a Backup File
You cannot Delete a Single Table by editing a SQL Server backup file. I keep the original backup intact.
SQL SERVER – The SaveToSQLServer Method has Encountered OLE DB Error Code 0x80040E4D
My relationship with existing clients, I provide quick help to them on simple issues. Let us learn the error related to SaveToSQLServer.