Big Data

Technical Article

Alternative to MRTG?

  • Topic

I am looking for an alternative to using MRTG graphs that feed off csvs from performance monitor.  I have it running ok, but have some problems with getting 0 figures in the data stream from time to time and on initial setup. I don't know much about SNMP and really cannot install anything on the […]


6 reads

Technical Article

RE: Table Synchronization

  • Reply

Steve,i don't have any timestamp...But if i use triggers, the thing is that these two table are in two different serverers physically located in different palce over an intranetI am trying with replication....  


Technical Article

RE: how to find sa password from registry in sql 2000/7.0/6.5 if i forget the sa password?

  • Reply

For 6.5 run regedit - Go to HKEY_CURRENT_USER/Software/microsoft/MSSQLserver/SQLEW/Registered servers and then double click on the required one.THe SA will be on the right of the screen vertically.Don't tell anyone this came from me - And I never use it because I never, ever forget my SA password as they are stuck on my screen with […]


8 reads

Technical Article

RE: How to backup database onto network shared drives

  • Reply

You must first create a backup device that points to your network share, and then backup your database to the backup device you created. Gregory A. Larsen, DBA Contributor to 'The Best of 2002' book. Get a copy here: Need SQL Server Examples check out my website at



Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023


Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 


When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs


Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...


By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers