When anyone asked me if any specific feature is available in SQL Server 2008 or if any feature will be disabled in future versions of SQL Server, I always pointed to the following list where all the deprecated database engine features are listed.
SQL SERVER – List All the DMV and DMF on Server
“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.
SQL SERVER – Find Most Expensive Queries Using DMV
The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries in SQL Server Box.
SQL SERVER – Spatial Database Queries – What About BLOB
Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. Let us learn about Spatial Database Queries.
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell Index Size
If you are a Powershell user, the name of the Laerte Junior is not a new name. He is the one man with exceptional knowledge of Powershell. He is not only very knowledgeable, but also very kind and eager to those in need. I have been attempting to setup Powershell for many days, but constantly facing issues. I was not able to get going with this tool. Finally, yesterday I sent email to Laerte in response to his comment posted here. Within 5 minutes, Laerte came online and helped me with the solution. He spend nearly 15 minutes working along with me to solve my problem with installation. And yes, he did resolve it remotely without looking at my screen – What a skilled and exceptional person!! I will soon post a detail note about the issue I faced and resolved with the help of Laerte. Let us see how we can find Powershell Index Size.
SQLAuthority News – List of Master Data Services White Paper
Since my TechEd India 2010 presentation I am very excited with SQL Server 2010 Master Data Services. I just come across very interesting white paper on Microsoft site related to this subject. Here is the list of the same and location where you can download them. They are all written by Top Experts at Microsoft.
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
I have decided that I would not write on this subject until I have received a total of 25 questions on this subject about dual core.Â