Vasant Raj

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

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2006-11-14

4,125 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2006-08-01

9,363 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2006-06-05

9,779 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2006-02-16

8,377 reads

SQLServerCentral Article

Exception Handling in SQL Server 2005

SQL Server 2005 brings us a number of enhancements, but the most important to T-SQL developers may be the changes to error and exception handling. The addition of the TRY CATCH structure is an important change and Raj Vasant brings us a look at this enhancement.

4.09 (11)

You rated this post out of 5. Change rating

2006-02-02

23,124 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2005-05-23

13,323 reads

Blogs

The Importance of Patch Management to Avoid Downtime

By

A recent Microsoft outage caused by a bad patch pushed out to Windows instances...

Friday Flyway Tips–Comparison Defaults

By

One of the little details that I find matter more and more in enterprises...

A New Word: Solysium

By

solysium – n. the unhinged delirium of being alone for an extended period of...

Read the latest Blogs

Forums

AG-Group primary during reboot

By mlorek

New to ag groups.  I have a 2 node aggroup.  We are doing maintenance...

Synapse Analytics History I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Synapse Analytics History I

A Programmer's Attitude

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Programmer's Attitude

Visit the forum

Question of the Day

Synapse Analytics History I

Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud?

See possible answers