SQL Server Archives - Page 171 of 393 - SQL Authority with Pinal Dave

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

November 4, 2011

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

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…

SQL SERVER – How to Ignore Columnstore Index Usage in Query

October 30, 2011

Pinal Dave

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

SQL Index

Earlier I wrote about SQL SERVER – Fundamentals of Columnstore Index and very first question I received in email was as following. “We are using SQL Server 2012 CTP3 and so far so good. In our data warehouse solution we have created 1 non-clustered columnstore index on our large fact table.…