New Page Functions in SQL Server 2019
I will be the first to admit that I am what one might call a “SQL Head”. In other words, I’m a nerd that likes to dig into the internal workings of SQL Server, sometimes down to the bits and bytes. The tools to facilitate this archaeology have slowly been evolving and with the release […]
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system it resides on. This was echoed during the keynote at SQL Bits 2019 by the Microsoft team, which you can watch here. Later that weekend, I gave a session about database internals. My presentation is […]
Checking Open Ports in Azure
Let’s be honest here, data security is really important to me. Some people probably think that I go to extremes to ensure that my data as well as my customers data is secured. With that, sometime ago, I wrote a blog post on utilizing a VPN server that I built on an Azure Virtual Machine […]
Secure Travel
Traveling in today’s age of technology is a lot easier than in the past. You can start your journey in the morning of one country and be half way across the world by nights end. When traveling, data security is usually always at the forefront of my mind. I recently traveled to a conference. While […]