This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time.
SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
I had previously written two articles about an intriguing observation of triggers online. SQL SERVER – Interesting Observation of Logon Trigger On All Servers SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution If you are wondering what made me write yet another article on logon…
Read MoreSQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
Does the title of this post trigger your mind? If you all remember, a few days back I had written an article on my interesting observation regarding logon triggers. I would advise you to first read SQL SERVER – Interesting Observation of Logon Trigger On All Servers before continuing with…
Read MoreSQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
K-MUG is organizing TechEd Trivandrum on 27th June, 2009. Not just this, they are launching an official PASS Chapter in Trivandrum. The Agenda of the event is here and if you are around Trivandrum do not miss the opportunity to be a part of this upcoming great event. If you…
Read MoreSQLAuthority News – Update on pinaldave.com and SQLAuthority.com
Problem: SQLAuthority.com site was not allowed in some browsers as pinaldave.com site was marked as malware or badware distributing third party site. Status: SQLAuthority.com and pinaldave.com both the sites are safe now and there is no threat to your computer. Feel free to click on the links. Since the last…
Read MoreSQL SERVER – Delete Duplicate Rows
I had previously penned down two popular snippets regarding deleting duplicate rows and counting duplicate rows. Today, we will examine another very quick code snippet where we will delete duplicate rows using CTE and ROW_NUMBER() feature of SQL Server 2005 and SQL Server 2008.
SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success
TechEd on Road Ahmedabad In India, TechEd was held in Hyderabad in the month of May. You can read myTechEd summary article here. A similar event will be organized in 10 major cities in India. Ahmedabad saw its first TechEd on Road and it was wholeheartedly welcomed by technology enthusiasts.…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.