All Articles - SQL Authority with Pinal Dave

SQL SERVER – Datetime Function SWITCHOFFSET Example

July 15, 2010

I was recently asked if I know how SWITCHOFFSET works. This feature only works in SQL Server 2008. Here is quick definition of the same from BOL: Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset. What essentially it…

SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

July 14, 2010

Pinal Dave

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

MVP, Spatial Database, SQL Index, SQL User Group, SQLAuthority Author Visit

I will be presenting two SQL Server advance level sessions at SQL Data Camp @ Chennai. I am very excited for this event as I am going to meet my friends Sugesh, Deepak, Vidhya and Madhivanan at this event. All of them are SQL Server MVPs. I have come to…

SQL SERVER – How do I Learn and How do I Teach

July 13, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

This blog post is written in response to T-SQL Tuesday hosted by Robert L Davis (aka SQLSoldier). The blog post has raised three very interesting questions. How do you learn? How do you teach? What are you learning or teaching? Let me try to answer the same. How do I…

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

July 12, 2010

Pinal Dave

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

I just 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 – Parallelism – Row per Processor – Row per Thread – Thread 0

July 11, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier I had posted article answering question. “When SQL Server executes any query on multiple processors, do all processors process equal numbers of rows?” Read the answer over SQL SERVER – Parallelism – Row per Processor – Row per Thread. In the same article, I had asked back to readers as…

SQLAuthority News – Milestone – 1400th Post and Why do I blog

July 10, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I am very glad today that I have reached milestone of 1400th post. I was looking back to my journey which I started on Nov 1, 2006 and I feel that it has been long way. I have noticed a lot of changes in myself too. Earlier, I used to…

SQLAuthority News – I am a MVP and I Love SQL Server

July 9, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

MVP, SQL User Group

I am very glad that I received this prestigious award for the third time in a row. I am very thankful to Microsoft for introducing this wonderful technology of SQL Server. I enjoy getting involved with the community, which also helps in my self-improvement as well. I would like to…

SQL SERVER – The Self Join – Inner Join and Outer Join

July 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The…

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

July 7, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

Few days ago, I received code which is very similar to code shown below. select * from Sales.SalesOrderDetail where ProductID > 777 I am not the guy who go crazy for formatting but I do appreciate proper coding. I like if the code was formatted like below. SELECT * FROM…

SQLAuthority News – I am Microsoft Certified Trainer (MCT)

July 6, 2010

Pinal Dave

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

SQL Training

I am a Microsoft Certified Trainer and I am very much proud of it. Because I am a MCT, I have the support of great community leaders and trainers who help me constantly to improve in what I do. I have many Microsoft Certifications and I constantly try to take…