In this blog post, we will learn about methods for accessing SQL Server XML DataType. Here is an article which discusses the Author’s Perspective.
SQL SERVER – Interview Questions and Answers – Perspectives of an Author
Today is the first day of year 2012 – Happy New Year!. This blog post is written by my co-author of SQL Server Interview Questions.
SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience
I had very clear idea what my goals were in the book. I believed in unique learning experience. Let us talk about it in today’s blog.
SQL SERVER – A Quick Trick about SQL Server CONCAT function
Just a day before I was presenting at Virtual Tech Days and I wanted to demonstrate the current time to audience using SQL Server Management Studio, I ended up a quick error. If any of you ever tried to concat multiple values of different datatype this should not be surprise to you.
SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book
I was recently reading excellent Just Learned Tip regarding 3 part naming Cannot be used when dropping Views,Functions or Procedures. This is quite a well known tip however, every developer and DBA learns at sometime in their career with ‘hm…’ moment. To illustrate this further here is a simple case…
Read More
SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid
I recently had long email conversation with one of the blog reader who was struggling with installing SQL Server 2012 RC0 installation. I just thought I will publish what we have done and how we solved problem so if you are facing the same issue, you can avoid the same. In this blog post we will see how to fix setup error.
SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT
Today I had very interesting experience when I was presenting on SQL Server. While I was presenting the session when I ran query SQL Server Management Studio returned message like (8 row(s) affected) and (2 row(s) affected) etc. After a while at one point, I started to prove usage of @@ROWCOUNT function.