Skip to content
April 1, 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 Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • 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 by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • 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: Abhay Chaudhary

SQL Server

Performance Tuning SQL Server Transactional Replication – Part 1

February 12, 2014September 11, 2014 - by Abhay Chaudhary - Leave a Comment

I remembered my childhood days when I use to get mechanical toys and how I use to experiment with them eventually ending up messing everything.This is true even when we grow …

Performance Tuning SQL Server Transactional Replication – Part 1 Read More
SQL Server

SQL Server: Engine Estimated time to complete Online Index operations.

July 13, 2012August 28, 2014 - by Abhay Chaudhary - 6 Comments.

There is always a way to work around something even if we are not able find the absolute solution. So the show must go on .I am sure that in any …

SQL Server: Engine Estimated time to complete Online Index operations. Read More
SQL Server

SQL Server Real-time Monitoring using WMI classes: Part -3

March 9, 2012November 28, 2014 - by Abhay Chaudhary - Leave a Comment

SQL Server Real-time Monitoring using WMI classes: Part -3 I hope you have been through both Part 1 and Part 2 of this series .In Part 1 we discussed about using …

SQL Server Real-time Monitoring using WMI classes: Part -3 Read More
SQL Server

SQL Server Real-time Monitoring using WMI classes: Part -2

February 20, 2012November 28, 2014 - by Abhay Chaudhary - 1 Comment

SQL Server Real-time Monitoring using WMI classes: Part -2 In the first part of this blog series, we discussed that starting with SQL Server 2005, we can use SQL Server agent …

SQL Server Real-time Monitoring using WMI classes: Part -2 Read More
SQL Server

SQL Server Fine – Tuning Transactional Replication Performance – Part 3

February 18, 2012November 28, 2014 - by Abhay Chaudhary - 2 Comments.

This is the last one in this series of SQL Server Fine – Tuning Transactional Replication Performance. While PART – 1  and   PART – 2  were somehow correlated , this blog …

SQL Server Fine – Tuning Transactional Replication Performance – Part 3 Read More
SQL Server

SQL Server Real-time Monitoring using WMI classes: Part -1

February 18, 2012September 19, 2014 - by Abhay Chaudhary - 28 Comments.

SQL Server Real-time Monitoring using WMI classes: Part -1 We all know that that SQL Server had a great face lift from SQL Server 2000 to 2005 .Everything else was a …

SQL Server Real-time Monitoring using WMI classes: Part -1 Read More
SQL Server

SQL Server Fine – Tuning Transactional Replication Performance – Part 2

February 12, 2012November 28, 2014 - by Abhay Chaudhary - 2 Comments.

Hope you have liked the first part of SQL Server fine – tuning transactional replication performance. In case you have not been through it you can check it here . In …

SQL Server Fine – Tuning Transactional Replication Performance – Part 2 Read More
SQL Server

SQL Server: Address translation- How Virtual Memory is mapped to Physical Memory

February 11, 2012October 8, 2014 - by Abhay Chaudhary - 4 Comments.

Introduction We all know that data retrieval will be fast if the data pages are found in RAM .If the data pages are not in RAM, they are fetched into RAM …

SQL Server: Address translation- How Virtual Memory is mapped to Physical Memory Read More
SQL Server

SQL Server: Recreating Builtin/administrator account in SQL Server ( 2000 and above)

February 11, 2012August 28, 2014 - by Abhay Chaudhary - 2 Comments.

Hi Guys , A few days ago someone at client’s site removed the builtin administrator from SQL Server as it was one of the risks mentioned in the agreement .Everything was …

SQL Server: Recreating Builtin/administrator account in SQL Server ( 2000 and above) Read More
SQL Server

SQL Server Replication Stored Procedure execution- Will the subscriber Database be updated twice if the table and SP on the same table (that inserts\updates\deletes) are the articles in the same or different publications

January 26, 2012September 19, 2014 - by Abhay Chaudhary - 3 Comments.

While many of you might have tested and implemented the SQL Server Replication stored procedure execution already, many might still be considering it and surely would be Googling or Binging around …

SQL Server Replication Stored Procedure execution- Will the subscriber Database be updated twice if the table and SP on the same table (that inserts\updates\deletes) are the articles in the same or different publications 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.