Browse the archive
Back in my day, we stored SQL Server Integration Services (SSIS) packages in msdb, or the file system. Well, I’m neither dead nor retired, so that’s not an accurate statement–today is still “my time.” But when I was learning about SQL Server, those were the …
Continue readingMicrosoft docs defines the dbcreator role as: Members of the dbcreator fixed server role can create, alter, drop, and restore any database. But what specific permissions are actually included in that role? If we scroll down in the docs just a little, we’ll …
Continue readingThe intersection of Crash Recovery Boulevard and Version Store Avenue is now known as ADR Square. Last week, I wrote about the SQL Server Version Store. The week before, I looked at crash recovery. Let's look next at a new feature in SQL Server 2019, where …
Continue readingSure, Microsoft does versioning, but check out this Microbus versioning! Maybe you’ve read about the Read Committed Snapshot (RCSI) or Snapshot Isolation levels. Or maybe you were trying to figure out the difference between the two snapshot isolation levels. …
Continue readingrecovering from this crash is going to be pretty difficult If you've ever had a server reboot unexpectedly, you've probably seen SQL Server start up, with some databases "stuck" in recovery status, then eventually they come online. Or maybe you thought "this …
Continue readingIf a server falls in a data center and no users are around to notice, does it count as downtime? There's a lot of discussion about preventing downtime. As a DBA and IT professional, it's my sworn duty to prevent downtime. I usually describe my job as DBA …
Continue readingNo, seriously. What is a DTU? When you’re deploying any application, one of the first questions that comes up is “What will this cost?” Most of us have gone through this sort of exercise for sizing a SQL Server installation at some point, but what if you’re …
Continue reading
