SQL Tips and Tricks Archives - Page 277 of 536 - SQL Authority with Pinal Dave

SQL Server – Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave

March 12, 2012

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

Recently I just wrote a blog post on about Learning SQL Server Performance: Indexing Basics and I received lots of request that if we can share some insight into the course. Every single time when Performance is discussed, Indexes are mentioned along with it. In recent times, data and application complexity is…

SQLAuthority News – SQL Server 2012 – Microsoft Learning Training and Certification

March 10, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Training

Here is the conversion I had right after I had posted my earlier blog post about Download Microsoft SQL Server 2012 RTM Now. Rajesh: So SQL Server is available for me to download? Pinal: Yes, sure check the link here. Rajesh: It is trial do you know when it will be available…

SQLAuthority News – Download Microsoft SQL Server 2012 RTM Now

March 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

SQL Server 2012 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence: Deliver required uptime and data protection with AlwaysOn Gain breakthrough &…

SQL Server – Learning SQL Server Performance: Indexing Basics – Video

March 8, 2012

Pinal Dave

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

SQL Index

Today I remember one of my older cartoon years ago created for Indexing and Performance. Every single time when Performance is discussed, Indexes are mentioned along with it. In recent times, data and application complexity is continuously growing. The demand for faster query response, performance, and scalability by organizations is…

SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video

March 7, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts

We got tremendous response to video of Error and Reaction of SQL in Sixty Seconds #002. We all have idea how SQL Server reacts when it encounters T-SQL Error. Today Rick explains the same in quick seconds. After watching this I felt confident to answer talk about SQL Server’s reaction to…

SQLAuthority News – TechED India 2012 – Bangalore – March 21-23, 2012

March 6, 2012

Pinal Dave

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

SQLAuthority Author Visit

TechEd is one event which every developers and IT professionals are looking forward to attend. It is opportunity of life time and no matter how many time one gets chance to engage with it, it is never enough. I still remember every single moment of every TechEd I have attended…

SQL SERVER – Various Leap Year Logics

March 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Earlier I wrote one article on Leap Year and created one video about Leap Year. My point of view was to demonstrate how we can use SQL Server 2012 features to identify Leap year. How ever during the conversation I had some really good conversation. Here are updates for those…