Preview Mode Links will not work in preview mode

voiceofthedba's podcast

Welcome to the Voice of the DBA, thoughts from Steve Jones on databases, SQL Server, and life.

Scary Data Collection

Apr 17, 2019

Most of us would feel fairly creeped out by finding out an AirBnb or hotel had security cameras watching us. I'm not a woman, and I'm sure ladies are especially bothered by this, but there was an AirBnB rental where a guest found a camera using a little technology scanning. While cameras are allowed, they have to be...

Securing Code Early

Apr 16, 2019

Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We've published the login so people can...

Capture the Application Time

Apr 15, 2019

I've always thought that any times we recorded in a row were related to the actual data itself. Almost all of the time I've built software, we've assumed that the time a row is written or updated is the time we need to record as a timestamp. This works great for many applications and it certainly simplifies...

Building a Database Engine

Apr 14, 2019

I never wrote a database engine, unless you count writing code to read, write, and update flat files. I remember doing that early in my life with a friend as we tried to build our fantasy baseball game system. We needed a way to handle data, and use flat files, setting tokens to denote various "rows" and columns of...

Cloud Native

Apr 11, 2019

The cloud is an amorphous thing that isn't well defined, but we do know that there are various types of services (IaaS, PaaS, Saas) that many of the cloud vendors offer. While IaaS is the easiest platform on which to move our software applications, it is fundamentally limited and lacks the scalability of the...