SQLAuthority News – 2500 Blog Posts, 2 Million Views per month, 62 Million Total Views
Today, I am very happy as the journey I started almost 6.5 years ago has very important milestone. I have stopped blogging about my milestone for a long time as I believe that was just taking up the space in my blog and was not providing any useful information. However, today is a special day. This is my 2500th blog post and now the next 2500th blog post will come after many years. We also got 2 Million Views per month this year.
SQL SERVER – SQL Puzzle of SET ANSI_NULL – Win USD 50 worth Amazon Gift Cards and Bubble Copter R/C
Note: This contest is over, so enjoy the brain teaser about ANSI_NULL. We all love puzzles and here is interesting puzzle which you can play with me and win Amazon Gift Cards and Bubble Copter R/C. The contest for Amazon Gift Card is open worldwide, however, Bubble Copter winner will be chosen from USA only.
SQL SERVER – How to use xp_sscanf in Real World Scenario?
SQL SERVER – Puzzle and Answer – REPLICATE over 8000 Characters
SQL SERVER – Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT
Have you ever worked with CONCAT_NULL_YIELDS_NULL earlier in your career? If yes, you will find this post very interesting for CONCAT.
SQL SERVER – Weekly Series – Memory Lane – #028
SQL SERVER – Adding Column Defaulting to Current Datetime in Table
Presenting a technical session is a greatest experience one can have and I enjoy doing the same. While I write this blog post, I am presenting at Great Indian Developer Summit in India. The event is a grand success and I am having a great time at this event. One of the questions which I often receive is how do one can add the column to existing table which will be auto-populated with the current datetime when the original row is inserted. There is indeed a simple solution to achieve this goal. One has to just create table with default value as a current datetime.