Vasant Raj

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,827 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: )

39,444 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,115 reads

Blogs

Daily Coping 30 Mar 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Error handling protip: @@Error resets after the next command

By

The system variable @@ERROR is a quick and easy way to retrieve the error...

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

By

Introduction Recently have been working on a “Proof of Concept” task where I wanted...

Read the latest Blogs

Forums

The Coping Thread

By Steve Jones - SSC Editor

I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...

Get the difference from one record to the one previous

By Meridian9300

In it's simplest form I want a table that I can use to store...

Regarding for Microsoft Azure Certification

By Ankitdixit

Hello Everyone, I am new here and I am preparing for microsoft azure certification...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers