Technical Article

Script to create a standby database server(new).

New feature to relocate files on the secondary server has been added to this script. If you don't need this feature please use my other script that is posted on this website.Run this script on a secondary SQL Server to replicate the data of all the user databases from the primary server every 15 minutes. […]

2002-08-09

271 reads

Technical Article

Script to montior ErrorLogs every 3 hours.

This script monitors your errorlogs every 3 hours for the past 3 hours. It notifies you by email for all types of errors and by pager for all critical errors with severity type > 16. Saves lot of time when you have to monitor several servers every day 24x7. Run this script on a dedicated […]

1 (1)

2002-08-09

1,178 reads

Technical Article

Script to create a standby database server.

This script will do a full backup and transaction log backup of all the user database on the primary server and restore it over to the secondary server. The full backup/restore runs once every day and the transaction log backup/restore runs every minutes. Just provide the name of the primary and the secondary server and […]

2002-07-12

355 reads

Technical Article

Concatenate Rows without a cursor

You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]

5 (1)

2002-07-02

1,029 reads

Blogs

Why You Need Presentation Skills

By

And no, the answer is not because you want to be a Microsoft MVP....

Daily Coping 29 Sep 2022

By

Today’s coping tip is to avoid saying “I should” and make time to do...

How to Calculate Compound Rate in Power BI

By

Recently I had an interesting use case where I had to a compound calculation...

Read the latest Blogs

Forums

acquista Banconote Euro contraffatte non rilevabiliWhatsApp - - - +32467691627

By doctorbankbills

acquista Banconote Euro contraffatte non rilevabiliWhatsApp - - - +32467691627 Italia Denaro contraffatto non...

Suhagra 100 | Online Treatment For Men

By buymygenerix

Now all men can solve the problem of erectile failure at the time of...

+32467691627) Kaufen gefalschten dinero deutschland deutschland

By doctorbankbills

+32467691627) Kaufen gefalschten dinero deutschland deutschland Neugeld kaufen gefälschtes geld auf peak kaufen gefälschte...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers