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,810 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,811 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: )

38,581 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

Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions

By

In this article, we will focus on creating a data pipeline to ETL (Extract,...

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Read the latest Blogs

Forums

Select n records in table X from a field on table Y

By luisalfonso70

Hi, hope someone can help with this. I've the table gifts_to_give: Id_give      number_of_gifts          name ...

Select n records in table X from a field on table Y table

By luisalfonso70

Hi, hope someone can help with this. I've the table gifts_to_give: Id_give      number_of_gifts          name ...

Error: 17892 Severity: 20 State: 1

By ismahar

Hi, I've been struggling for 5 days to solved this issue. We have a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers