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

SQLAuthority News – Excellent Learning Experience at SQLskills Immersion Events

March 17, 2013

Pluralsight, SQL Training, SQLAuthority Author Visit

As many of you know, I attended the Immersion Event at SQLskills learning center in early Feb. I consider myself a SQL professional, but there is no age limit for being a student. One can learn forever, there is always something new to pick up – particularly when you go…

SQL SERVER – Weekly Series – Memory Lane – #020

March 16, 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…

SQLAuthority News – Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore

March 15, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

TechEd, TechEdIn

TechEd India is around the corner and I have two sessions in TechEd India. I am excited and nervous as well. TechEd is a special event and I am going to present 4th time in this event. This time the event is in two location – Bangalore and Pune. Performance…

SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013

March 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Pluralsight, SQLAuthority Author Visit

February was very good for me because I got to attend PluralSight’s Author Summit. The Author Summit was held in Salt Lake City, Utah and was open to all PluralSight’s authors. Pluralsight Authors Most of the authors attended the conference, held at the PluralSight headquarters. It was a three day…

SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video

March 13, 2013

Pinal Dave

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

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

Earlier I have blogged about the same subject and in very short time I received lots of good comments about this blog post as well lots of email from users who faced issues to make this work. Thought, the instructions are very simple in the blog post, every user read…

SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

March 12, 2013

Pinal Dave

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

SQL Function, SQL Index

“Don’t use functions in the WHERE clause, they reduce performance.” I hear this quite often. This is true but this subject is hard to understand in a single statement. Let us see what it means and how to use the function in the WHERE clause. We will be using sample…

SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework

March 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform within Visual Studio. The SQL Server Object Explorer in Visual Studio offers a view of your database objects similar to SQL Server Management Studio. SQL…