SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2010

2010 Goals Review

I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of those goals I met.

1 . Start A PASS Chapter
I filed the paperwork with PASS HQ in November and MagicPASS's first meeting will be Jan. 19, 2011. More details…

Read more

2 comments, 1,567 reads

Posted in Kendal Van Dyke on 31 December 2010

XQuery for the Non-Expert – Substring() Function

Talk to the Experts

Within the value() and query() methods it is sometimes desirable to return a portion of a string.  Similar to T-SQL, there is a substring function in XQuery that… Read more

0 comments, 1,728 reads

Posted in StrateSQL on 31 December 2010

Happy New Year

Well it’s Friday again and another big day.

Hopefully you all had a great Christmas and as we move to a New Year, the end of 2010 and start 2011 I’d like to wish everyone Happy and prosperous New Year.

Read more

0 comments, 1,467 reads

Posted in The SQL DBA in the UK on 31 December 2010

2010 - A Year without Specific Goals

In previous years I had set goals and even if I didn't fully achieve them, they were helpful in giving me targets and I was able to grow because of them. 2010 began and I didn't set any goals. Truth be told, I was in much of a fog because… Read more

0 comments, 2,076 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 December 2010

The Year of Change: 2010 In Review

Like clockwork, another year has come and (almost) gone.  It’s been a wild year on many fronts: major happenings included the devastating Haiti earthquakes, the signing into law of a landmark healthcare “reform” bill, a major debacle over the use of body scanners and intimate pat-downs at TSA airport security… Read more

2 comments, 1,561 reads

Posted in Tim Mitchell on 31 December 2010

Blogging on Blogging

So I must confess that my blogging efforts to date have been on the impersonal side – perhaps even a bit sterile.  I really admire bloggers who post daily and weekly, and seem to have interesting things to say about common and simple things.  In the coming year, I’d like… Read more

0 comments, 1,423 reads

Posted in SQL Server BI Blog on 31 December 2010

Quick MCM Prep Help

Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4 or 5 before I left, dropping the MP3s on my iPhone, and I listened to a few of them on the drive to Steamboat Springs.

That worked out so…

Read more

1 comments, 1,596 reads

Posted in The Voice of the DBA on 31 December 2010

Windows Cluster Scripting with WMI and PowerShell

Windows 2008 R2 includes a failoverclusters PowerShell module, but you’ll probably find normal usage limiting for several reasons:

  • Only works on Windows 2008 R2 clusters
  • Requires the cluster service which in effect makes it difficult to run remotely except via PSRemoting
  • Implements specialized data types instead of using WMI

Although… Read more

0 comments, 2,711 reads

Posted in Chad Miller on 31 December 2010

2010 PASS Summit Interviews

It’s entirely fair to say that the highlight of my professional year is the PASS Summit in Seattle, and the highlight of the Summit is the recorded interviews we do each year (starting in 2009).

The way we pick interviews is, we say “Who do we like, and/or is… Read more

3 comments, 1,769 reads

Posted in SQL Awesomesauce on 30 December 2010

Can You Dig It? – StmtSimple Element

She can dig it!
D Sharon Pruitt

We’re up to the seventh post on the in the plan cache series.  This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element.  StmtSimple, commonly referred to as statement simple, can contain… Read more

0 comments, 1,940 reads

Posted in StrateSQL on 30 December 2010

Video: Interview – Part 1: Quest Software

Heather Eichman interviews Kevin Kline, the former President of PASS and strategy manager for the SQL Server business unit at Quest Software.

Posted January 24, 2008.

Read more

0 comments, 1,402 reads

Posted in Kevin E. Kline on 30 December 2010

Looking Back at 2010

I’m writing this the day before Xmas, trying to finish up a bunch of odd tasks before the holiday weekend begins. As I look back at my goals and experiences for the year, it’s mixed emotions for me. I ended up sacrificing some goals to make others happen, a decision… Read more

0 comments, 1,426 reads

Posted in SQLAndy on 30 December 2010


I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The long and short of it, these were the people whose blog’s I had read the most throughout the year. There are many other great blogs and bloggers out there that… Read more

2 comments, 1,891 reads

Posted in The SQL DBA in the UK on 30 December 2010

Wiring up a common click event handler in an ASP.NET page

I was just refactoring a server-side control and ran into some horrible code.  Basicaly there was a big listbox that was supposed to hold people's names with letters A through Z to the left which were ASP.NET LinkButtons.  lnkBtnA, lnkBtnB, etc.  Each link button had its own click handler whose…

Read more

0 comments, 3,076 reads

Posted in New York City .NET on 30 December 2010

Reviewing My 2010 Goals

You can go over my goals here.  I’ve really hesitated to do this post because, in my opinion, I did so poorly.  Here’s what I did:


  1. Write 1 article per quarter for SQLServerCentral. – Fail.  I don’t think I wrote one article this year.  Sorry, Steve.
  2. Submit…

Read more

2 comments, 1,406 reads

Posted in Wise Man or Wise Guy on 30 December 2010

MCM Prep - VLF Allocations

I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues. Kimberly Tripp has a great blog on how to get better performance from your log, but until I was studying for the MCM, I didn’t realize you could have… Read more

3 comments, 1,901 reads

Posted in The Voice of the DBA on 30 December 2010

A Change of Pace

As some of you may have already heard, I spent much of December moving from Hawaii to Missouri. Generally, when I tell people this, they ask if I am crazy. One important reason for the move is work-related, as it will be much more convenient, and less expensive, for me… Read more

2 comments, 1,536 reads

Posted in SQL Aloha on 29 December 2010

Updated SQL 2005 and 2008 Diagnostic Queries

Since it is almost January 2011, I thought I would post the January 2011 versions of the SQL Server 2005 Diagnostic Information Queries and the SQL Server 2008 Diagnostic Information Queries.

To go with them are the matching blank results spreadsheets for SQL Server 2005 and SQL Server 2008 Read more

1 comments, 2,238 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2010

Looking Back at 2010–Goal Review

I had 8 goals for 2010, which I posted at the end of last year. That reminds me, I need to work on goals for 2011

These were a variety of work, community, and professional goals that I set with, thinking that I would be able to achieve these… Read more

1 comments, 1,802 reads

Posted in The Voice of the DBA on 29 December 2010

SQLMeetings.com Is Live!

You heard right, I’ve finished with the 1.0 release. It isn’t pretty but it works. If you need a primer check out my last post. If you need a list just fill out the form and I’ll get you taken care of.

Lets take a look at the features:

  • Create…

Read more

0 comments, 1,532 reads

Posted in SQL Man of Mystery on 29 December 2010

Older posts