So, this just happened: That’s a p good idea. I’ll upvote it if you put it in User Voice. Or we just pull rank and nag @vickyharp 😀 — Kerry Tyler #BLM 🚴 (@AirborneGeek) August 3, 2018 And so, I did. Post the idea, I mean…I didn’t nag Vicky. Vote here.
Category: Dev
Generate RESTORE LOG statements
Today, we’re going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.
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!