Earlier this week Microsoft has announced SQL Server 2014. The release date of Trial of SQL Server to be believed later this year.
SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage
This is a follow up blog post of SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation. I wrote that blog six years ago and I had plans that I will write a follow up blog post of the same. Today, when I was going over my to-do list and…
Read MoreSQL SERVER – Script to Update a Specific Column in Entire Database
Last week, I have received a very interesting question and I find in email and I really liked the question as I had to play around with SQL Script for a while to come up with the answer he was looking for. Please read the question and I believe that…
Read MoreSQLAuthority News – Advantages of Distance Learning
Distance education is extremely popular – almost overnight, it seems. Almost everyone has taken an online course, or knows someone who has, or is considering joining an online school. There are many advantages and disadvantages to attending an online school – but the same can be said of attending a…
Read More
SQL SERVER – Weekly Series – Memory Lane – #031
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…
Read MoreSQLAuthority News – New Theme of SQLAuthority and Video Courses
I have been blogging for almost 7 years now. Recently I reached a very important milestone for my blog. I completed over 2500 blog posts as well have been receiving consistently over 2 Million Views every month. It has been a fantastic ride and I am planning to continue contributing…
Read MoreSQL SERVER – Add Identity Column to Table Based on Order of Another Column
After reading my earlier article on Identity Column, I received a very interesting question. The reason, I like to call it interesting is though, I have provided answers to him, I believe there should be another better alternative to this problem. Let us see the question first in his own…
Read More