SQL Tips and Tricks Archives - Page 366 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Check the Isolation Level with DBCC useroptions

May 24, 2010

SQL Scripts, SQL System Table, Transaction Isolation

In recent consultancy project coordinator asked me – “can you tell me what is the isolation level for this database?” I have worked with different isolation levels but have not ever queried database for the same. I quickly looked up bookonline and found out the DBCC command which can give…

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

May 23, 2010

Pinal Dave

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

Office

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…