Enable CLR with Powershell

I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...

Last Weeks Top “Reading” Links #82

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

SQLSaturday #305 Business Analytics Edition Dallas–RECAP

So, I am flying home thinking about the event Saturday and many things are running through my head. No, not...

SQLServerCentral Editorial: Better, Faster, and Cheaper

Better, Faster, and Cheaper was published today and I hope you’ll read it, and then challenge your own assumptions for...

SSMS Add-ons

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on...

Where are my 32-bit Perfmon Counters?

I have run into this before, but not in this same way, so I decided it would be worth writing...

Why is there a sysobjects when we already have sys.objects?

Once upon a time in a version of SQL far far away we had system tables that were easy to...

A few words about simplicity: Using Red-Gate Ecosystem framework

In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...

Presentation Slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas.  The abstract is below.  Great...

PROVIDING LOGGING INFORMATION AT COMMAND LINE

For providing logging information at command line utility use the option /l

for example

dtexe /f "some path" /l "logging type; connection...