Category: Tech and Learning

Generate RESTORE LOG statements

Post author By Jen McCown
Post date June 6, 2018
Categories In Admin, Applied SQL, Beginner, Dev, Powershell, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips, TSQL

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

Post author By Jen McCown
Post date April 17, 2018
Categories In Advanced, Dev, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL
5 Comments on 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?

Post author By Jen McCown
Post date April 6, 2018
Categories In Admin, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on 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 […]