2025-05-12
275 reads
Log Shipping
2025-04-28
403 reads
Minimal Downtime Storage Migration of Large Databases
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2024-01-01 (first published: 2021-02-24)
8,072 reads
2020-12-10
421 reads
2018-06-28
871 reads
Logshipping Report
Get Logshipping report only when secondary is more than certain time behind Primary.
2017-11-14 (first published: 2017-10-27)
475 reads
2016-05-11
4,469 reads
Move an Existing Log Shipping Database to a New Monitor Server
How to move a log shipping database to a new monitor server without removing and rebuilding the log shipping setup.
2016-04-04
2,521 reads
Faster Log Shipping Restores
When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.
2015-12-11 (first published: 2015-11-23)
3,104 reads
Streamline Log Shipping Failovers: DR Made Just For You…
A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.
2018-12-14 (first published: 2015-09-08)
3,728 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
Converting Money
Comments posted to this topic are about the item Converting Money
BCA KCU WISMA ASIA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers