Great Tools for Formatting T-SQL

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...

Last Weeks Top 10 “Reading” Links #10

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out...

SQL Server Books–Query Tuning

Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization...

Partitioning Table in SQL Server:

Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....

Is Self-service BI Threatening IT Professionals’ Livelihoods?

(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...

SQL Server Consulting Blog–Sunday Stats

I’m going to continue with my series of posts on analysing how well my SQL Server Consulting blog has done...

SQL Saturday #173 Washington DC wrap up

Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...

SSIS: Character Replacement Using the Script Component

When cleansing data from source systems to store in a data mart or warehouse, we often need to remove or...

Sending Querying Data on Mail as Attached File

Sending
Querying Data on Mail:

Sometimes we need to send data fetched from query on
mail automatically. You can 
create report and after running...

Debugging Parameter Dependencies in Reporting Services

Creating a report with two datasets that reference the same pair of parameters, I’m seeing the following error: The Value...