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

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