Using Multiple Active Result Sets (MARS)

  • Article

SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.


2,563 reads

Adding Custom Code To Reporting Services

  • Article

Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.

4.9 (10)

2008-01-15 (first published: )

21,251 reads

Data Driven Subscriptions for Reporting Services (2000 and 2005)

  • Article

Reporting Services has proven to be one of the more useful subsystems of SQL Server. However the standard editions of both SQL Server 2000 and SQL Server 2005 have limitations with regard to the subscription features. Jason Selberg brings us an updated version of his
code for extending the subscription feature.

5 (6)

2008-01-22 (first published: )

26,184 reads

New T-SQL Features in SQL Server 2005 Part 2

  • Article

SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a dizzying array of new features and enhancements. Sureshkumar Ramakrishnan brings us the second part in a series looking at what these changes do and how to use them.

4.11 (9)

2007-11-28 (first published: )

20,149 reads

Source Control in SQL Server

  • Article

One of the most requested features from SQL Server developers is the integration of source control with T-SQL code. SQL Server Management Studio brings some integration with Visual Source Safe and longtime SQL Server author Raj Vasant explains it to us.

2.14 (7)

2007-11-30 (first published: )

13,890 reads


Data Saturday #8–Southwest US


I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1


I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala


I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs


Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Search all Tables in DB for a String but using Postgres - What is the difference

By Oscar_Boots

Hi Forum, I want to search a Database for a String value and I...

SQL 2016 - Need help with complex calculations based on paycodes - New Changes

By DiabloSlayer

Hello Friends, Posting this for help as the client made more requirement changes. I...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers