Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.
Steve Jones talks about the loss of data, and how it can impact your life. And why you want to be sure that your restores are ready in the event of a disaster.
Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.
This fall you have the chance to learn from a number of SQL Server experts and get a little vacation at the same time on a SQL Cruise.
A guest editorial from Josef Richberg, winner of the Exceptional DBA contests in 2009.
Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.
This article presents a generic function that makes it easy to query XML documents
Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
A simple motivational plan goes sideways in this guest editorial from Andy Warren.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
BCA KCP Samanhudi Telpon/wa.085373737699.Jl. Samanhudi No.57 B, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Telp/WA.0821°3111°179 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta Barat,...
BCA KCP Wahid Hasyim Telpon/wa.085373737699.Jl. KH Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers