Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, for the last few years quite some time now.  The site is in early version, “just get it working right” mode. But you will notice:

Read more

1 comments, 297 reads

Posted in SQL Awesomesauce on 2 April 2013

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 it’ll go get itself a fast car in the upcoming months.

We had a great turnout for this month. “Files and Filegroups” is an open enough topic that I got… Read more

1 comments, 393 reads

Posted in SQL Awesomesauce on 18 March 2013

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

3 comments, 339 reads

Posted in SQL Awesomesauce on 7 March 2013

Invitation to T-SQL Tuesday #040: File and Filegroup Wisdom

Hello and welcome to the third T-SQL Tuesday of 2013!

Over three years ago, Adam Machanic (Twitter) dreamed up the idea of T-SQL Tuesday:

Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted.…

Read more

6 comments, 315 reads

Posted in SQL Awesomesauce on 5 March 2013

FileTable: SQL Server 2012's little gasp-maker

When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”?  Was it around March of last year? No? Then you might have missed something really, really cool.

Let me introduce you to my friend, SQL Server 2012′s FileTable.

A Brief History…

Read more

6 comments, 987 reads

Posted in SQL Awesomesauce on 2 March 2013

We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)

Your MidnightDBAs

Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting podcast Thursday Feb 28, 2013 at 9:30PM EST here. You know, if you want to.

Onward!

-Jen McCown
http://www.MidnightDBA.com/Jen

Read more

1 comments, 385 reads

Posted in SQL Awesomesauce on 27 February 2013

23 Pieces of News and Fluffery (Feb 9-15)

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.

Actual News

CISPA is back, as I mentioned… Read more

1 comments, 327 reads

Posted in SQL Awesomesauce on 15 February 2013

#CISPA’s Coming Back: Time to Pay Attention Again

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

1 comments, 391 reads

Posted in SQL Awesomesauce on 12 February 2013

Install .NET Framework using #Powershell (#TSQL2sday!)

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.

Sean wrote a great blog post in 2010 entitled “Today’s Powershell Fun“. Long and short, he shows you how to… Read more

0 comments, 504 reads

Posted in SQL Awesomesauce on 12 February 2013

Clustering Concepts for the Common Man

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

2 comments, 502 reads

Posted in SQL Awesomesauce on 29 January 2013

Talking on Purpose

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

0 comments, 468 reads

Posted in SQL Awesomesauce on 10 January 2013

Great Tools for Formatting T-SQL

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

0 comments, 516 reads

Posted in SQL Awesomesauce on 10 December 2012

T-SQL: CASE Statement

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

0 comments, 2,905 reads

Posted in SQL Awesomesauce on 3 December 2012

Tip: OVER and PARTITION BY

I like to repost this blog about once a  year, because you really really need to know about windowing functions. So, happy November! Here’s a quick summary of OVER and PARTITION BY (windowing functions, “new” in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to get aggregate…

Read more

0 comments, 3,682 reads

Posted in SQL Awesomesauce on 26 November 2012

Blogging for Beginners

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

4 comments, 576 reads

Posted in SQL Awesomesauce on 20 November 2012

Find Duplicate (and covered) Indexes

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

0 comments, 688 reads

Posted in SQL Awesomesauce on 11 October 2012

Lose #5 Before #sqlpass

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

0 comments, 518 reads

Posted in SQL Awesomesauce on 10 October 2012

Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!

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

0 comments, 419 reads

Posted in SQL Awesomesauce on 9 October 2012

PASS Summit: What’s all the hype?

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…

Read more

0 comments, 483 reads

Posted in SQL Awesomesauce on 8 October 2012

PASS First Timers Guide and Schedule – 2012 edition

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

6 comments, 606 reads

Posted in SQL Awesomesauce on 3 October 2012

Newer posts

Older posts