Sharding splits SQL Server data by a stable key when one server cannot meet scale needs; learn routing, cross-shard costs, and simpler options first.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Creating Database with Different Collation on Server
A client ran two instances on every server just for case sensitivity. Here is how to create a database with a different collation on the same server instead.
Take a Database Backup in SSMS: Step by Step
To take a database backup in SSMS, right-click the database, choose Tasks, then Back Up, and pick the backup type. This post walks through the dialog, shows the T-SQL that does the same work, explains the log backup error people meet first, and checks the files afterwards.
SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions
Three questions I get all the time: where to get AdventureWorks, restoring a 64-bit backup on a 32-bit server, and restoring a 2012 database to 2008 or 2005.
SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup – A DBA Conversation
Error 4214 says BACKUP LOG cannot be performed because there is no current database backup. It often shows up right after a switch to the full recovery model.
SQL SERVER – What is Hekaton? – Simple Words Explanation
What is Hekaton? In simple words, it is the in-memory feature announced at PASS Summit 2012 that keeps busy tables in memory to make applications much faster.
Disabling Nonclustered Indexes Before a Large Load, Then Rebuilding
Test disabling nonclustered indexes before a large load, rebuilding them afterward, and measuring total time and log use.
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.