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

SQL SERVER – Updating Data in A Columnstore Index

November 6, 2011

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…