SQL Archives - Page 337 of 519 - SQL Authority with Pinal Dave

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

October 27, 2010

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…

SQLAuthority News – Book Review – Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners

October 21, 2010

Pinal Dave

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

SQLAuthority Book Review

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners Rick A Morelan, Doug Fritz Link to Amazon Short Review: This is one book that provides a solid fundamental to the reader along with hands-on experience and in-depth learning. Right now, an error-free book that is closer to real…