Ghosts in your Database
Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database. They are...
2018-12-10 (first published: 2018-11-26)
2,556 reads
Blog Posts
How To Restore Database in SQL Server 2014 From .bak - Step By Step
Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT administrators to ensure the security of data. In order...
2018-12-10
21 reads
How To Restore Database in SQL Server 2014 From .bak - Step By Step
Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT...
2018-12-10
5,966 reads
Moving SSISDB is not as easy as it sounds
We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...
2018-12-10
233 reads
My backup script (where, how, how big, etc.)
A while back I wrote about how to find where your backups are. And I’ve also written about I use...
2018-12-10 (first published: 2018-11-26)
2,080 reads
Privacy and Protection in the Age of the GDPR
We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at...
2018-12-10
241 reads
Setup Ola Hallengren SQL server Maintenance script
Ola Hallengren Maintenance Plan Deployment Many...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2018-12-10
9 reads
SQL Server Adventures In Reducing IO
In the interests of curiosity I’m going to take a query that runs a relatively simple aggregation over a large...
2018-12-10
295 reads
SQL Server Essentials for beginners
SQL is the essential part of SQL Administration and SQL Development. A quick overview of basics can take you a...
2018-12-10
241 reads
The Mystery of Missing Backup Files
Yoink – Backups Gone
Not only is this mystery of missing backup files worth discussing now, but has been a mystery worth...
2018-12-10
318 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Cempaka Putih Raya Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih,...
Alamat Kantor BCA KCU RAWAMANGUN Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
BCA KCU WAHID HASYIM Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers