Skip to content
February 24, 2021
  • 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   Data Platform Virtual Summit 2020   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
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra
    • Virtual Symposium Recordings
    • Geek Talks
  • PodCasts
  • Conference
  • Resources
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
    • Connect With Amit Bansal
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

Read More

Posts navigation

1 2 Next

Subscribe to SQLServerGeeks

Ad

master classes

SSG_linkedin

SSG_fb

dps2017_logo_website

video courses

dps2017_logo_website

create your blog

guest_post

DataPlatformGeeks Social Media Channels

About Us

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

Subscribe To Our Newsletter

loader

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by SQLServerGeeks and DataPlatformGeeks.