All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)

July 3, 2009

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL User Group, SQLAuthority Book Review

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…

SQLAuthority News – MVP Award Renewed

July 2, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

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

SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char

July 1, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

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…

SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies

June 30, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Policy Management, SQL Scripts, SQL Server Security

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…

SQL SERVER – Maximum Number of Index per Table

June 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

TechEd on Road Ahmedabad, June 20, 2009, was a huge success. This grand event saw over 200 attendees actively participating in the sessions. We had attendees traveling from far and wide, including Delhi, Mumbai, Jaipur, Kerala, Baroda, Himmatnagar, Rajkot, among other cities from India. This enthusiastic participation made the event…

SQL SERVER – SQL Server Management Studio New Features

June 28, 2009

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Management Studio

This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time.

SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.

June 27, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Trigger, sqlcmd

I had previously written two articles about an intriguing observation of triggers online. SQL SERVER – Interesting Observation of Logon Trigger On All Servers SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution If you are wondering what made me write yet another article on logon…

SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution

June 26, 2009

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Trigger

Does the title of this post trigger your mind? If you all remember, a few days back I had written an article on my interesting observation regarding logon triggers. I would advise you to first read SQL SERVER – Interesting Observation of Logon Trigger On All Servers before continuing with…

SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009

June 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQLAuthority Author Visit, TechEd, TechEdIn

K-MUG is organizing TechEd Trivandrum on 27th June, 2009. Not just this, they are launching an official PASS Chapter in Trivandrum. The Agenda of the event is here and if you are around Trivandrum do not miss the opportunity to be a part of this upcoming great event. If you…

SQLAuthority News – Update on pinaldave.com and SQLAuthority.com

June 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database

Problem: SQLAuthority.com site was not allowed in some browsers as pinaldave.com site was marked as malware or badware distributing third party site. Status: SQLAuthority.com and pinaldave.com both the sites are safe now and there is no threat to your computer. Feel free to click on the links. Since the last…