-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2018

Renaming a local windows login after SQL Server Computer Name Change

I had an interesting issue last week. I had to rename non-domain (Workgroup) SQL Server Virtual Machine in Azure. The server was running the Database Engine, Reporting Services and Integration Services

I actually run through a blog post I wrote the best of 8 years ago titled Renaming a Standalone Instance…

Read more

0 comments, 1,777 reads

Posted in The SQL DBA in the UK on 15 January 2018

SCOM: SQL Instance and Databases exclusion

This  post is by Chris Gibson

I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM environment.  These databases are created during a backup process and are always named “_Clone”.  I’d previously excluded SQL Express instances by their name (Maps, Live, MSEE) and…

Read more

1 comments, 604 reads

Posted in The SQL DBA in the UK on 10 January 2018

Patching your SQL Servers - Meltdown and Spectre

The latest security issue with the name "Meltdown and Spectre" affecting Intel processors  was made public last week. This security issue affects a lot of systems and Operating Systems it is not a Microsoft specific issue. I think I read somewhere that ALL Mac devices are affected. Whilst details…

Read more

0 comments, 489 reads

Posted in The SQL DBA in the UK on 8 January 2018

What is the oldest version of SQL Server you are running?

I have a  twitter poll running asking "What is the oldest version of SQL Server you are running?", to use as evidence in a talk I have planned for later in the year. 



I’d like to know what is the oldest version of SQL Server  you have running in a…

Read more

0 comments, 347 reads

Posted in The SQL DBA in the UK on 3 January 2018