Restoring a SQL Server 2008 backup in SSMS 2012 gave ‘No backupset selected to be restored’. A reader’s question and what causes this restore error.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Backup to URL Fails in Azure Resource Manager (ARM) Deployment Model with Error – (400) Bad Request
Backup to URL failed with (400) Bad Request on storage created in the Azure Resource Manager model. Here is why and how my client got it working.
SQL SERVER – False Error – Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.)
BULK INSERT said ‘Operating system error code 5 (Access is denied.)’ but that was not the real problem. A repro of this misleading error and the real cause.
Database Sharding – How to Identify a Shard Key?
Picking the shard key is the hardest part of Database Sharding. Here are the guiding principles I shared at a user group for choosing a good one.
PowerShell – SQL Server Paging of Memory Identification
After a client case of memory pressure, I wrote a PowerShell script to spot SQL Server Paging, when SQL Server memory is being paged out to disk.
SQL SERVER – A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER
Event ID 7011: a timeout was reached while waiting for a transaction response from MSSQLSERVER. It happened when my client expanded an Oracle linked server.
How to Drop Clustered Index on Primary Key Column? – Interview Question of the Week #084
DROP INDEX fails with Msg 3723 on a primary key. Here is how to drop clustered index on a primary key column the right way, through the constraint.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.