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

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 ...