SQL Saturday #520 arrives in Cambridge on Saturday, 10 September, and we’re delighted to be sponsoring the event. This year, 30 speakers including some familiar faces will be coming to the city from all over the world. The conference run by SQLCambs consists of a free day of training for technology professionals, covering a... Read more
There are a number of ways to contact someone these days, right?
We have various phones: mobile and landline, personal and work. We have different addresses – residential, mailing, billing, business, etc. – and likely several email addresses, too. Don’t forget Skype and various messaging apps. Now add in LinkedIn and Facebook –which by the... Read more
When designing your dimensional model, it is worthwhile to watch out for mistakes that commonly occur during the process. Specifically, they can occur in the relationships between tables, both in fact-to-dimension and dimension-to-dimension relationships. In this post, we’re going to take a closer look at five common modeling mistakes and what you can do... Read more
If you’ve ever worked in a team that uses a shared database for development, testing or UAT, you’ll appreciate some of the frustrations in simply ‘getting stuff done’. And you’ll be all too familiar with the reasons why… contentions for resources, overlap between projects, inconsistent environment states, and dependencies on other team members to... Read more
Back in June, I shared the exciting news that SQL Compare 12 and SQL Data Compare 12 had been released to beta. It’s been a couple months and the good news is, both new versions are available as Frequent Updates. What we didn’t explain, though, is why we’re making the changes, and why we’re doing it now.... Read more
On hearing what I do, people tend to ask me the same question: Can you develop a system that predicts football match results? Or Olympic medal outcomes? Personally, I don’t put much faith in predictions. Still, if we had a large amount of historical data and relevant indicators, we could certainly design... Read more
Ever since Redgate was founded, we’ve sponsored user groups and events because we think it’s important communities are able to get together to learn, connect, and develop. This year alone, we’ve already supported 126 leaders, providing sponsorship to help them host meetings for communities all over the world. Wherever they are, those user groups,... Read more
Last week saw the release of DLM Automation – a new improved version of our database automation offering. So what’s changed? DLM Automation combines all the functionality of its predecessors, SQL CI and SQL Release, in one unified tool. This means you now only need to install one product in order to set up... Read more
When we start a data warehousing project, the first thing we do is define the dimensional tables. Dimensional tables are the interesting bits, the framework around which we build our measurements. They come in many shapes and sizes. In this article, we are going to take a closer look at each type of dimensional... Read more
When databases were sized in megabytes rather than petabytes, their design was a well-defined discipline of data analysis and implementation. A progression of modeling steps – from conceptual and logical through relational and/or physical – promised successful deployment. Read more
