Emergency Preparedness
Being prepared for things to go wrong is important, more so these days than in much of our past.
2020-09-04
85 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
220 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
221 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)
683 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,318 reads
SharePoint Disaster Recovery Plan
Hot standby disaster recovery process where SharePoint farm will become available in minutes
2018-03-15
4,037 reads
2017-07-20
981 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
identify consecutive records greater than 1
Hello I need help identifying all records that have consecutive hours (time in order)...
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers