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

SQL SERVER – TechEd India 2012 – Content, Speakers and a Lots of Fun

March 17, 2012

SQLAuthority Author Visit, TechEd, TechEdIn

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 – SQL Server Misconceptions and Resolution – A Practical Perspective – TechEd 2012 India

March 16, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

TechEd, TechEdIn

TechEd India 2012 is just around the corner and I will be presenting there in two different sessions. On the very first day of this event, my presentation will be all about SQL Server Misconceptions and Resolution – A Practical Perspective. The dictionary tells us that a “misconception” means a view or…

SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video

March 14, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts

A DBA’s role is critical, because a production environment has to run 24×7, hence maintenance, trouble shooting, and quick resolutions are the need of the hour. The first baby step into any performance tuning exercise in SQL Server involves creating, analyzing, and maintaining indexes. Though we have learnt indexing concepts…

SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India

March 13, 2012

Pinal Dave

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

SQL Wait Stats, TechEd, TechEdIn

TechEd India 2012 is just around the corner and I will be presenting there on two different session. SQL Server Performance Tuning is a very challenging subject that requires expertise in Database Administration and Database Development. I always have enjoyed talking about SQL Server Performance tuning subject. Just like doctors I…

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

March 12, 2012

Pinal Dave

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

SQL Index

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 &…