Configuring a Transactional replication

Hello,
This post is intended to show you all the steps you will need to follow when you setup a transactional replication, in fact the first 5 steps are one...

Configuring a Subscription to an Azure SQL

This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful...

Enabling the SQL Server Agent in Linux Containers

At SQL Saturday Holland a few weeks ago I was (surprise, surprise) chatting about containers and mentioned that I hadn’t...

Configuring a Transactional replication

Hello,This post is intended to show you all the steps you will need to follow when you setup a transactional...

Implementing Temporal Tables Where You Have Existing Data

In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for...

Redgate at Summit 2017

I’ll be heading out to the PASS Summit next week, spending Halloween in a conference center with a lot of...

Query Store – SQL Server 2017 vs Azure SQL Database

I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...

10 Questions To Spark Conversation At Your Next SQL Event

Photo by rawpixel.com on UnsplashHere’s a word for word transcription of a conversation I’ve had a hundred times over:
“Hi I’m Bert.  What do...

10 Questions To Spark Conversation At Your Next SQL Event

Photo by rawpixel.com on Unsplash
Here's a word for word transcription of a conversation I've had a hundred times over:

"Hi I'm Bert.  What do you do?"
"I'm ____ and I'm a SQL developer."
"That's cool,...

UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data

SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...