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,861 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,178 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

2020 Advent of Code–Day 1

By

This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)

By

Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series

By

Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs

Forums

How to find index usage by stored procedure?

By SQL Guy 1

Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...

Odd things with Report Builder (also tried VS 2019)

By kevlray

This is kinda hard to explain, maybe I can make sense of it. So...

PBM policy to check empty passwords

By Lou

Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers