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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

Community

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

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

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

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

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

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