SQL Server Archives - Page 239 of 393 - SQL Authority with Pinal Dave

SQLAuthority News – Virtual Launch Event for Office 2010 – Contest – Win MS Office License

May 23, 2010

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

Office products are integral products of any PC. I accept that without Office Suites, I can not survive or make enough leaving. I am blogger and use word to create my blogs. I am SQL Server Trainer and I use PowerPoint as my presentation tool. I am SQL Server consultant…

SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5

May 22, 2010

Pinal Dave

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

SQL Documentation, SQL Download

There are few downloads released for Microsoft SQL Server Compact 3.5. Here is quick lists of the same. Microsoft SQL Server Compact 3.5 Service Pack 2 for Windows Desktop SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile…

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions

May 21, 2010

Pinal Dave

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

SQL Scripts, Transaction Isolation

To learn any technology and move to a more advanced level, it is very important to understand the fundamentals of the subject first. Today, we will be talking about something which has been quite introduced a long time ago but not properly explored when it comes to the isolation level.…

SQLAuthority News – Updated Favorite Scripts and Best Articles Page

May 19, 2010

Pinal Dave

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

I have been writing on this blog for around 4 years now and have contributed with more than 1300 blog posts. Many times, I have been asked regarding what is my most favorite article or which is the most essential script for developers and DBA. This is very difficult to…

SQLAuthority Book Review – DBA Survivor: Become a Rock Star DBA

May 18, 2010

Pinal Dave

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

SQLAuthority Book Review

DBA Survivor: Become a Rock Star DBA – Thomas LaRock Link to Amazon Link to Flipkart First of all, I thank all my readers when I wrote that I could not get this book in any local book stores, because they offered me to send a copy of this good…

SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010

May 16, 2010

Pinal Dave

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

SharePoint, SQL Data Storage, SQL White Papers

Just a day ago, I was asked how do you plan SQL Server Storage Capacity. Here is the excellent article published by Microsoft regarding SQL Server capacity planning for SharePoint 2010. This article touches all the vital areas of this subject. Here are the bullet points for the same. Gather…

SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup

May 13, 2010

Pinal Dave

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

SQL Backup and Restore, SQL Index, SQL Scripts

Recently, I have observed that not many people have proper understanding of what is bookmark lookup or key lookup. Increasing numbers of the questions tells me that this is something that developers encounter every single day, but have no idea how to deal with. I have previously written three posts…