Scripts

Technical Article

Part 1 -- Restore a database to another instance...

  • Script

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.

2 (1)

You rated this post out of 5. Change rating

2016-03-14 (first published: )

803 reads

External Article

Do you regularly run queries and scripts in SSMS?

  • Article

SQL Server Management Studio is where most SQL scripts and queries are run, and although it does a decent job, it doesn't provide much help storing, sharing and managing the scripts particularly in the context of a team. Red Gate is considering building functionality into SSMS to help its users consume and share queries and scripts. Please help us by completing this short survey to help us define the requirements.

2013-04-12

3,832 reads

Technical Article

Grouped Failover, a 2008R2 version of Availability Groups

  • Script

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.

5 (1)

You rated this post out of 5. Change rating

2013-01-24 (first published: )

560 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

Validating Password Expiration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Validating Password Expiration

Extracting multiple fields from one column

By JeremyU

    Hello, I have a situation. I am trying to show each  distinct...

Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances

By Parthprajapati

Comments posted to this topic are about the item Unlock the Power of Google...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers