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,823 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,344 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

Use Jupyter Notebooks to Help People on StackOverFlow

By

I am sat in the PowerShell Saturday in Hamburg. You can see me on...

ACM Lecture at SELU

By

Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Read the latest Blogs

Forums

Needed to find all possible Dates Overlaps from a single Table

By Hell-1934

Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...

Optimize Cursor

By GrassHopper

I inherited this script that has a cursor and I know this query can...

Unable to add secondary node existing node due to DCOM is unavaialble

By maroju1

Dear Team, This is Naveen, Hope all are doing well. I need emergency help...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers