Minion CheckDB Beta

Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...

Re-Evaluating Best Practices

I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.

Starting...

MongoDB : Point in Time Restore/Recovery of MongoDB

This post demonstrates the methods of PIT recovery of the database. The step by step details of the recovery process...

Konferenzen im SQL Server Sommer 2016 – Conferences in SQL Server summer 2016

(DE)
Kaum von den SQLBits XV in Liverpool zurück, auf der ich die Security-Features des SQL Server 2016 vorstellen durfte...

Catching Up on The #SQLPASS Virtual Chapters

(Didn't realize until I was posting that this was my 100th post...whew!)

--

A few months ago we purchased a new "smart"...

MDW Data Collector – Collection Set jobs not working

ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...

10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )

This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good...

Query Store, Forced Plans, and New Plans

I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in...

RAID your backups

Let’s start with a very brief definition of some RAID levels.
RAID 0 : Stripe your data across multiple disks. Writing a...

Continual Deployment of Visual Studio SqlProj

Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...