All Articles - SQL Authority with Pinal Dave

SQLAuthority News – What’s New in SQL Server “Denali”

November 24, 2010

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

I was today doing SQL Server Advanced Training at Bangalore and I had few attendees asked me if I can give them review of the SQL Server Denali. I had not downloaded Denali on my work computer so I could not do demonstration of the same. However, I promised to…

SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience

November 23, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL PASS, SQLAuthority Author Visit

I recently attended most prestigious SQL Server event SQLPASS between Nov 8-11, 2010 at Seattle. I have only one expression for the event – Best Summit Ever This year the summit was at its best. Instead of writing about my usual routine or the event, I am going to write…

SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010

November 22, 2010

Pinal Dave

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

MVP, SQL Joins, SQL Statistics

I am honored that I have been invited to speak at Virtual TechDays on Nov 22, 2010 by Microsoft. I will be speaking on my favorite subject of Statistics and Best Practices. This exclusive online event will have 80 deep technical sessions across 3 days – and, attendance is completely…

SQL SERVER – Change Database Access to Single User Mode Using SSMS

November 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

I have previously written about how using T-SQL Script we can convert the database access to single user mode before backup. I was recently asked if the same can be done using SQL Server Management Studio. Yes! You can do it from database property (Write click on database and select…

SQLAuthority News – Book Review – Beginning T-SQL 2008 by Kathi Kellenberger

November 20, 2010

Pinal Dave

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

SQLAuthority Book Review

Beginning T-SQL 2008 by Kathi Kellenberger Amazon Link Detail Review: Beginning T-SQL 2008 is one of the best books on the market if you are just beginning to work with Microsoft SQL, or have a little bit of experience and need to learn more quickly. Each chapter of the book…

SQLAuthority News – Blog Stats Revealed

November 19, 2010

Pinal Dave

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

I often receive praises, questions, suggestions and skeptical emails regarding my blog stats. Let me put everything aside and open up my stats page for all. I use wordpress.com and stats are maintained by them. Every month, I will put the blog stats on the following page for every one’s…

SQLAuthority News – SQL Server Performance Series Hyderabad / Pune – Nov/Dec 2010

November 18, 2010

Pinal Dave

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

SQL Scripts

Just a quick note that SQL Server Performance Tuning and Optimizations Seminar series which I am offering at Hyderabad and Pune are almost all sold out. Read the details of the earlier successful seminar conducted at Colombo, Sri Lanka over here. Hyderabad Nov 27-28, 2010 (Last 3 Seats Left) Best…

SQL SERVER – History of SQL Server Database Encryption

November 17, 2010

Pinal Dave

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

SQL PASS, SQL Server Encryption, SQLAuthority Book Review

I recently met Michael Coles and Rodeney Landrum the author of one of the kind book Expert SQL Server 2008 Encryption at SQLPASS in Seattle. During the conversation we ended up how Microsoft is evolving encryption technology. The same discussion lead to talking about history of encryption tools in SQL…

SQLAuthority News – Download Whitepaper – Understanding and Controlling Parallel Query Processing in SQL Server

November 16, 2010

Pinal Dave

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

SQL White Papers

My recently article SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database has received many good comments regarding MAXDOP 1 and MAXDOP 0. I really enjoyed reading the comments as the comments are received from industry leaders and gurus. I was further researching on the subject and I end…

SQL SERVER – Information Related to DATETIME and DATETIME2

November 15, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I recently received interesting comment on the blog regarding workaround to overcome the precision issue while dealing with DATETIME and DATETIME2. I have written over this subject earlier over here. SQL SERVER – Difference Between GETDATE and SYSDATETIME SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE SQL…