Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – Download Whitepaper – Introducing the BI Semantic Model in Microsoft SQL Server 2012

January 20, 2013

IT industry has recognized that businesses benefit from a model layer over their data sources. Model layers can deliver high-performance query responses even over extremely large volumes of data, and they can encapsulate business rules and effectively secure access to data. The BI Semantic Model is a single model that…

SQL SERVER – Weekly Series – Memory Lane – #012

January 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – A List of Various SQL Server RTM and Service Pack Number

January 18, 2013

Pinal Dave

SQL

Database, SQL Scripts, SQL Server, SQL Service Pack

A common question I receive is that how do user know which version user is using and what is the latest service pack number available for the product. Here is something at this beginning of the year, check with your production server.

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4

January 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

This is the fourth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier three parts. On my production server I personally use embarcadero DB Optimizer for all…

SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video

January 16, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Let me start this blog post with negative note: SQL Server is not mass mailing software. If you are thinking of sending emails using SQL Server instead of your mail server – I suggest you stop doing that NOW! Whenever, I see any application using SQL Server as a mail…

SQL SERVER – Introduction of Showplan Warning

January 15, 2013

Pinal Dave

SQL Performance

Execution Plan, SQL Scripts, SQL Server

Vinod Kumar M is my very good friend, renowned SQL Server Expert. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a well-known speaker at all major Microsoft and third party technical conferences. Here is a very interesting blog post he sent on the subject of Executon Plan. Let us learn about introduction to Showplan Warning.

SQLAuthority News – Attending SQLskills Training in February 2013

January 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

If you read my resolutions blog post, you know that one of my dreams is to learn more, and specifically to attend a SQL Server class. Paul Randal and Kimberly Tripp, along with fantastic people like Jonathan, Glenn, Erin and Joe, runs amazing organization SQLskills. It is one of the…