One of the most common problem SQL Server developers face while dealing with XML is related to writing the correct XPath expression to read a specific value from an XML document. I usually get a lot of questions by email, on my blog or in the forums which looks like the following:
SQLAuthority News – Price List – Oracle vs SQL Server
During one of the consulting project, I was asked to prove that the SQL Server is a more economical choice than Oracle. Well, I do not want to start again the battle, which has been clearly won by SQL Server. Summary: SQL Server is a feature-rich and economical choice compared…
Read MoreSQL SERVER – TRANSACTION, DML and Schema Locks
Today we will be going over a simple but interesting concept. Many a time, I have come across the lack of understanding on how the transactions work in SQL Server. Today we will go over a small but interesting observation. One of my clients had recently invited me to help…
Read MoreSQL SERVER – Free Download – SQL Server 2008 R2 Update for Developers Training Kit
SQL Server 2008 R2 is released and have been a stable product since the day it is released. I have not received any complains or rants from any of my customers who has upgraded to this version. The number one request is how one can learn about the new features…
Read MoreSQLAuthority News – Delivering Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010
SQL Server Community is very strong community world-wide. In India SQL is considered as one of the most popular technology. Chennai is the only city in India where there are more than 3 SQL Server MVPs are from. My MVP friends has arranged one of the very first whole day…
Read MoreSQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver
Madhivanan (SQL Server MVP) is a real community hero. He is known for his two skills – 1) Help Community and 2) Help Community. I have met him many times and every time I feel if anybody in online world needs help Madhivanan does his best to reach them out…
Read MoreSQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache
This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually…
Read More