SQLAuthority.com

Best Articles
Best Articles Of SQLAuthority
Favorite Articles
Pinal Dave's Preference
Readers' Selections
Readers' Finest Choice
SQL Script Bank
Useful SQL Server Scripts
Search SQLAuthority
Hunt using SQLAuthority
Job SQLAuthority.com
Let your dream come true
All - Articles
All Articles at one instance
MVP Profile
Exceptional Technical Community Leader
IP Address
Find your IP Address
Sitemap
List of Links from the site

Tip of the Minute

Order By clause is used for sorting records in Ascending or Descending order.
--Pinal Dave

Latest Articles

SQL SERVER - 2008 - Introduction to Merge Statement - One Statement for ...
MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based ...
SQLAuthority News - Download SQL Server 2008 Report Builder 2.0 RC1
Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including flexible report layout, data visualizations and richly formatted ...
SQLAuthority News - SQL Server Express 2008 Downloads
Microsoft SQL Server 2008 Express with Tools Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes graphical management ...
SQL SERVER - How to Rename a Column Name or Table Name
I often get request from blog reader for T-SQL script to rename database table column name or rename table itself. The script for renaming any column : SP_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]',  ...
SQLAuthority News - Ahmedabad SQL Server User Group Meeting - August 2008
I will be attending Ahmedabad SQL Server Usergroup Meeting on August 30, 2008. I will be taking session about ?SQL Server CTE and Recursive CTE?. The most important part of August Meeting is there will ...
SQLAuthority News - 4 Million Visits - over 675 SQL Server Articles
Thank you to all of my readers for supporting this blog. It has been wonderful journey all the way. I strongly encourage all my readers to actively contribute in discussion and writing article for blog. ...
SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server ...
Everyday I get lots of question regarding error : An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under ...
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Today in this article I would discuss about the Database Mail which is used to send the Email using SQL Server.  Previously I had discussed about SQL SERVER - Difference Between Database Mail and SQLMail. ...
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper ...
I had previously written SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case and I had really enjoyed writing it. Above script converts first letter of each word from sentence ...
SQL SERVER - Behind the Scene of SQL Server Activity of - Transaction ...
Imran Mohammed continues to help community of SQL Server with his very enthusiastic writing and deep understanding of SQL Server architecture. Let us read what Imran has to say about how Transaction Log ...
SQLAuthority News - Microsoft SQL Server Management Pack for Microsoft ...
The Microsoft SQL Server Management Pack provides both proactive and reactive monitoring of SQL Server 2008, 2005 and SQL Server 2000 in an enterprise environment. Availability and configuration monitoring, ...
SQLAuthority News - Find Your IP Address - What Is My IP Address
While developing often my developers need to know which IP address is of local network when looked from outside. I am working in large outsourcing company and we have local intranet setup. When connecting ...
SQL SERVER - Disable All the Trigger of Current Database
I have previously written article about SQL SERVER - Disable All Triggers on a Database - Disable All Triggers on All Servers. This is alternate method to achieve the same task. Following article is sent ...
SQL SERVER - Detailed Explanation of Transaction Lock, Lock Type, Avoid
Loyal reader of this blog and “Great SQL Expert” Imran Mohammed always have good attitude towards any problem. Many times his answers very interesting to read and details are very accurate. I came across ...
SQL SERVER - 2005 - Best Practices Analyzer (August 2008)
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices ...
SQL SERVER - XML - Split a Delimited String - Generate a Delimited String
SQL Server MVP and my very good friend Jacob Sebastian has written two wonderful articles about SQL Server and XML. I encourage to read this two articles to anybody who are interested in learning SQL ...

Pinal Dave

Resembling Life

photos
photos
photos

Myself with Parents

My Family

photos
photos

Las Vegas

Vegas Forever!

photos
photos
photos