SQL Server Education (by the geeks, for the geeks)
Recently one of our Staging Database Server hosted in the United States of America suddenly got Rebooted after which one of the database named ABC hosted on the server went into …
SQL Server SUSPECT Mode – Recovering a SQL Server 2000 Database Read MoreHi Everybody, I hope you all are doing well. I would like to thank Amit Bansal, Sarabpreet Singh, entire staff at www.sqlservergeeks.com, my fellow SQL Server Professionals who have given their …
My Sincere Thanks to www.sqlservergeeks.com Read MorePerforming a Database Backup is a part of DBA’s life. Backups are taken to ensure that in case of any emergencies Recovery is possible. When we talk about Recovery it means …
SQL Server – Understanding Various Types of Restores in SQL Server – Volume 1 Read MoreRecently, we need to perform a HotFix promotion on our Production environment. In HotFix promotion, the vendor who has developed the application has done some major enhancements to fix the bugs on the Application as …
SQL Server: A DBA’s Approach To Setup Transactional Replication – 4 NonStop Days At Office Read MoreWriting a proper T-SQL query which doesn’t have any bad impact on the server should be ideally a job of a good developer. But Many a times, the developers don’t focus …
SQL Server: Understanding SQL Server Performance Tuning – Why DateAdd is performing too slow. Read MoreIn a Replicated environment, it is possible that someone or the other at some point of time by mistake performs a DML operation against the Replicated Database on the subscriber.In a …
SQL Server: Somebody Has Manually Performed a DML Operation on the Subscriber – What to do next. Read MoreI was recently asked to set up Transactional Replication comprising of 29 publishers as well as same number of subscribers. One interesting challenge was that the size of the distribution database …
SQL Server – Controlling Growth of a Distribution Database Read MoreAs a Database Administrator, we all are normally involved in Setting up SQL Server Transactional Replication on our environment.Apart from setting up Transactional Replication, performing a proper maintainence of the same …
SQL Server Transactional Replication – Deep Dive Read MoreWhenever, we talk about Performance Tuning in an SQL Server environment, not necessary always due to bad indexes,statistics or perhaps due to poor query structure the query is behaving badly, in …
SQL Server: Why is NTEXT so bad to give a PAIN. Read MoreRecently, we had a brand new Production server hosted on a Windows 2003 Cluster along with SQL Server 2005 with Service Pack 3. This was an OLTP system hosted in a …
Designing a Backup Plan (SQL Server) Read More