SSIS and Oracle All Your Non-options

Why do some things have to be so hard?
I have been asking myself that question for the better part of...

Is #SQLPASS helping their speakers?

I love the SQL Community because it usually is a great environment to connect, share and learn. With that said,...

Building Dynamic SSRS Reports with Analysis Services Recording and Code

Thanks to all who attended my webinar last Thursday on Building Dynamic Cube Reports.  You can find my code
Recording:
http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/WebinarDetails.aspx?ResourceId=470
Code:
http://sdrv.ms/RqxbcF
There are...

Transaction Log Internals - My session ingredients

Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).
While seeing...

Customize the Management Studio Toolbar

Management Studio is great tool with almost everything you need right at your fingertips.  Notice I said "almost".  I like...

Quick tip: Count table rows in a database, and locate those rows in the data files.

Here are a couple of quick database and table level queries that I have found useful lately.
How many rows in...

Microsoft Surface RT Review

Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in...

Countdown to PASS Summit 2012 – 8 to Go – What Is PASS Anyway?

Eight days to go. So after going to my first conference, I was surprised that I did not know more...

Lost in Translation – Deprecated System Tables – sysindexes

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

Monitor Blocking with Extented Events in SQL 2012

1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

here we...