SQL Archives - Page 249 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Download PSSDIAG Data Collection Utility

August 26, 2012

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

During an early career of mine as a database consultant – when I was dealing with SQL Server 2000, I often needed to collect various data related to SQL Server. My favorite tool to collect the data is PSSDIAG tool. It is a general purpose diagnostic collection utility that Microsoft Product…

SQLAuthority News – Featuring in Call Me Maybe The Developer Way – Pluralsight Video

August 25, 2012

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Is SQL boring? Not at all. SQL is fun – one has to know how to maximize the fun while working with SQL Server. Earlier I was invited to participate in the video Pluralsight. I am sure all of you know that I have authored 3 SQL Server Learning courses…

SQL SERVER – DELETE, TRUNCATE and RESEED Identity

August 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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.…