Log in | Register

Satnam Singh, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Satnam Singh, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



About Satnam Singh

This author has not yet filled in any details.
So far Satnam Singh has created 18 entries.

SQL Server SUSPECT Mode – Recovering a SQL Server 2000 Database

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 the SQL Server SUSPECT mode. The database was hosted on a SQL Server 2000 platform with Service Pack 3 on a Windows Server […]

By |December 17th, 2012|Categories: SQL Server||7 Comments

My Sincere Thanks to www.sqlservergeeks.com

Hi 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 valuable time in reading my various articles and blog posts due to which L&T Infotech had recently awarded me for Outstanding Contribution in my Current […]

By |October 31st, 2012|Categories: SQL Server||2 Comments

SQL Server – Understanding Various Types of Restores in SQL Server – Volume 1

Performing 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 that we are referring to Restore. Understanding the various types of Restores is important because depending upon the situation the DBA needs to […]

By |September 20th, 2012|Categories: SQL Server||5 Comments

SQL Server: A DBA’s Approach To Setup Transactional Replication – 4 NonStop Days At Office

Recently, 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 well as on the database level. As a pre-requisite, before the HotFix promotion starts, we need to break the LogShipping as well as Transactional Replication. […]

SQL Server: Understanding SQL Server Performance Tuning – Why DateAdd is performing too slow.

Writing 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 on this area thus resulting in an improper query structure causing a bad damage to the server resources. In this article, Satnam Singh, […]

By |July 20th, 2012|Categories: SQL Server||8 Comments

SQL Server: Somebody Has Manually Performed a DML Operation on the Subscriber – What to do next.

In 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 Transactional Replicated environment which is a One way traffic such a mistake can prove out to be dangerous.In this article,Satnam Singh a Senior […]

SQL Server – Controlling Growth of a Distribution Database

I 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 suddenly increased from few MB’s to around 62 GB and as a result the disk on which the production database was hosted quickly […]

SQL Server Transactional Replication – Deep Dive

As 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 is also very important. In this exclusive article, Satnam Singh, a Senior SQL Server DBA from Larsen&Toubro Infotech,Mumbai,India discusses one such Real World […]

By |July 4th, 2012|Categories: SQL Server||3 Comments

SQL Server: Why is NTEXT so bad to give a PAIN.

Whenever, 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 some cases it is possible due to a Incorrect Data Type the query is responding very poor. In this article, Satnam Singh,a Senior […]

By |July 3rd, 2012|Categories: SQL Server||4 Comments

Designing a Backup Plan (SQL Server)

Recently, 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 DataCentre in New Jersey,United States of America. The server had 16 CPU’s along with 32 GB of Memory. The server initially had just […]

By |June 20th, 2012|Categories: SQL Server||3 Comments