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

SQL SERVER – DELETE, TRUNCATE and RESEED Identity

August 24, 2012

Yesterday I had a headache answering questions to one of the DBA on the subject of Reseting Identity Values for All Tables. After talking to the DBA I realized that he has no clue about how the identity column behaves when there is DELETE, TRUNCATE or RESEED Identity is used. Let…

SQL SERVER – Reseting Identity Values for All Tables

August 23, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Sometime email requesting help generates more questions than the motivation to answer them. Let us go over one of the such examples. I have converted the complete email conversation to chat format for easy consumption. I almost got a headache after around 20 email exchange. I am sure if you…

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

August 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Quality Services, DQS, SQL Utility

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…