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: )

826 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: )

565 reads

Blogs

Visualising SQL Server in Kubernetes

By

The other day I came across an interesting repo on github, KubeDiagrams. What this...

Picking a Starting Table in Test Data Manager

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

SQL Server Migration Using a Distributed Availability Group

By

SQL Server migrations are a headache, ask anyone who’s been through the pain of...

Read the latest Blogs

Forums

Prepare Sum of Bill Amount Having two different status with fast performance

By techrajendra

1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...

sql server not responding

By aman

SQL server became slow before I ran exec sp_updatestats

Counting Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Bits II

Visit the forum

Question of the Day

Counting Bits II

What is the result of this query in SQL Server 2022+?

select bit_count('7')

See possible answers