SQL Standards

Three posts, three critical rants. It's time to be constructive.

I was given the responsibility to decide on the SQL development...

SQLPSX 2.3.1 Release

We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an...

SSIS: great idea, but buggy as heck.

Oh SSIS, how I love and hate you.

As DBA at my company, I don't actually develop much in SSIS. But...

RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...

Come be your best with Pragmatic Works

Have you been trying to figure out how to take your career in Microsoft BI, SharePoint and SQL Server to...

SQL Server 2008 R2 System View Map

It’s a map!Have you been looking for something inside the system views of SQL Server 2007 R2 and haven’t known...

IT Education Part 2

For those thinking about an IT career the options are bewildering, and I think the education establishment doesn’t do a...

12 Days of SQL, On the 2nd Day of SQL…

Microsoft gave to me, an excellent new management language. Yeah, so it doesn’t rhyme or match the song in any...

SQL Saturday #45 Cancelled

I hate not living up to commitments. It really, really bothers me and I have tried hard in my career...

2 of my favorite new T-SQL features in SQL Server Denali (SQL 11)

Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community
Summit in Seattle last year. Since this...