We’re speaking at PASS Summit 2013!
PASS liked our “Mouth Wide Shut” interviewing session from last year so much that they’ve decided to have us back...
2013-05-22
602 reads
SQL Awesomesauce
My 2013 SQL Saturday Schedule!
I’ve finally gotten my gear together for (what I consider) the “speaking season”. Here are the SQL Saturdays that I’m...
2013-05-16
611 reads
Use Powershell to find and punish – er, delete – rogue files
I like to know what’s on the drives that are supposed to be dedicated to data and log files. So I...
2013-05-13
1,074 reads
Quick Tip: Navigating to a UNC within SQLPS
I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the...
2013-05-06
760 reads
Quick Tip: Where’s my SQL Server Job History?
Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on...
2013-04-29
1,187 reads
In which we compare CISPA to Rick Astley
Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....
2013-04-20
587 reads
Remembering Alan Weber, @Aauugold
We lost someone this week. We lost a fellow SQL-ite, a Twitterer, a DBAs@Midnight chatroom live chatter. We lost someone...
2013-04-05
836 reads
The New MidnightDBA.com is live!
GUYS! GUYS! GUYS!!! We’ve finally completed the MidnightDBA.com facelift that many of you have been begging (nagging, pining, etc.) for,...
2013-04-02
625 reads
T-SQL Tuesday #40 Roundup: Files and Filegroups
Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect...
2013-03-18
844 reads
Twitter Talk Theatre, Episode 1: “RAID is good enough!”
But We’ve Never Had a Disaster Before!
This week, some of my Twitter followers were kind enough to chime in on...
2013-03-07
695 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers