Posts by: Sean McCown
Well, I actually have a love/hate relationship with speaking. I’ve read that there are 2 types of speakers, those who get nervous before going on stage, and liars. Sure, I don’t expect that you’ll have the same level [...]
I’m a fraud because I didn’t bust out the query I needed right away.
I’m a fraud because I couldn’t remember the exact syntax to restore a certificate even though I’ve done it dozens of times.
I’m a fraud because a [...]
I was helping someone out with something so I thought you guys would like to have these 2 short lines of code that can be pretty useful. Here I’m going to show you how to check your DB for tables that [...]
I just got this question in the user group and thought I’d write a blog instead of just answering a sub-set of users who could benefit from it. The question was:
I have customized the values of the Auto growth according [...]
MidnightDBA.com has gotten a much needed facelift. We can now be seen by all browsers as well as mobile.
We’re not sitting on our laurels though, we’ve got some pretty cool stuff planned for the coming weeks. This is just [...]
When I teach powershell the question I get from DBAs most often is what is an overload. Because when we get into methods you can’t go very long at all without stating that they’re overloaded and most DBAs just don’t live [...]
I got an email from a user at another company today and he told me about the SQL 2012 upgrade they just finished. And apparently it was a disaster. Here’s the general gist of what happened.
They have a huge app [...]
I know the world is full of DR plans and DR advice, but this is honestly the last DR plan you’ll ever need. I’m not sure what made me think of it, but it popped into my mind on the way [...]
As DBAs we quite often run into others who aren’t as smart as us. The dev is an idiot. The .net guy is an idiot. The users are idiots. The manager is an idiot. The VP, well don’t even get me [...]
This is my submission for T-SQL Tuesday on Files and filegroups. You can find the blog .
One of the things I’m known for in the shops I work in is giving my DBAs some interesting exercises. And sometimes [...]
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
SQL Cruise with me…
We'll be on the January 2013 cruise to the Bahamas, teaching and learning SQL and having a GRAND time after hours...all for the less money than a week of "normal" SQL training. Join us!
ITBookworm.com!- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey
- Quick Review: Logitech Trackball
- Book Review: Microsoft SQL Server 2008 Internals, by Kalen DeLaney et al
