Monthly roundups are very refreshing as it gives me a chance to go back and see what did I do last month. Let us learn in this blog post.
SQLAuthority News – SQL Server Performance Optimization – Seminar Series
I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more…
Read MoreSQLAuthority News – Download – SQL Server Monitoring Management Pack
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…
Read More
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could synchronize database and query on the same server. The production server should not be used for development work. It should be queried with proper methods (queries, Stored Procedures, etc.), supporting production application.
SQL SERVER – Getting Started with Execution Plans
Execution Plans is one of the most interesting subjects and I often get a question about it. Many people want to know how to get started.
SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Note: I have updated the title based on feedback of Davide Mauri (Solid Quality Mentors). Thank you for your help. Let’s see another reason…
Read More
SQL SERVER – Does Order of Column in WHERE Clause Matter?
Today is a quick puzzle time. Let us learn about – Does the order of column used in WHERE clause matter for performance? Let us learn today.
SQLAuthority News – Download Microsoft SQL Server Migration Assistant
SSMA for Oracle v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. SSMA for Access v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit…
Read MoreSQLAuthority News – Feedback Received for Virtual Tech Days Sessions on Spatial Database
I recently got opportunity to speak at Virtual Tech Days on August 18, 2010 on the subject Spatial Database. The event was heavily attended by enthusiasts world wide. I delivered session the on the subject of Spatial Database and it was great fun to deliver the session. I have delivered…
Read MoreSQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let…
Read More