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.

Jan 19, 2018

This is a great thread on Twitter from Jim Burger, a long time software developer. The thread is a distillation of how he keeps a passion for learning across decades. I think it's a good list of items, seven of them in total. I'll give a quick summary, but he has a bit more depth in each tweet. The seven are:

- Invest...


Jan 18, 2018

David Poole wrote a nice summary of the GDPR regulations that come into force this spring in Europe. He covers a number of the sections, trying to provide a simple explanation of the potential issues from the perspective of a data engineer. That's likely the role most of us fill , and I think David does a good job of...


Jan 16, 2018

Many of us work with software and often wish that we something was designed differently. I'm sure many of us feel the same way about our database schemas, which is usually even harder to change. In any case, we often want to mold software to fit our thought process. We're often asked to alter software to meet...


Jan 12, 2018

When I started working with SQL Server and Windows, it seemed that the administrative side of many actions was limited. We could add and drop many items, but that was it. Relatively few tools allowed setting limits or disabling them, which was a pain. After all, I'd gotten used to setting up accounts for vendors and...


Jan 11, 2018

This is part of a series that looks at interview questions that you might be asked.

One of the cornerstones of a relational database is normalization. This is a database design technique that is used to decide how we might distribute data among tables and columns. If someone were to ask you "what is normalization" in...