Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Blog of Nupur Dave on Windows Live

October 28, 2010

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

Blog are way to express ourselves; Blogs are bookmarks of my learning process and blogs reflects us. My Wife Nupur, an avid user of Windows Live, has decided to start blogging on the subject. There was lots of discussion between us regarding if she really wants to blog or keep her…

SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage

October 27, 2010

Pinal Dave

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

Best Practices, Database, SQL Scripts, SQL TempDB

Recently, there have been a lot of interesting concepts in various challenges. My friend Jacob Sebastian is running the SQLQuiz for the entire month, and it has been very popular and going just great. So here I thought I would put something very similar to the quiz bee. The award…

SQLAuthority News – Database Performance for SharePoint Sites – Session Tomorrow in Singapore

October 26, 2010

Pinal Dave

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

SQL Scripts, SQLAuthority Author Visit

I am all excited to present my very first session on Database Performance for SharePoint Sites. Here is the details for my session which is planned for tomorrow. Grand Copthorne Waterfront Hotel Singapore 392 Havelock Road Singapore 169663 My Sessions details: Maintaining SQL Server at Optimal Performance for Blazing Fast…

SQL SERVER – A Brief Introduction to DW 2.0

October 25, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Warehousing, Database

The traditional form of storing digital data has been disk storage. However, the huge advances in technology means that there has been a huge need for data storage to evolve to keep up with the fast-changing times. Microsoft SQL Server has gone through a huge overhaul in order to keep…

SQL SERVER – Corrupted Backup File and Unsuccessful Restore

October 24, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages

If you are an SQL Server Consultant, there is never a single dull moment in your life. Quite often you are called in for fixing something, but then you always end up fixing something else! I was recently working on an offshore project where I was called in to tune…

SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup

October 23, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

I recently had a very interesting experience. In one of my recent consultancy works, I was told by our client that they are going to take the backup of the database and will also a copy of it at the same time. I expressed that it was surely possible if…

SQLAuthority News – SQLAuthority News – Presenting at South East Asia SharePoint Conference – Demo Details

October 22, 2010

Pinal Dave

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

SQLAuthority Author Visit

I will be Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site. I am very excited beuse this is going to be my very first series of presentations at SharePoint Conference. Since I posted details about the event, I have…