Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

Today I will talk about a book  titled  ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.

When I...

Business Objects on Linux and SQL Server

This is just a quick post to share a lesson learned while I was on an engagement where the client’s...

DR planning article up at MSSQLTips!

My latest article is up at MSSQLTips.com:
 
Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
 
For more of...

Exploring Excel 2013 for BI Tip #7: Retaining Pivot Table Size After Data Refreshes

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Giving an SSIS security webinar with Andy Leonard

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May...

I’m presenting at the PASS Summit!

I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October...

Speaking at SQL PASS Summit 2013

WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can...

SQL Server – Get the Default Data File and Log File Location using T-SQL Query

In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query...

The many uses of CROSS APPLY

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...

Blocking – Capturing and Monitoring

If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....