Deploying Reports
Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005.
2008-04-16 (first published: 2007-06-05)
21,297 reads
Vasant Raj
- Interests: Learning new things, Playing Table Tennis and watching English Premier League...
Custom Report Item - Part I
This article will give a basic introduction of Custom Report Item in SQL Server 2005 Reporting Services.
2008-03-11
7,354 reads
Adding Custom Code To Reporting Services
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.
2008-01-15 (first published: 2007-03-15)
21,408 reads
Navigation Options in Reports
You can build some very complex reports in Reporting Services and longtime author Raj Vasant brings us a short tutorial on how you can implement internal navigation structures in your reports.
2008-01-10
4,875 reads
Document Your Database
Computer professionals are constantly complaining about the documentation for the software they use. And are notorious for not documenting their own code very well. Longtime author Raj Vasant brings us a short article with some suggestions on how to go about documenting your databases.
2008-01-02 (first published: 2007-01-11)
13,813 reads
Source Control in SQL Server
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.
2007-11-30 (first published: 2006-12-04)
14,019 reads
Working With SqlParameter in .NET
Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand.
2007-11-09 (first published: 2006-03-22)
24,097 reads
Distributing SQL Server Databases
Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.
2007-10-22
5,508 reads
Querying System Tables
It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.
2007-10-02 (first published: 2005-06-13)
39,420 reads
Using OpenXML
SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.
2007-10-02 (first published: 2005-05-12)
41,047 reads
Blogs
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Forums
Create Alert for Number of connection
I have 2 columns , Count and Datetime I need to send alert for...
SQL Query Question
Hello everyone, Thank you for looking into my question. I have a dataset like...
"Frankenrows"
I'm not sure if that's the correct term for what we're seeing here, but...
Ask SSC