All Articles - SQL Authority with Pinal Dave

SQL SERVER – Weekend Project – Experimenting with ACID Transactions, SQL Compliant, Elastically Scalable Database

June 26, 2012

Database technology is huge and big world. I like to explore always beyond what I know and share the learning. Weekend is the best time when I sit around download random software on my machine which I like to call as a lab machine (it is a pretty old laptop,…

SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS

June 25, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Let me start today’s blog post with a direction question. How many of you have ever used Template Browser? Template Browser is a very important and useful feature of SQL Server Management Studio (SSMS). Every time when I am talking about SQL Server there is always someone comes up with the…

SQL SERVER – Download SQL Server Product Documentation

June 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Today I just returned from Bangalore User Group Meeting. Attending User Group meeting is indeed fun and really great experience. The best part of the User Group is meeting like minded people and have a great conversation with them. During the meeting I was asked why one has to go…

SQL SERVER – Introduction to Function SIGN

June 23, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Yesterday I received an email from a friend asking how do SIGN function works. Well SIGN Function is very fundamental function. It will return the value 1, -1 or 0. If your value is negative it will return you negative -1 and if it is positive it will return you…

SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY

June 22, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

The most common question I often receive is why do I blog? The answer is even simpler – I blog because I get an extremely constructive comment and conversation from people like DHall and Kumar Harsh. Earlier this week, I shared a conversation between Madhivanan and myself regarding how to…

SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode

June 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

What do you do when you are in a hurry and hear someone say things which you do not agree or is wrong? Well, let me tell you what I do or what I recently did. I was walking by and heard someone mentioning “Columnstore Index are really great as…

SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video

June 20, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Importing data into database is one of the most important tasks. I often receive questions regarding what is the quickest way to insert CSV data or how to import CSV Data into SQL Server Table. Honestly the process is very simple and the script is even simpler. In today’s SQL…

SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

June 19, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

There is an old quote “A Picture is Worth a Thousand Words”. I believe this quote immensely. Quite often I get phone calls that something is not working if I can help. My reaction is in most of the cases, I need to know more, send me exact error or…

SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables

June 18, 2012

Pinal Dave

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

SQL Server Management Studio

I love interesting conversations with related to SQL Server. One of my friends Madhivanan always comes up with an interesting point of conversation. Here is one of the conversation between us. I am very confident this blog post will for sure enable you with some new knowledge. Madhi: How do…

SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)

June 17, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Just like any other Developer or DBA SQL Server Management Studio is my favorite application. Any any moment of the time I have multiple instances of the same application are open and I am working on it. Recently, I have come across a very interesting feature in SSMS related to…