MVP Open Day South Asia was held in Hyderabad from Jan 20, 2010 to Jan 23, 2010. This event was a fun-filled as well as an educational event. This event was held at Microsoft IDC at Hyderabad – the largest Microsoft Development location after Redmond. I had a great time meeting my friends and some of the renowned experts from all over the South Asia. The whole event started with networking with other MVPs as well with Product Group members.
SQL SERVER – Question – How to Convert Hex to Decimal
In one of the recent projects, I realize the bottleneck of the query was an inline function which was converting Hex to Decimal. I optimized the inline function and reduced the query running time to one-tenth of the original running time. Later, I was eager to find out the script…
Read More
SQL SERVER – Location of Resource Database in SQL Server Editions
While working on a project of database backup and recovery, I found out that my client was not aware of the resource database at all. Location of Resource.
SQL SERVER – Several Readers Questions and Readers Answers
I often get questions on blog and many times I even get answers from readers as well. This article is collection of few of the questions and answers by readers of this blog. Q. How the records of a table can be scripted in INSERT INTO statements? A. In SQL…
Read More
SQLAuthority News – Leadership Quotes and Inspiration
There is a big difference between leader and manager. There are plenty of interesting details written on this subject on the internet. In a recent presentation on leadership of one of the organizations I have presented a few of the quotes on the leadership subject to them. The leadership quotes were very much appreciated by the team so I am writing them over here.
SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend
Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills…
Read More
SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010
Microsoft has announced that SQL Server 2008 R2 will be available by May 2010. Its CTP (Community Technology Preview) version was already available from August 2009. It is still available for download.
SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008
Troubleshooting Performance Problems in SQL Server 2008 SQL Server Technical Article Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya Published: March 2009 It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQL…
Read More
SQL SERVER – Find Statistics Update Date – Update Statistics
Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…
Read More
SQLAuthority News – Download Sample Database for Microsoft SQL Server
This post is a response to one of the most asked questions where to get Sample Database for SQL Server 2008. The name of the new sample database is AdventureWorks.