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 – 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.