Importing Excel data with the Import and Export Wizard failed with a potential loss of data error. Here is what causes it and how to fix it.
Regaining sysadmin Access When Nobody Can Log In
Regaining sysadmin access starts with single-user SQL Server, a local sqlcmd connection, and a controlled Windows admin group.
Sharding: When One Server Is Not Enough
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.