Disaster Recovery’s big brother Operational Recovery
I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...
2013-06-20
940 reads
Kenneth Fisher
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this:
SELECT LoginID, YEAR(HireDate)...
2013-06-19 (first published: 2013-06-17)
2,779 reads
Best practice recommendations for writing Dynamic SQL
Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...
2013-06-13 (first published: 2013-06-12)
5,585 reads
Using the OVER clause
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has...
2013-06-10
683 reads
Backup a password, change it, then restore it.
A couple of months ago I talked about moving a login from one server to another without the password. The...
2013-06-05 (first published: 2013-05-30)
2,339 reads
Easy way to generate a restore script.
Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....
2013-06-05
996 reads
Pattern searches beyond ‘%string%’.
I was asked today to take a table with a social security column and put all 0s if the column...
2013-06-03
905 reads
Using CROSS APPLY to calculate an aggregate across a single row.
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...
2013-05-28
1,468 reads
The many uses of CROSS APPLY
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...
2013-05-23 (first published: 2013-05-20)
21,506 reads
Using CROSS APPLY instead of a calculated variable
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working...
2013-05-22
871 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers