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.

Jun 30, 2017

I was watching a presentation recently on database design and the speaker talked about how he hires developers. These are full stack developers, for whom the database is a portion of their responsibility. One of the tasks he gives them is a short database design test, designed to get a rough idea of their knowledge of...


Jun 29, 2017

I wrote about dealing with data loss recently, ansking what your plans are for a situation. Some of you might rely on digital systems, some rely on humans, and some just accept some data loss. All of those are valid responses, depending on your environment. Today I wanted to take another step on this journey.

Imagine...


Jun 28, 2017

I don't expect this to last, or I hope it doesn't, but SQL Server is lagging behind. I ran across a short piece on the SQL:2016 standards, and I know these standards aren't necessarily an important consideration for most of us when choosing a database. The standards are a compromise from many industry professionals...


Jun 27, 2017

Our databases store all kinds of data in them, depending on the purpose of your database. Most of us create tables and store data in response to some requirement or necessity in our organizations. Our decisions should be driven by good design principles, and I'd hope they are, but we do need to find a place to put all...


Jun 26, 2017

I really like replication as a technology. I think the ability to move data around to other systems, at a gross level, is extremely handy in many systems. While SSIS and other ETL tools are very flexible and powerful, they also require quite a bit of work to maintain. Being able to send a table (or a...