All Articles - SQL Authority with Pinal Dave

SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List

August 18, 2010

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

I was getting many request to update SQL Server Interview Questions and Answers I had written couple of years ago. I have modified the original document a bit and corrected few of the typos and errors. I have really enjoyed going over all the Interview Questions and Answers. It has…

SQLAuthority News – Speaking Online at Virtual Techdays – Aug 18, 2010 – Spatial Datatypes

August 17, 2010

Pinal Dave

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

Spatial Database, SQLAuthority Author Visit

I am honored that I have been invited to speak at Virtual TechDays on Aug 18, 2010 by Microsoft. I will be speaking on my favorite subject of Spatial Datatypes. This exclusive Online event will have 30 deep technical sessions per day – and, attendance is completely FREE. There are…

SQL SERVER – Finding the Occurrence of Character in String

August 16, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

This article is written in response to provide hint to TSQL Beginners Challenge 14. The challenge is about counting the number of occurrences of characters in the string. Here is quick method how you can count occurrence of character in any string. Here is quick example which provides you two…

SQLAuthority News – Bookmark Link for Sync Framework for SQL Azure

August 15, 2010

Pinal Dave

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

SQL Documentation, SQL Download

I have been looking for good tutorial for Sync Framework for SQL Server. There was quite a bit demand of the product. I have received quite a few request as well. I finally found good list of the link of Sync Framework. The links are listed below. Introduction to Sync…

SQLAuthority News – Why SQL Server is better than any other RDBMS Applications?

August 14, 2010

Pinal Dave

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

MVP

Earlier I had announced contest on blog where I gave away two MSDN Subscriptions to person who has provided best comment on the subject of “Why SQL Server is better than any other RDBMS Applications?” I have received tremendous response to the contest. I got many responses, it was extremely…

SQL SERVER – Computed Column and Performance – Part 3

August 13, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

I am really enjoying writing about computed column and its effect in terms of performance. Before continuing this article, I suggest you read the earlier articles on the same subject to get the complete context. This is the list of the all the articles in the series of computed column.…

SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server

August 12, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

DBA, SQL Scripts

I was recently called to attend the Query Tuning Project. I had a very interesting experience in this event. I would like to share to you what actually happened. Note: If you are just going to say that shrinking database is bad, I agree with you and that is the…

SQLAuthority News – MSDN Subscription Giveaway Announced

August 11, 2010

Pinal Dave

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

MVP

Last Month received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the…

SQL SERVER – Best Practices for DBA Before Taking Vacation

August 10, 2010

Pinal Dave

SQLAuthority News

Best Practices, SQL Server Security

This blog post is written in response to T-SQL Tuesday hosted by Jason Brimhall. Everybody wants to take a vacation. Who does not love vacation, anyway? However, it seems that it has been getting more and more difficult to take vacation recently. There are two reasons why a person is…

SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool New v1.2

August 9, 2010

Pinal Dave

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

SQL Documentation, SQL Download

Risk and Health Assessment Program for Microsoft SQL Server helps reduce business risks associated with downtime, performance bottlenecks, and the complexities of deploying and managing an enterprise-level, data management solution. You can read more about Risk and Health Assessment Program for Microsoft SQL Server in the datasheet over here. Microsoft…