-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2018

SQL Saturday Dallas half-day precon: “Beginning Programming with Powershell”

On May 18 we will be presenting a half-day of PowerShell learnin', right before SQL Saturday Dallas! Read up and register now.

The post SQL Saturday Dallas half-day precon: “Beginning Programming with Powershell” appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 231 reads

Posted in SQL Awesomesauce on 24 April 2018

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!

The post Fix WHERE clause AND/OR/NOT confusion with truth tables Read more

5 comments, 1,669 reads

Posted in SQL Awesomesauce on 17 April 2018

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… Read more

1 comments, 267 reads

Posted in SQL Awesomesauce on 6 April 2018