Best Practices Archives - Page 9 of 24 - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

September 2, 2010

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

Best Practices, Database, SQL Index, SQL Scripts, SQL Training

In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically…

SQL SERVER – Best Practices for DBA Before Taking Vacation

August 10, 2010

Pinal Dave

SQLAuthority News

Best Practices, SQL Server Security

This blog post is written in response to T-SQL Tuesday hosted by Jason Brimhall. Everybody wants to take a vacation. Who does not love vacation, anyway? However, it seems that it has been getting more and more difficult to take vacation recently. There are two reasons why a person is…

SQL Tips – 5 SQL Server Best Practices

July 30, 2010

Pinal Dave

SQL Tips and Tricks

Best Practices, Database, DBA, SQL Server

In this blog post we will see 5 SQL Server Best Practices.

Backup Master. I am going to have a backup of the database using script; however, the backup script has not been updated for a long time now.

SQL SERVER – Find Queries using Parallelism from Cached Plan

July 24, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL DMV, SQL Scripts, SQL Server

I recently came across wonderful blog post of Feodor Georgiev. He is one fine developer and like to dwell in the subject of performance tuning and query optimizations. He is one real genius and original blogger. Recently I came across his wonderful script, which I was in fact writing myself…

SQL SERVER – Win USD 11,899 worth MSDN Subscription 5 Days to go

July 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

Few days ago, I had posted content SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN. It has received tremendous response to them. This competition is still open for 5 more days. I am sure you can win the subscription if you leave the best comment. Win $…

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial

July 1, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Utility

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed…

SQLAuthority News – Exam 70-433 – MCTS – Microsoft SQL Server 2008, Database Development

June 29, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Microsoft Certifications, MVP, SQL Certifications

I often receive lots of questions regarding how to pass SQL Server Certification exams. I have previously written about the road map over SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications. I have tremendous respect for Microsoft Certification and I enjoy the preparation phase as well as…