Relationships are everywhere: between people, between organizations, between organizations and people. Think about being an employee of a company, being a member of a project team, or being a subsidiary of another company. Is there a straightforward way to accurately model and manage all these relationships? Can we easily answer the question ‘Who knows... Read more
Have you written an application that issues invoices? Then you’ve probably struggled with PDF generation, for a start! (Headers don’t need to align, do they?) But there is much more to generating invoices than a pretty PDF. What information has to be on an invoice? How long should you keep an invoice? Read more
The process of defining your data warehousing system (DWH) has started. You’ve outlined the relevant dimension tables, which tie to the business requirements. These tables define what we weigh, observe and scale. Now we need to define how we measure. Read more
The bill of materials design pattern is deceptively simple, yet incredibly powerful. This article will introduce an example, familiar to IT professionals, that you may not have thought fits the BOM pattern. It will also introduce concepts to show you how to make your BOM structures more flexible and much easier to manage. Read more
Several years ago I was introduced to UserVoice, the online forum that enables direct contact with users, allowing you to collect their feedback and build the features they vote for. At the time I had a very poor line of communication with users, so when I joined Redgate and started using UserVoice regularly, I... Read more
Over recent months, Redgate’s development teams have been busy updating the tools in the SQL Toolbelt to support the valuable new functionality released with SQL Server 2016. To achieve this, most tools now support the syntax for SQL Server 2016’s key features, letting you do even more with them. Stretch Tables Our flagship tool... Read more
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
