Skip to content
February 6, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Satnam Singh

SQL Server

SQL Server SUSPECT Mode – Recovering a SQL Server 2000 Database

December 17, 2012September 15, 2014 - by Satnam Singh - 10 Comments.

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 More
SQL Server

My Sincere Thanks to www.sqlservergeeks.com

October 31, 2012August 28, 2014 - by Satnam Singh - 2 Comments.

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 …

My Sincere Thanks to www.sqlservergeeks.com Read More
SQL Server

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

September 20, 2012August 28, 2014 - by Satnam Singh - 5 Comments.

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 …

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

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

August 27, 2012August 28, 2014 - by Satnam Singh - 1 Comment

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 …

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

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

July 20, 2012August 28, 2014 - by Satnam Singh - 8 Comments.

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 …

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

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

July 17, 2012August 28, 2014 - by Satnam Singh - 3 Comments.

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 …

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

SQL Server – Controlling Growth of a Distribution Database

July 7, 2012August 28, 2014 - by Satnam Singh - 2 Comments.

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 …

SQL Server – Controlling Growth of a Distribution Database Read More
SQL Server

SQL Server Transactional Replication – Deep Dive

July 4, 2012November 29, 2014 - by Satnam Singh - 3 Comments.

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 …

SQL Server Transactional Replication – Deep Dive Read More
SQL Server

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

July 3, 2012August 28, 2014 - by Satnam Singh - 4 Comments.

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 …

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

Designing a Backup Plan (SQL Server)

June 20, 2012September 16, 2014 - by Satnam Singh - 3 Comments.

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 …

Designing a Backup Plan (SQL Server) Read More

Posts navigation

1 2 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.