External Article

SQL Database: How to Configure Active Geo-Replication

  • Article

Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.


3,361 reads

Technical Article

List database recovery modes

  • Topic

Hi list,Does anybody have an idea where SQL server keeps the information about database recovery modes (full, simple, etc) rather then looking up in EM.Maybe someone has a script to get all modes for all databases on the server.Thank you,JP


2 reads

Technical Article

Notify user using trigger

  • Topic

On one of our databases we have a table on which data in appended whenever we have a problem in that database. Normally we check the table from time to time to look for addition of data. But I would like to create a trigger to notify a user (net send operator) on our network […]


1 reads

Technical Article

RE: Importing a CSV file using a DTS

  • Reply

Hi,I am sorry to post my answer accidentally before I am done:(Continued)     . delete the temporary tableAll of the 4 steps above can be in one stored procedure.  If you want, you can even:-modify step #2, replace any comma by ~-create a macro in excel to convert all '~' to ',' then set it up to […]


1 reads

Technical Article

RE: QOD 6/17

  • Reply

quote: Supplying the password in sp_change_users_login is new with SP3. I guess to be completely up to date they should have included that. Ahh... now that makes sense. Looking at an old test server I see that the SP3 changes are not there. Doesn't pay to keep things current I guess. I agree the Update_One […]


1 reads


Daily Coping 3 Feb 2023


Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs


Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Re-creating AG after server loss

By izinger

We recently had to rebuild servers that were configured with AG. I built everything...

Cannot run DynamicSQL Statement to merge table with JSON

By Weegee71

Hi there I have a problem with a dynamicSQL Statement. In this code, I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers