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

SQL SERVER – Understanding Restrict Access to Restricted_User Database Property

August 4, 2013

Recently I received an empty email with the subject “Question for you”. I was bit surprised as the email had no content at all. It was absolutely empty. I wrote back to user asking if he has missed the text in the email. He responded that there was an image…

SQL SERVER – Weekly Series – Memory Lane – #040

August 3, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL – Download NuoDB and Qualify for FREE Amazon Gift Cards

July 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

July has been a fantastic month and Team NuoDB has really appreciated the active participation of the SQLAuthority.com active reader base. Earlier we had launched two contests with NuoDB and both of them are very much appreciated by readers. There are constant demands of more contests and team NuoDB is very…

SQL – Building a High Traffic, Profitable Blog – A Unique Gift on Author’s Birthday

July 30, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Every July 30th, I like to do something new. It is my birthday and I like to give gifts to everyone this day. Last year, at this time I had written an article A Year Older and 3 SQL Server Books and 3 Video Courses – 33. I had written a…

SQLAuthority News – 5 days of SQL Server Reporting Service (SSRS) Summary

July 28, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SSRS

Earlier this week, I wrote five days series on SQL Server Reporting Service. The series is based on the book Beginning SSRS by Kathi Kellenberger. Supporting files are available with a free download from thewww.Joes2Pros.com web site. I just completed reading the book – it is a fantastic book and I am loving every…

SQL SERVER – Weekly Series – Memory Lane – #039

July 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – How to an Add Identity Column to Table in SQL Server

July 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity

Here is the question I received on SQLAuthority Fan Page. “How do I add an identity column to Table in SQL Server? “ Sometime the questions are very very simple but the answer is not easy to find. Scenario 1: If you are table does not have identity column, you…