To change SQL server collation without rebuilding the instance

A few days ago, I came across an issue where we had to change the SQL server instance collation and we were just asking the clients to rebuild the system databases to do so in the previous cases. But this time the client could not afford to do that and asked for a plan B….

0

Upgrade of SSRS from SQL 2008 R2 to SQL 2012

Yesterday, I encountered a weird scenario where in the SSRS component was failing to upgrade from SQL 2008 R2 to SQL 2012 where in the SQL database engine and all the other components succeeded. SSRS component upgrade was failing with the below error : TITLE: Microsoft SQL Server 2012 Setup —————————— The following error has…

0

Sharing TDE Encrypted Backup outside the organisation.

In order to share the TDE Encrypted Database backup with somebody outside the organisation, the below steps can be followed. ++ Create new temporary database in order to prepare a make-shift copy of the intended database. RESTORE DATABASE MyEncryptedDB_Temp FROM DISK = N’C:\Temp\MyEncryptedDB.bak’ WITH MOVE N’MyEncryptedDB’ TO N’C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MyEncryptedDB_Temp.mdf’, MOVE N’MyEncryptedDB_log’ TO N’C:\Program Files\Microsoft…

0

SQL failing to come online with SQLClusterResourceWorkerWaitForCompletion() failing

A few days back, I was working on an issue where in my client applied the patch KB3045318 on his SQL server instance running on SQL server 2012 SP1 build. As it was a 2 node – Failover Clustered Instance, he had applied the patch simultaneously on both the nodes and post which he has rebooted…

0

Tit Bits (2) on recent speculative execution side-channel vulnerabilities

Microsoft is constantly working to address the new publicly disclosed class of vulnerabilities referred to as “speculative execution side-channel attacks” that affect many modern OS and processors. Microsoft has developed the required patches both at the OS level and the SQL server level to help address this vulnerability which can be obtained in my previous blog : https://blogs.msdn.microsoft.com/shreyasgowda/2018/01/12/tit-bits-on-the-recent-speculative-execution-side-channel-vulnerabilities/…

0

Tit-Bits on the recent speculative execution side-channel vulnerabilities

Microsoft is aware of a new publicly disclosed class of vulnerabilities that are referred to as “speculative execution side-channel attacks” that affect many modern operating systems including Android, Chrome, iOS, and MacOS and processors, including those from Intel, AMD, and ARM. Microsoft has released several updates both at the SQL application level and the Windows OS level to…

0

SQL session blocked by a negative SPID (-2)

A couple of times now I have faced this issue with my clients where SQL Server session is blocked by another session that has a negative SPID value. When we ran sp_who2 the SPID value that was blocking was (-2). When we tried to KILL the session we got an error that this is not…

0