Last weekend at SQL Saturday #63 Dallas, I presented a session titled “How to Curse in an Interview”. It clearly contains some NSFW language, but it was really a good session, and I got a lot of positive feedback. The recorded session is up on the MidnightDBA Events page. Here is the abstract: How to curse … Continue reading How to Curse in an Interview →
Here’s the first of a series of backup/restore classes taught at the NTSSUG. This series is meant to cover everything about backups… or at least as much as we can squeeze into 6 sessions. You’ll learn how to put together an enterprise backup solution, tune your backups for maximum performance, and manage them across your … Continue reading Best Backup Class Evar: 1 of 6 →
OK, it’s time for TSQLTuesday again and Jen’s making me write something since we’re hosting this month. So the topic is resolutions, and that in itself isn’t a topic that’s near and dear to me because frankly I just don’t believe in them. I don’t think you have to wait until a new year begins … Continue reading T-SQL Tuesday #014 – Resolutions →
This is gonna be a quick post, but I wanted to throw out a couple easy ways to avoid using xp_cmdshell. Unfortunately this xp has gotten a bad rep, but only because it’s been abused. If you use it properly there’s no reason why you can’t continue to get some good use out of it … Continue reading Avoiding xp_cmdshell →
FileTable is another new feature in Denali. FileTable is the next generation of FileStream. What this allows you to do is copy files into specified folders on your server, and they automatically get stored in SQL. So you define a FileTable in SQL and point it at a folder. Now, anything you put in that … Continue reading FileTable is here →
I’m being forced off of my powershell kick here for a few mins to talk about viruses. Why do companies refuse to allow scanning exceptions for DB files? Do you really think that anyone’s written a SQL virus? I really can’t remember ever having see an actual virus that attacks SQL files. Actually, I take … Continue reading A Nice SQL Virus →
It may seem a little redundant, but I love stuff like this. I was asked in front of a group of devs to script out a group of SPs on the prod box and copy them over to the new test box. These SPs stretch across a couple schemas and are named differently from the … Continue reading Poweshell wins again →
Ok, so one of my last posts talked about using a cursor for something and I came upon some criticism and/or some wincing about the fact that I used that horrible word. However, cursors like anything have gotten a bad rap (xp_cmdshell is another). People, there’s nothing wrong with using cursors as long as it’s … Continue reading Who’s afraid of cursors? →
Here’s a list of where I’ll be: January 30 – SQL Saturday Austin #461 June-ish – SQL Saturday Houston August-ish – SQL Saturday Baton Rouge August-ish – SQL Saturday Oklahoma City October 25-28 – PASS Summit 2016 Past An imcomplete list of where I’ve been… 2014 April 14: Oklahoma City SQL UG’s 5th Anniversary April 28-30: Powershell … Continue reading Where’s Sean? →
Hi, I’m Sean, and DBA Rant is my blog. Here I talk about SQL Server and other tech topics, plus MidnightDBA news and SQL community updates. Together, my wife Jen McCown and I video and write and run all things MidnightDBA. What I Do Here’s a list of all the things I do online: Blog This blog, … Continue reading Stuff I’m Doing →