Repair a Windows Server 2016 installation

This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...

Schema only backup or schema only DB copy

Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded...

Seattle SQL Pro Workshop 2017

Seattle SQL Pro Workshop 2017
October is a great time of year for the SQL Server and Data professional. There are...

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

Non Profit Umbrella Org – Good Idea?

Note: Published too soon, so lots of edits from the first version. Sorry for any confusion.
I had a question from...

SQL Server: What will REPAIR do?

So I had a corruption issue and I was thinking about running repair but I wanted to know what would...

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

Database Fundamentals #13: Data Entry Through T-SQL

T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...

Dynamic Data Masking – Tracking all masked columns in your database

dotnetvibes
I have presented on Making Developers lives easier with SQL Server 2016 multiple times over the last couple of months,...