Vasant Raj

  • Interests: Learning new things, Playing Table Tennis and watching English Premier League...

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.

1.61 (18)

2008-01-02 (first published: )

13,811 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.

2.14 (7)

2007-11-30 (first published: )

13,890 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.

4.5 (2)

2007-02-23 (first published: )

40,387 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.

1 (1)

2006-11-14

4,117 reads

Blogs

Daily Coping 6 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

All jobs that ran during a given time frame.

By

Short post today. Simple query that will tell you every job that ran between...

Instructions for Handling Errors of MySQL and PHPMyAdmin

By

One of my clients, Justin Williams, is a blogger. He owns a website named...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

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

Self-Joined to Find if Archived Versions of Record Exist w/o Duplicate Records

By brandon 94807

I have a table keeping client notes that can be updated and the previous...

Licensing question

By noobdba

Thinking of getting a perpetual standard licensing with certain number of cores. Was wondering...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers