Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Vasant Raj

SQLServerCentral.com profile

   Items 1 to 18 of 18   
 

Custom Report Item - Part I

This article will give a basic introduction of Custom Report Item in SQL Server 2005 Reporting Services.  Read more...
By Vasant Raj 2008/03/11 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,028 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.  Read more...
By Vasant Raj 2008/01/10 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 4,111 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.  Read more...
By Vasant Raj 2007/10/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,424 reads

Deploying Reports

Longtime SQL Server expert Raj Vasant takes a look at various ways in which you can deploy reports for Reporting Services 2005.   Read more...
By Vasant Raj 2007/06/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,782 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.   Read more...
By Vasant Raj 2007/03/15 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 20,978 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.   Read more...
By Vasant Raj 2007/01/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 13,725 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.   Read more...
By Vasant Raj 2006/12/04 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 13,745 reads

Making SA Work

There are quite a few changes in SQL Server 2005 and many of those relate to security. Did you know the sa account can be disabled by default? Longtime author Raj Vasant brings a basic look at connecting and authenticating in SQL Server 2005.   Read more...
By Vasant Raj 2006/11/14 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,106 reads

ConnectionStringBuilders in .NET 2.0

As a DBA you might not need to build connection strings for your servers very often, but developers certainly need to build these all the time and might contact you for help. Author Raj Vasant takes a look at the new capabilities of .NET 2.0, which can really help make this easier.   Read more...
By Vasant Raj 2006/08/01 | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 9,288 reads

XML - Good and Bad

XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.   Read more...
By Vasant Raj 2006/06/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,744 reads

Script Database Objects with SMO

One of the big changes with SQL Server 2005 is the evolution of SQL-DMO to the new SMO managed code assemblies. Author Raj Vasant brings us quite a bit of code to show how this can be used to script your objects.   Read more...
By Vasant Raj 2006/04/04 | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 14,924 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.   Read more...
By Vasant Raj 2007/11/09 (first published: 2006/03/22) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 23,674 reads

Using OpenXML Part II

XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.   Read more...
By Vasant Raj 2006/02/16 | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 8,329 reads

Exception Handling in SQL Server 2005

SQL Server 2005 brings us a number of enhancements, but the most important to T-SQL developers may be the changes to error and exception handling. The addition of the TRY CATCH structure is an important change and Raj Vasant brings us a look at this enhancement.   Read more...
By Vasant Raj 2006/02/02 | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 22,983 reads

Manipulating Text Columns

One of the lesser used features of SQL Server is the work with text variables. These data types cannot always be manipulated with regular T-SQL. Raj Vasant brings us an introductory look at the various functions you can use to work with these fields.   Read more...
By Vasant Raj 2005/09/28 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 17,493 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.   Read more...
By Vasant Raj 2006/10/20 (first published: 2005/06/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,216 reads

XML Simplified

Everyone should be aware that XML is supported in SQL Server 2000 and plays an integral part of not only SQL Server 2005, but all of the Windows family. IIS metadata, web services, etc. all involve XML. But do you know what XML is and how to work with it? Author Raj Vasant brings us a basic article on what XML is and how the documents are structured.   Read more...
By Vasant Raj 2005/05/23 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 13,006 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.   Read more...
By Vasant Raj 2007/02/23 (first published: 2005/05/12) | Source: SQLServerCentral.com | Category: openxml
Rating: |  Discuss |   Briefcase | 38,322 reads
   Items 1 to 18 of 18