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

Connecting a service between Publishing and Consuming SharePoint 2010 farm

Hello Friends,

As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting...

Cumulative Update – 11 for SQL Server 2008 SP3 Is Now Available !

The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 11 contains all...

Database index design and optimization: Some guidelines

Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response...