I recently received email from one of my very close friend from California. His question was very interesting. He wanted to know how many virtual processors are there available for SQL Server. He already had script for SQL Server 2008 but was mainly looking for SQL Server 2000. He made me go to my past. I found following script from my old emails (I have no reference listed along with it, so not sure the original source).
SQLAuthority News – An Incredible Successful SQL Saturday #116 Event – First SQL Saturday in India
We have recently wrapped up our most recent event, SQL Saturday #116, and I am I am sure I am not alone in reporting that it was a huge success! We had a full crowd – every seat taken, plus standing-room-only in the back. We also had a lot of…
Read MoreSQL SERVER – An Inspiring Personal Story – Movie from The Book – Video Course – SQL Server Questions and Answers – Pluralsight
Nov 3, 2011 – Visit to Grandma When our SQL Server Interview Questions and Answers book got published I ran to my grandma with a copy of the book for her blessings. Well, just like every grandma, she loves me, her grandson, unconditionally. She is not into the technology domain (obviously), but she loved…
Read MoreSQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31
Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…
Read More
SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31
The year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective. Let us see the puzzle of Advantages of Partitioning.Â
SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31
Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…
Read More
SQL SERVER – Reclaiming Space Back from Database – Quiz – Puzzle – 28 of 31
Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…
Read More
SQL SERVER – Lots of Date Functions – Find Right One to Use – Quiz – Puzzle – 27 of 31
The year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective. Let us see a puzzle on date functions.
SQL SERVER – Common Gotcha’s Associated with Common Table Expressions (CTE) – Quiz – Puzzle – 26 of 31
Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…
Read MoreSQLAuthority News – Interview with Book Authors after 2 Months of Book Released
Community is the most motivating force for me. I have often found situations where I have done more and better things because there was community around me. My latest book SQL Server Interview Questions and Answers is the result of the community’s support and love. Without the wide acceptance of…
Read More