How to design a database flexible enough to accommodate several very different card games.
Read more
We’ve just released SQL Prompt 7.2 with new SSMS 2016 support, features and fixes. If you’re new to SQL Prompt try it for free. If you already use it, just ‘check for updates’ in SQL Prompt to upgrade to the new version. For more detail on what’s new, read on. SQL Server Management Studio... Read more
In the previous two articles, we considered the two most common data warehouse models: the star schema and the snowflake schema. Today, we’ll examine the differences between these two schemas and we’ll explain when it’s better to use one or the other. Read more
In this era of globalization, companies – including software developers – are always interested in expanding to new markets. This often means localizing their products for different areas. In this article, we’ll explain a few approaches to designing your data model for localization - specifically, for managing content in multiple languages. Read more
In a previous article we discussed the star schema model. The snowflake schema is next to the star schema in terms of its importance in data warehouse modeling. It was developed out of the star schema, and it offers some advantages over its predecessor. But these advantages come at a cost. In this article,... Read more
This is the fourth in our multi–part series on data modeling for information security as well as data characteristics. A simple data model for a fictional website that supports shared–interest organizations (bird–watching clubs, etc.) has provided us with content for exploring data modeling from a security viewpoint. Read more
People evaluating our software often ask us to send them an analysis document showing how we stack up against our competitors. It’s a very reasonable request, but because it’s one I always turn down I thought it would be worth sharing why I don’t think they’re meaningful. They’re selective During elections, politicians spend a... Read more
The XML file format for Redgate Data Modeler has changed to version 2.3. Read this article to find out what is new. Read more
Today, reports and analytics are almost as important as core business. Reports can be built out of your live data; often this approach will do the trick for small- and medium-sized companies without lots of data. But when things get bigger – or the amount of data starts increasing dramatically – it’s time to... Read more
In the open source world, there’s an increasing trend to offer personal or community editions of paid-for tools. There’s a damn good reason too. Many charities and educational institutions as well as individual users turn to open source software in an effort to lower costs. The flipside is, while there’s no upfront cost, there... Read more
