June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Server Performance Series Hyderabad / Pune – Nov/Dec 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…
Read More

SQL SERVER – History of SQL Server Database Encryption

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…
Read More

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

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…
Read More

SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use

Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server

I often go to do various seminars and presentations at various organizations. During presentations I often create and drop various databases for the demonstration’s purpose. Recently in one of the presentations, I tried to remove my recently created database, I got following error 3702 which is related to user cannot drop database.

Read More