PASS Data Architecture VC presents Mike Fal: SQL Server Table Partitioning

Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...

SQL Rally 2012 Recap

Much Learning Was Had By All
SQL Rally 2012 had a diverse group of speakers and something for all levels of...

SQL Server – Check SQL Agent Job History using T-SQL

To check SQL Server Agent Job History you can use the Log File Viewer from SQL Server Management Studio.
To Open...

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 to have a package run properly when it can't...

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

Varied and Interesting Links

Here are some things I’ve run across in the past few weeks you may find interesting:
FailCon. Billed as a one-day...

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

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

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

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