Feeds:
Posts
Comments

Archive for the ‘SQL Tips and Tricks’ Category

K-MUG organized TechEd Trivandrum on 27th June, 2009. They even launched an official PASS Chapter in Trivandrum. The complete report of this event is here. This event like TechEd in Ahmedabad,  was a huge success and saw a huge number of attendees from all over India. Jacob Sebastian and Pinal Dave had presented two solid [...]

Read Full Post »

Murach’s SQL Server 2008 for Developers (Murach: Training & Reference) (Paperback)
by Bryan Syverson, Joel Murach

Link to Amazon
Short Summary: Murach’s SQL Server 2008 for developers is an ideal book for all developers, and particularly, it is an excellent book for training and reference. If you are new to SQL, no problem! This book is the best [...]

Read Full Post »

DotNet Buzz Delhi is organizing TechEd Delhi on July 11, 2009. Not just this, they are launching an official PASS Chapter in Delhi. The Agenda of the event is here and if you are around Delhi do not miss the opportunity to be a part of this upcoming great event. If you are keen to [...]

Read Full Post »

Today, we have a very basic thing to go over. Few days back, I was discussing with one of my friends regarding BI. He told me that he knows that BI stands for Business Intelligence but he would like to know what languages BI uses to achieve the goal. The reason I found this question [...]

Read Full Post »

Unlike my usual articles today’s article is not at all related to SQL Server but something drove me to include it on my blog. This issue snatched away my precious few hours. It took me over 2 hours to resolve it yesterday, which barred me from doing research on SQL Server. I am sure many [...]

Read Full Post »

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for [...]

Read Full Post »

The Rational Guide to Building Technical User Communities (Rational Guides) (Paperback)
by Greg Low

Short Review : A Great, one-of-its-kind book for everybody who is interested in building technical user community. There is no other book written on this subject but after this comprehensive book no further reading will be required.

Link to Amazon
Detailed Review :
This is [...]

Read Full Post »

Year ago, it was a great, perhaps the proudest moment of my professional life. I was awarded Most Valuable Professional (MVP) for SQL Server by Microsoft.
Today, I received an email informing me that I have been re-awarded SQL Server MVP status by Microsoft in recognition of my community contributions. It’s yet another proud moment for [...]

Read Full Post »

Today, we will examine something very simple and very generic that can apply to hordes of programming languages. Let’s take a common question that is frequently discussed – What is difference between Line Feed (\n) and Carriage Return (\r)?
Prior to continuing with this article let us first look into few synonyms for LF and CR.
Line [...]

Read Full Post »

This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional [...]

Read Full Post »

Older Posts »