SQL Awesomesauce

Fix: When an Availability Group listener’s IP is stolen

• by Jen McCown

• SQL Awesomesauce

When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener,...

2018-09-05

860 reads

Learn PowerShell in Oklahoma, August 24!

• by Jen McCown

• SQL Awesomesauce

SQL Saturday Oklahoma City is coming up RIGHT SOON, on August 25. The day before SQL Saturday OKC - August 24...

2018-08-14

690 reads

Vote for a new SSMS feature: Pin files in SQL Server Management Studio

• by Jen McCown

• SQL Awesomesauce

So, this just happened: That's a p good idea. I'll upvote it if you put it in User Voice. Or...

2018-08-03

399 reads

Minion Backup: Restore to another server

• by Jen McCown

• SQL Awesomesauce

Minion Backup makes your SQL Server backups effortless, of course.  And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look...

2018-06-28

415 reads

The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’

• by Jen McCown

• SQL Awesomesauce

Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take...

2018-06-14

344 reads

Generate RESTORE LOG statements

• by Jen McCown

• SQL Awesomesauce

Today, we're going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files,...

2018-06-06

797 reads

Tea with Kalen! An interview with Kalen Delaney (#DBAsAtMidnight)

• by Jen McCown

• SQL Awesomesauce

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...

2018-05-16

337 reads

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

• by Jen McCown

• SQL Awesomesauce

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

2018-04-24

347 reads

Fix WHERE clause AND/OR/NOT confusion with truth tables

• by Jen McCown

• SQL Awesomesauce

The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it...

2018-04-17

2,010 reads

When was my last backup / CheckDB / index maintenance?

• by Jen McCown

• SQL Awesomesauce

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...

2018-04-06

348 reads