sys.dm_db_index_physical_stats – Day 1 – One DMV a day
Hello Geeks and welcome to the first day of the long series to come in One DMV a day. In this series of blogs I will be exploring and explaining the …
Read MoreAuthor: Manohar Punna
SQL Server Day 25 Jan 2014 – Hyderabad – Amit’s quote “Rocked as usual”
The SQL Server Day, 25th January 2014, Hyderabad. After a long gap of two months, the first event for SQL Server Geeks in Hyderabad has started with a rich flavor beyond …
Read MoreSQL Server Day 26 Oct 2013 – Hyderabad SQL Geeks storm the weather
It has been a long time I have written a blog and this is not a technical blog. I wanted to share my experience with the first two events of SQLServerGeeks …
Read MoreSQL Server – SQL Agent Proxies
I have seen many DBAs arguing on xp_cmdshell as a security risk or a bad practice. And on a strong recommendation of a DBA Architect VENDOR your company has chosen to …
Read MoreSQL Server – Upgrade fails – “The Instance ID ‘MSSQLSERVER’ is already in use by SQL Server instance ‘MSSQLSERVER.INACTIVE’.”
This is one of the very frequent errors we receive when we try to upgrade to 2008 or 2008 R2 or to that matter even to 2005. The upgrade may fail …
Read MoreSQL Server Transparent Data Encryption
Transparent Data Encryption is introduced in SQL Server 2008. This feature has been introduced to provide more security to the data stored at the database level. It has the most valuable …
Read MoreSQL Server Cluster Domain Groups are Unavailable – Cannot upgrade
I had seen a forum post and was not able reply on it. Below is a blog from my old blog which has the answer for the forum topic. Just moving this …
Read More