Broken Update With Join

Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see...

Migrate from on-prem SQL server to Azure VM IaaS

Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an...

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...