All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle

October 11, 2011

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

For the third year in a row, I am attending the SQLPASS Summit, October 11-14. Every year I have explained my reasons for attending this conference in Seattle, and this year I will state those reasons again. WHY? I have written two articles on this subject, which you can read…

SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!

October 10, 2011

Pinal Dave

SQLAuthority News

SQL Milestone, SQL Server

I really never thought that I would be writing this post – honestly! After 1900th post and almost 5 years, this has been a journey and lots of learning. I get to write a 100 “mile stone” post 3-4 times a year, so I am happy to be writing this one. I am eagerly looking forward to my 2000th blog post as well.

All Articles System-Center-Monitoring-600x225

SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

October 9, 2011

Pinal Dave

SQL

Database, SQL Documentation, SQL Download

Microsoft is continuously releasing System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

October 8, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

I earlier wrote about DBA Quiz at All was well few moments before all went wrong – Reasons and Resolutions. I have even announced that I will give away one print book of SQL Wait Stats book. SQL Programming Joes 2 Pros (vol 4) [Amazon] | [Flipkart]- Chapter 13 has…

SQL SERVER – Server Side Paging in SQL Server CE (Compact Edition)

October 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Paging, SQL Scripts

SQL Server Denali is coming up with new T-SQL of Paging. I have written about the same earlier. SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison SQL SERVER – Server Side Paging…

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

October 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Collation, SQL DMV, SQL Function, SQL Scripts, SQL Server

In my recent Office Hours, I received a question on how to determine the case sensitivity of the database. Let us learn about how we can Detecting Database Case Sensitive Property using fn_helpcollations().

SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special

October 5, 2011

Pinal Dave

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

Joes 2 Pros, SQL Wait Stats, SQLAuthority Book Review

Get SQL Wait Stats – Kindle Edition Last month I released my SQL Wait Stats book. This book is the beginning of my journey in wait stats. It has been extremely popular and so far in India it has sold all the print copies twice on Flipkart. This book is…

SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers

October 4, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of JOIN. This is a very interesting subject. Years ago, I wrote my article about SQL SERVER – Introduction to JOINs – Basic of JOINs, ‑ till date, it is my most favorite article on the blog. Today…

SQL SERVER – CE – 3 Links to Performance Tuning Compact Edition

October 4, 2011

Pinal Dave

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

Today, I am going to do webcast online on how to improve performance for SQL CE. Here are three articles which I am going to base my session. Database Design and Performance (SQL Server Compact Edition) Use Database Denormalization Decide Between Variable and Fixed-length Columns Create Smaller Row Lengths Use…

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

October 3, 2011

Pinal Dave

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

SQL Backup and Restore, SQL Documentation, SQL Download, SQL Utility

Scroll down at the end of this post to win my SQL Wait Stats Book. I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When…