1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...
2014-10-27
26 reads
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-27
451 reads
We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...
2014-10-27
712 reads
For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...
2014-10-27
673 reads
The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-10-27
800 reads
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.
2)...
2014-11-07 (first published: 2014-10-27)
7,422 reads
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
164 reads
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-11-06 (first published: 2014-10-27)
18,851 reads
Today I am going to talk about the stored proc sp_executesql and the benefits it has over EXEC @SQL. Microsoft actually recommend that you use the sp_executesql stored procedure...
2014-10-27
11 reads
In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...
2014-10-25
297 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers