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

Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)

The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...

Do you check to see if an SSIS package has been modified?

Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...

Holy Schnikes I’m Speaking at PASS Summit 2013

I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013...

I’m Not Presenting at PASS Summit 2013

Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing...