When you were learning database concepts, data modeling looked pretty easy, didn’t it? You knew all the rules, and modeling seemed like a game: get a challenge, do your best, and eventually solve it. Job well done! Moving up to the next level – and so on. Read more
SQL in the City 2016 won’t be hosted in London or Seattle this year. Instead we’ll be coming to every location worldwide – virtually. Redgate has hundreds of thousands of customers across the globe, so we’ve decided to host a virtual event online this year to reach as many of you as we can... Read more
Financial institutions, especially banks, usually have really large datasets. To use that data, it must be stored in such a way that it is easily available for generating reports. The trend now is to use a data warehouse to store all your relevant data, and to use smaller data marts (subsets of the warehouse)... Read more
A couple of years ago, Redgate adopted Database Lifecycle Management (DLM) as a unifying context for our existing and future database tools. But what exactly is DLM? Why is Redgate so keen on it? Is it a change in direction, an acknowledgement of customer demand, or just a different way of describing the DevOps... Read more
Let’s be honest: we all love to play games, especially on our computers. Until the Internet became widespread, most of us played computer games by ourselves, usually against AI opponents. It was fun, but as soon as you realized how the gameplay mechanics worked, the game lost most of its magic. Read more
The bill of materials (BOM) design pattern is deceptively simple, yet incredibly powerful. Historically, it’s been employed to model product structures, but the pattern can be used to do much more than simply define a hierarchy. This article will introduce three very different examples to help you to recognize the pattern in your own... Read more
No, it almost certainly isn’t. Besides, how would you know either way? Let me explain. Most modern software development today includes some form of automated testing. While comprehensive unit testing is still sorely lacking in many organizations, it’s often mitigated by other forms of automated testing conducted later on in the development cycle. Code... Read more
A lot has changed over the last 30 years, especially in IT-related domains, but few things have changed as much as how we shop. We still mostly buy milk and groceries at physical stores, but widespread online stores have led most of us to try some form of e-shopping. Today, we’ll take a... Read more
We’ve been talking about licensing system changes for a while, and over the next few weeks they start rolling out in the first batch of products. This means that when you update to the next versions of our products, you’ll be asked to log in with a Redgate ID: Logging in gives you access to... Read more
The long-awaited release of SQL Server Management Studio (SSMS) 2016 is approaching, bringing with it a more modern look and feel, more features, and more advantages for users. At Redgate, we’ve been working closely with Microsoft to make sure the latest version of SQL Source Control supports SSMS 2016 from launch day. SQL Source Control... Read more
