Emergency Preparedness
Being prepared for things to go wrong is important, more so these days than in much of our past.
2020-09-04
88 reads
Disaster Recovery (DR)
How to Restore Model Database in SQL Server
In this tip we look at how to restore a missing or corrupt SQL Server model database.
2019-12-23
Expect the Unexpected with DiRT
Disaster recovery is no joke at Google, where they really test their systems, people, and processes.
2019-12-05
223 reads
DR Priority
Today Steve asks about HA and DR. What compromises and choices do you make in your environment and how do you ensure your clients can get to their data.
2019-11-22
227 reads
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”.
2019-10-31
Find Estimate Time of recovery for database after Reboot
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
696 reads
How Climate Change Impacts Disaster Recovery and Security
Severe weather events cause disruptions that could lead to security vulnerabilities.
2019-05-15
Bringing them back from the dead
When trying to find the causes for why the SQL Server service doesn’t start, one of the best places to start is the SQL Server Error log, but there is a problem!
2018-09-10
1,345 reads
SharePoint Disaster Recovery Plan
Hot standby disaster recovery process where SharePoint farm will become available in minutes
2018-03-15
4,252 reads
2017-07-20
986 reads
Blogs
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Forums
Is there a way for SP to know who called it?
Hi everyone I am writing an SP where there is logic inside the SP...
Planning for tomorrow, today - database migrations
Comments posted to this topic are about the item Planning for tomorrow, today -...
Bottlenecks on SQL Server performance
We have a BI-application that connects to input tables on a SQL Server 2022...
Question of the Day
The Tightly Linked View
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
cl.CityName,
o.OrderID,
o.Customer,
o.OrderDate,
o.CustomerID,
o.cityId
FROM dbo.CityList AS cl
INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
@OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @city VARCHAR(50);
SELECT @city = os.CityName
FROM dbo.OrderShipping AS os
WHERE os.OrderID = @OrderID;
RETURN @city;
END;
go
What is the result? See possible answers