We had a great turnout for this month. “Files and Filegroups” is an open enough topic that I got… Read more
This week, some of my Twitter followers were kind enough to chime in on a topic near and dear to my heart: the proper caretaking of SQL Server. Here is some of what we said.
Me: Common scenario: A company has databases, but… Read more
Hello and welcome to the third T-SQL Tuesday of 2013!
Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted.…
Let me introduce you to my friend, SQL Server 2012′s FileTable.
A Brief History…
I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s no way I can get to everything that’s happened in the last few days! So, here’s your weekly news update.
Update: The President’s cybersecurity Executive Order was signed and released today (see the Wired article). “Although the order comes after a number of failed attempts by Congress last year to pass cybersecurity legislation, the White House has indicated that it doesn’t see the executive order as a substitute for… Read more
One of the really great things about being married to an MCM is that I can
steal recycle his blogs, blame-free. Which is what I shall do today.
SQL Server clusters are widely used, and widely misunderstood, which makes people like our good friend (and clustering MVP) Allan Hirt cry bitter tears. So here are a few notes for you and yours.
Cluster IS NOT Disaster Recovery
A cluster does not protect against disaster. Unless it’s a very,… Read more
Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This was in some part due to many lessons I’ve learned over the years – everything from business and sales to storytelling and obsessive-compulsive record keeping.
But to a far greater… Read more
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of my more popular golden oldies, like this one (original post here: http://wp.me/pZM1Z-FE). And be sure to drop by our live weekly webshow, DBAs@Midnight, at 11pm Central time on… Read more
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of my more popular golden oldies, like this one (original post here: http://wp.me/pZM1Z-oB). And be sure to drop by our live weekly webshow, DBAs@Midnight, at 11pm Central time on… Read more
Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the same things again and again. Of course, these were the things (a) I was told when I was an aspiring blogger, or (b) I wish I had been told as… Read more
A while back, I wrote a simple little query that lets you Get Index Included Column Info (because sp_help and sp_helpindex only show non-included index columns). More recently, I’ve been wanting not only a better way to look at index information, but a way to compare indexes…for example, to find… Read more
Win Valuable Prizes!
Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn, because it ends right before PASS Summit (no, you don’t have to attend PASS to participate). Tom LaRock (Twitter, blog) and I are hosting!
Here’s what… Read more
Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the PASS Board of Directors. Due to various difficulties*, the resulting video is a
ridiculous-looking hack bit cobbled together, but the audio’s just fine. And really, isn’t it… Read more
Last week I received this comment/question from one of my fabulous First Timers:
I have a good natured question coming from an jaded old bitter DBA, what’s all the hype? I’ve been to a few conferences and I usually just show up, find the interesting or necessary presentations and go…
Hi there ho there everybody! It’s less than
five (FIVE!) three (THREE!) one (ONE!!) week until the 2012 PASS Summit in Seattle, I am now the Fearless Leader for a group of PASS Summit First-Timers! Again! This is the page wherein I record all of my sage advice and… Read more
On October 13, Dallas will hold our second ever Special Bi Edition of SQLSaturday Dallas - #SQLSat163 for you Twitter folk - and the day before that Sean is holding a precon titled Become an Enterprise DBA!
Edit: We have decided to offer all of the Enterprise DBA…