Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012

August 21, 2012

Data Quality Services is very interesting enhancements in SQL Server 2012. My friend and SQL Server Expert Govind Kanshi have written an excellent article on this subject earlier on his blog. Yesterday I stumbled upon his blog one more time and decided to experiment myself with DQS. I have basic…

SQL SERVER – Winners – Contest Win Joes 2 Pros Combo (USD 198)

August 20, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

Earlier this week we had contest ran over the blog where we are giving away USD 198 worth books of Joes 2 Pros. We had over 500+ responses during the five days of the contest. After removing duplicate and incorrect responses we had a total of 416 valid responses combined…

SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users

August 19, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security

If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry.…

SQLAuthority News – Presented at Bangalore DevCon August 4, 2012

August 18, 2012

Pinal Dave

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

SQLAuthority Author Visit

Bangalore Devcon 2012 was a great fun. Earlier this month I was fortunate to be invited to present at Dev Con. The event was very well planned and had excellent response. There were more than 140 attendees at any time in the sessions. There were two tracks and both tracks…

SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2

August 17, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Yesterday I wrote a real world story of how a friend who thought they have an issue with intrusion or virus whereas the issue was really in the code. I strongly suggest you read my earlier blog post Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE…

SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2

August 16, 2012

Pinal Dave

SQL

SQL Constraint and Keys, SQL Server

Social media has created an Always Connected World for us. On the second day of the event after the learning was over, I noticed lots of notification from my friend on my various social media handle. He had connected with me on Twitter, Facebook, Google+, LinkedIn, YouTube as well SMS, WhatsApp on the phone, Skype messages and not to forget with a few emails. I right away called him up. Let us learn about ON UPDATE CASCADE and ON DELETE CASCADE.

SQLAuthority News – Technical Review of Learning

August 15, 2012

Pinal Dave

SQLAuthority News

SQL Training

I had enrolled for three days training so my routine each of the three days was very much same. However, the content every day was different as I was learning something new every day. Let me describe a few of the interesting details of my daily routine. Let us see a technical review of learning.