We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years in SQL Server. Independent trainer and consultant. Author of the SQL Server Internals series of books, among others. Runs https://www.sqlserverinternals.com/ Trekkie. All-around awesome person. In our ramblings, we covered college, food, linguistics, career, and of […]
Category: sqlserverpedia-syndication
Fix WHERE clause AND/OR/NOT confusion with truth tables
The ANDs, ORs, and NOTs in a T-SQL query’s WHERE clause can get confusing, especially if you’re thinking of it like plain-Jane algebra. Here I show you how to figure out exactly what a query is doing, using truth tables!
When was my last backup / CheckDB / index maintenance?
Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean SQL Server instances. So how do we go about this? Well, there’s the easiest way – you knew I’d be mentioning Minion Enterprise, right? – and then there’s the hard way. The easiest way If you have Minion […]