All Articles - SQL Authority with Pinal Dave

SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012

November 8, 2011

This blog post is written in response to the T-SQL Tuesday post of Prox ‘n’ Funx. This is a very interesting subject. By the way Brad Schulz is my favorite guy when it is about blogging. I respect him as well learn a lot from him. Everybody is writing something…

SQL SERVER – Video – Performance Improvement in Columnstore Index

November 7, 2011

Pinal Dave

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

SQL Index, SQL Scripts

I earlier wrote an article about SQL SERVER – Fundamentals of Columnstore Index and it got very well accepted in community. However, one of the suggestion I keep on receiving for that article is that many of the reader wanted to see columnstore index in the action but they were…

SQL SERVER – Updating Data in A Columnstore Index

November 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

So far I have written two articles on Columnstore Indexes, and both of them got very interesting readership. In fact, just recently I got a query on my previous article on Columnstore Index. Read the following two articles to get familiar with the Columnstore Index. They will give you a…

SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default

November 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Management Studio

As a technologist, I love my laptop very much and I do not lend it to anyone as I am usually worried that my settings would be messed up when I get it back from its borrower. Honestly, I love how I have set up my laptop and I enjoy…

SQL SERVER 2012 Editions – Highlights of The Cloud-Ready Information Platform

November 4, 2011

Pinal Dave

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

Business Intelligence

Microsoft has just announced SQL Server 2012 Editions information on official SQL Server 2012 site. SQL Server 2012 will be available in three main editions: Enterprise Business Intelligence Standard The other editions are Web, Developer and Express. Here is the salient features of each of the edition: Enterprise Advanced high…

SQLAuthority News – SQL Server Interview Questions And Answers Book Summary

November 4, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database

Today we are using computers for various activities, motor vehicles for traveling to places, and mobile phones for conversation. How many of us can claim the invention of micro-processor, a basic wheel, or the telegraph? Similarly, this book was not written overnight. The journey of this book goes many years…

SQLAuthority News – New Book Released – SQL Server Interview Questions And Answers

November 3, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Data Warehousing, Database, SQLAuthority Book Review

Two days ago, on birthday of my blog – I asked simple question – Guess! What is in this box? I have received lots of interesting comments on the blog about what is in it. Many of you got it absolutely incorrect and many got it close to the right…

SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress

November 2, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

One of the most common data integration tasks I run into is a desire to move data from a file into a database table. Generally the user is familiar with his data, the structure of the file, and the database table, but is unfamiliar with data integration tools and therefore…

SQLAuthority News – 5th Anniversary Giveaways

November 1, 2011

Pinal Dave

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

Please read my 5th Anniversary post and my quick note on history of the Database. I am sure that we all have friends and we value friendship more than anything. In fact, the complete model of Facebook is built on friends. If you have lots of friends, you must be…

SQLAuthority News – History of the Database – 5 Years of Blogging at SQLAuthority

November 1, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Database

Don’t miss the Contest:Participate in 5th Anniversary Contest Today is this blog’s birthday, and I want to do a fun, informative blog post. Five years ago this day I started this blog. Intention – my personal web blog. I wrote this blog for me and still today whatever I…