Latest Posts

How to Protect SQL Server from Hackers and Penetration Tests

On June 3rd, the InfosecMatter blog published a post titled “Top #10 Vulnerabilities: Internal Infrastructure Pentest“. This blog post detailed the top most common vulnerabilities in Windows servers and networks found during more than 60 internal infrastructure penetration tests around the world. After reading this article, I was prompted to actively look for similar resources […]

Migrating from CosmosDB to SQL Server

Wherever you look, you find tools and resources to help you migrate from something that is not Cosmos DB, to Cosmos DB. The Cosmos DB migration utility tool can only export a JSON file at most, but that can rarely be good enough if you need to move around more than a handful of documents.

It took me a while to realize that I’m not going to find a publicly available migration tool for the job. So, I decided to make my own.

#tsql2sday 126 – Responding to COVID-19

This month’s #tsql2sday is hosted by the legendary Glenn Berry, and asks us about what we’ve been doing as a response to COVID-19.
We at Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.

The new “metadata-only column changes” feature in SQL Server 2016 is useless!

You might have seen the blog post by Paul White: New Metadata-Only Column Changes in SQL Server 2016. It talks about how, when a table is compressed, you can change (i.e. increase) a column’s data type without having to create a new table and migrate the data into it, and without having to refactor all of the underlying data. But, not everything is rainbows and unicorns…

Webinar – Development Lifecycle Basics for DBAs at the Data Weekender

The #DataWeekender is a free online conference scheduled for May 2nd, organized by the SQL Server community’s finest, as an online replacement for all the SQL Saturdays and other SQL Server conferences that were being canceled en masse due to the COVID-19 situation.

I am also a speaker in the event, and I’ll be presenting my Development Lifecycle Basics for DBAs webinar!


Something went wrong. Please refresh the page and/or try again.

Follow My Blog

Get new content delivered directly to your inbox.

Other ways to find me: