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...
Jun 23, 2017
It's summertime in the Northern hemispheres, and a time when much of the world takes their holiday time away from work. Most kids are out of school for at least part of the June/July/August time period. With many of us workers trying to spend time with our families, this is the part of the year that we schedule trips...
Jun 22, 2017
The British Airways computer failure has been on my mind for a few weeks. It seems like such an epic failure in 2017 from a high public company that many, many people depend on. I still struggle to believe the power explanation, and really, I'm not sure there's any explanation that I would accept. At this point in our...
Jun 20, 2017
PostgreSQL is a popular relational database, one that was designed to be an object relational system, based on standards, and allowing for extensibility. I've always thought this was a great system, exceeding SQL Server in some ways, though falling short in others. It's popular, and certainly used enough so that Azure...