SQL Server – Marking a stored procedure as system object

Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...

SQL Server Database SUSPECT state

According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged....

Using Configuration Tables in SSIS 2008/2005

SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...

Want to browse the web faster?

In our day-to-day activities, browsing the web is one of the most important aspects of our job.  Whether researching for...

An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors

This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...

Dataset with Text or Stored Procedure

As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...

Slides & Samples from my SQLbits sessions

As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...

SQL Saturday 85 Follow Up

Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve...

SQL Saturday 97 has ended

Well it isn’t quite over for me just yet, I still have a flight home tomorrow and can’t wait to...

24 HOP recordings

For all of you, that you have missed any session from the last 24 HOPass - you can check here

24 Session...