June 2014 from Journey to SQL Authority with Pinal Dave

Every week, I have been blogging a brand new blog posts from last 11 years. The biggest complaint I receive from the audience is that as I have been producing lots of content, it is very difficult for someone to keep track of what I have been writing every day. Well, there are multiple solutions to this problem, but I am really not sure about which one will work the best. If you have any idea, do let me know how can I make sure that blog posts reaches to the interested audience and can get maximum advantage from it. Question for the day: I am planning to discontinue one of the services listed here: . Can you guess which service I am going to discontinue? (Please reply with your email) --- Now over to read the latest 5 blog posts of the week [SQL SERVER – Learning New Multipurpose FORMAT Function]( In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post.  [How to Add Column at Specific Location in Table? – Interview Question of the Week #126]( Question: How to Add Column at Specific Location in Table? Answer: Order of the column in the table should not matter.  [SQL SERVER – Not Able to Kill SPID with KILL WITH STATUSONLY]( Question: Why I am not able to KILL a SPID with command KILL (spid) WITH STATUSONLY?  [SQL SERVER – Quickest Way to Add LoopBack Linked Server for OpenQuery]( Here is the question which I received the other day from a user who was trying to add a linked server pointing its own server as he wanted to use OpenQuery. Let us read his question in details.  [SQL SERVER – How to Measure Page Splits Counter Value via T-SQL?]( Question: How to Measure Page Splits Counter Value via T-SQL?  [SQL SERVER – How to Update Two Tables in One Statement?]( Question: How to Update Two Tables in One Statement?  [How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125]( Question: How to Round Up or Round Down Number in SQL Server?  [SQL SERVER – Alternate to AGENT_DATETIME Function]( Sometimes back I posted about interesting function AGENT_DATETIME functions which will convert integers into datetime values. Someone commented that there might be some permission issues using this function which is only available in msdb database. So I write this post to give you alternate method without using any such functions.  [SQL SERVER – Master Database in Single User Mode – A Serious Issue]( There are some weird situations which I see in SQL Server. This is also a one of the surprising situation. One of my client reported via below screen shot. Let us see the issue of Master Database in Single User Mode. Let me know which one of the above is your favorite article? To make sure you keep getting these emails, please add rss@sqlauthority.com to your address book or whitelist us. Want out of the loop? [Unsubscribe](. Our postal address: SQL Authority, MG Road, Bangalore. India