Vasant Raj

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

Querying System Tables

It is not recommended, but there is quite a bit of valuable information stored in the SQL Server 2000 system tables. Raj Vasant brings us a look at some of the information that you can get by directly querying the system tables and explains what is stored in a number of them, including gathering information about computed columns.

3.6 (5)

2006-10-20 (first published: )

39,365 reads

ConnectionStringBuilders in .NET 2.0

As a DBA you might not need to build connection strings for your servers very often, but developers certainly need to build these all the time and might contact you for help. Author Raj Vasant takes a look at the new capabilities of .NET 2.0, which can really help make this easier.

2006-08-01

9,320 reads

XML - Good and Bad

XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.

2006-06-05

9,767 reads

Using OpenXML Part II

XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.

2006-02-16

8,362 reads

XML Simplified

Everyone should be aware that XML is supported in SQL Server 2000 and plays an integral part of not only SQL Server 2005, but all of the Windows family. IIS metadata, web services, etc. all involve XML. But do you know what XML is and how to work with it? Author Raj Vasant brings us a basic article on what XML is and how the documents are structured.

2005-05-23

13,093 reads

Blogs

Getting Started with Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

How SQL Server stores data types: DATETIMEOFFSET

By

If you’d like to check out the previous instalment in this series on storing...

Daily Coping 16 Jun 2021

By

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

Read the latest Blogs

Forums

Inventory toolkit issues

By mtz676

Anybody has run into MAPS assessment toolkit installation issues for sql server 2019/2017.Also maps...

Have an emergency. Prod is down.

By ALearningDBA

Our prod server is down. I was applying a security patch on our secondary...

Help with Boolean check box combinations

By Hogie503

Hi SQL Experts, I have a Store Procedure with snippets of code listed below....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers