We Need More Folks in Technology, Period.

I took my boys to a game design workshop on Saturday that was sponsored and put on by an organization...

The Effective Permissions Tool is Handy

An recurring issue with Integration Services packages that read or write to file systems is permissions issues.  It's quite difficult...

Denali – Day 13: FileTable

Denali – Day 12: FileTable

“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated...

Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London!

As you might know, I'm
running my "SQL Server 2012 Deep Dive Days Workshop" from May 28
– 30 in Central London....

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