Jeff hit Error 15151, cannot find the user, even though the user existed. The cause was a case sensitive database, and here is the fix.
SQL SERVER – Solution Part 2 – A Quick Puzzle on SQL JOIN and NULL – SQL Brain Teaser
Part 2 of the solution to my puzzle on SQL Join and NULL. Readers still email me answers every day, so here are more of the good ones they sent.
Numbers Table vs GENERATE_SERIES: Building Rows on Demand
Learn numbers table in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.
SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video
In SQL in Sixty Seconds #002, Rick Morelan explains T-SQL errors and reactions: what SQL Server does when it hits an error, in about a minute.
What Is Big Data? A Simple Explanation for Database People
What Is Big Data? It is the point where data outgrows one machine, and the fix is to scale out. This post explains the failures of one server and walks through 40 TB split across 8 nodes.
Reading Fixed-Width Text Files With OPENROWSET and a Format File
Read fixed-width text files with OPENROWSET and an XML format file, trim fields, validate conversions, and load only acceptable rows.
Resetting a Test Database With Database Snapshots
Resetting a test database with SQL Server snapshots gives a fast baseline for repeatable tests; create, revert, and manage sparse files safely.