SQLRally 2012-Closing Thoughts

It was interesting to watch an event that started 17 months ago with Dallas, Nashville, and Denver submitting applications to...

SQLRally 2012-Friday

Started the day early, heading to the Convention Center to be at Starbucks at 6:45 for the networking event I...

Use Powershell script to verify backup files

Before restoring backup, we always verify the backup file first, and run the 3 command below:

1. RESTORE HEADERONLY
    Returns a result...

Slides & Samples for my SQLConnections sessions

As I have announced announced in my sessions at the SQLConnections conferences in
Berchtesgaden/Germany, you can find my session materials (slides...

SQL Treeo – Extended properties or local file – please vote

Hi,
I was trying to solve SQL Treeo’s performance issue on slow connection. This posts is also covers feature request of...

Denali – Day 12: More Manageability Features

Denali – Day 12: – More Manageability Features:

-K switch
With new feature added in an engine to use that feature with different way...

I’m back !

Hello Everyone – its been a while.
I’ve been out of the blogging scene over the last year or so due to...

New Blog

There areso many DBA in HK but I cannot find any good SQL server related blog or forum, so target...

SQL Rally Wrap Up

Another SQL Rally has wrapped up in Dallas, TX and it was great event.  My favorite part about these larger...

One Way To Insert Many Rows Very Fast From Your .NET Application

This is my attempt to explain something that I have wanted to figure out for a long time.  I have...