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

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

Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way.

I tested this on a SQL Server 2008 instance, having… Read more

Read more

Once upon a time a group of twelve bloggers agreed to each pick a post (or posts)  they found interesting from the previous year, blog about them, comment, and call attention to them. I was tapped to summarize things, and here we go.

On the twelfth day of Christmas Stuart… Read more

I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me to do it. I’m not consulting, and not planning on doing it anytime soon. If I studied enough to pass the lab, likely my skills would atrophy without some… Read more

Congratulations to the following winners of our iPads for Christmas contest. It was a hard choice, but I ended up with these winners:

• CC-597066
• DataChomp
• Scott Murray-240410
• richardn-1128243
• Michael Lysons
• chris.cantley
• Nick Van Dyk
• barb.wendling
• hghumphrey
• MdApache

I had over a 100 entries to go through, and it  took some… Read more

you can help me for the visule studio 2005 programe I have assigment
I do not how to use for these program
you can help me plase

That’s literally the text of an email that came to me at SQLServerCentral. Apart from the language barriers and issues, it is the… Read more

After my call for “What the Business Says Is Not What the Business Wants”, there were quite a few people that responded. Including my blog post, I found 43 comments posted on with links back to the thoughts.

Here’s a quick summary, along with a short comment… Read more

Tonight was the 2010 Denver SQL Server User group party. I typically haven’t done in the past to the holiday meetings since they aren’t usually well attended, and time is vey valuable. However this year the meeting was being held at a local bowling alley, and I decided to go. Read more

Despite my joking with Aaron Bertrand on Twitter that his suggestion on Connect got voted down because he’s Canadian, I think he has a great point with a hole in Books Online. He wrote a nice blog on the item, and it’s one you ought to consider voting up… Read more

Part 1

Part 2

Part 3

Read more

It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL Tuesday party. Most of them are of a decent length, and I need to get through them all to write a summary.

I’m hoping to get it done for… Read more

I’m hosting this month’s T-SQL Tuesday blog party, but that doesn’t mean I can’t participate. I posted the invitation last week, and hopefully we’ll have a large number of people participating today.

The Cost of HADR

I’ve dealt with a lot of business people over the years, and for… Read more

Read more

Last year I submitted a Connect item for SQL Server 2005 SP4. Quite a few people supported this item and voted for it, and Microsoft decided to build this last, final Service Pack for SQL Server 2005.

No timeline was given, but last week someone noticed that my Connect… Read more

I hate not living up to commitments. It really, really bothers me and I have tried hard in my career to under-promise and over-deliver. However I’m going to get a big fat #FAIL for SQL Saturday #45.

I found out last night that my son has his black belt test… Read more

• SQL Saturday…

Read more

Read more