Vasant Raj

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,293 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,305 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,756 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,350 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,057 reads

Blogs

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances

By

By Steve Bolton …………Each group of distance measures surveyed in this segment of the...

Midlands PASS: SQL Server Security Basics

By

Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly...

Read the latest Blogs

Forums

Generic grouping and counting enumeration values

By jonas.gunnarsson 52434

I have a questionnaire report and the questions is answered with A, B, C...

Need Help with DBMail sending Excell attachments with query results

By etvph81

Hello All, I'm having trouble trying to get this to work: This is the...

Mean Median Mode using SQL and DAX

By Gouri Shankar

Comments posted to this topic are about the item Mean Median Mode using SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers