A report viewer failed with rsReportServerDatabaseLogonFailed: the report server cannot open a connection to the report server database. Here is the fix.
SQL SERVER – FIX: Error 14001: The Application Has Failed to Start Because its Side-by-side Configuration is Not Correct
A Jr. DBA’s SQL Server service would not start: Error 14001, the application’s side-by-side configuration is not correct. Here is how we found the cause.
SQL SERVER – FIX: Msg 3231 – The Media Loaded on “Backup” is Formatted to Support 1 Media Families, but 2 Media Families are Expected According to the Backup Device Specification
Preparing a demo, I hit Msg 3231: media formatted for 1 media family, but 2 Media Families are expected. Here is what causes it and how to fix it.
SQL SERVER – How to Download SQL Server Native Client?
A client asked how to download SQL Server Native Client. My tip: search for the SQL Server Feature Pack, which includes the Native Client drivers.
How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165
Is your application using deprecated features that a future SQL Server may remove? Here is how SQL Server helps you find them, starting with a Profiler event.
Identify SQL Server Version From a Backup File
To identify SQL Server version from a backup file, run RESTORE HEADERONLY and read DatabaseVersion and SoftwareVersionMajor. This post makes a demo backup, reads its header, and maps the numbers to products. It also shows how to compare the backup with your server in T-SQL, and why a header sometimes fails to read on an older server.
Temporary Stored Procedures in SQL Server: Local and Global
Temporary stored procedures start with one # sign for a local one and two for a global one, and both live in tempdb. This post creates each kind on a demo database, shows who can call them and when they disappear, and explains which database their object names resolve in. It ends with the habit that makes them useful for testing a rewrite.