Posts

Showing posts from January, 2017

Data Modelling and Diagramming Database Schemas

Image
So, I have recently been designing a schema for a new database system. As everyone knows, this is a technical process and requires a good understanding of the problem domain to make sure you collect all the business concepts and relationships. For these kind of things, you can't beat a good entity relationship diagram to visually see the makeup of your database tables and the relationships between them. This post is about the "Toad Data Modeller" application which is what I've been using to model my database design. It's such a great tool that I think it should be present in the toolbox of any DBA. Now, I know Microsoft includes a rudimentary diagramming tool in SQL server. Just right-click on "Database Diagrams" and add the tables you want to include. But this feature hasn't been shown any love since SQL Server 2000 and the diagrams are very simple. Microsoft Visio is another tool I've previously used and it allows you to create an ERD

Another Year. Another Year's Checklist!

Ahhh yes… Another year! Another fresh start and set of goals for the year. So many good intentions. On this blog I try to detail my meandering adventures in technology, so I thought I'd write up the tech-subjects I've had in the back of my mind but never got around to looking into. You never know, maybe this is the year I can tick some of them off!! Truth be told, I have had this laundry list of things-to-do-and-learn swirling around my head from last year. And maybe the year before as well. C++ 17 will be released this year. I've been keeping up with all the new toys that have been added to the language since C++11. Even though I don't code in C++ anymore (C# is my daily driver) I still have a fondness for C++. It would be good to have a refresher on some of the newer language features. Although, it seems like C++20 is going to be the BIG release with modules (finally) and async/await billed as features! Install and play with .NET Core on Linux and