2009 - Page 27 of 55 - SQL Authority with Pinal Dave

SQL SERVER – Disk Partition Alignment Best Practices

July 4, 2009

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

Note : Download Disk Partition Alignment Best Practices for SQL Serverby Microsoft 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…

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

July 3, 2009

Pinal Dave

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.