See what our experts share on insights on all data things
Learn how SQL Server performance tune-up revolutionised ReviMedia’s data systems.
The Client ReviMedia is a broker for online advertising. Their system connects brands who want to buy advertising with companies selling advertising space. ReviMedia then also creates advertisements for the buyer. This buying and...
Manufacturers, It’s Time to Modernize Your SQL Server Databases
Manufacturers need to realize that can become MORE efficient when you modernize your data platform and prepare it to scale. Here’s our advice…
Think Your SQL Backups Have You Covered? Think Again—It’s Only Part of a Good Disaster Recovery Strategy
Back everything up, back it up again then back it up again for good measure—that’s what most IT professionals have made their rallying cry. Yet, in my opinion, backups can be useless in a lot of disaster recovery situations without the right recovery strategy. ...
How Getting Ready to Migrate Your SQL Servers to the Cloud is like Prepping for a Pandemic
The COVID-19 pandemic sparked a sudden urgency for organizations who had been considering data modernization.
Facing Performance Issues? Here are the Top Five Culprits
Feel frustrated by performance? SQL performance refers to the ability of your database to quickly and efficiently perform queries. Performance tuning isn’t just one thing, but a series of practices used to improve performance. But to know which...
Starting from a database emergency: how you can get your server strategy back on track.
Every second counts, but the problems can become so critical and anxiety so overwhelming that getting to a proactive state feels impossible.
Meet Chris Taylor, Head of the UK Data Masterminds Office
Here at Data Masterminds we are constantly striving to improve how we can efficiently deliver our data platform expertise to companies around the world. Part of this focus on efficiency is to ensure we are available to our clients on their terms. To accomplish this,...
RPO & RTO – What do they mean to my business?
RTO and RPO are two little acronyms that make a big difference in your business. Here’s what they mean, and why you need to consider them.
Facing a Full TempDB? Here’s What Happened – and How to Prevent It From Happening Again
Ahh, TempDB space issues. We’ve all come across the following message at one time or another: Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. CREATE the necessary space by...
You Asked: We Answered!
Struggling to find the answers you need to move forward? Feeling stuck? Through our combined years of experience in the Microsoft Data Platform, we’ve been asked every question in the book – twice. Over the past month, our five-part blog series answered the most...
You Asked: Is Our Data/Database Secure?
Welcome to the final post in our five-part series about the common questions we answer for our clients. Security is often at the top of people’s minds—or, it should be—yet there is a weakness common to many systems. Not only...
You Asked: Will Our Application/Database Scale?
Welcome to the fourth instalment of our series tackling the most common questions we hear from clients. As businesses prepare for their future, it’s important to be able to gauge whether their system is scalable. Here we discuss how to...
Data Masterminds is expanding again!
Here at Data Masterminds we are constantly striving to improve how efficiently we can deliver our data platform expertise to companies around the world. Part of this focus on efficiency involves ensuring we are available to our clients on their...
You Asked: Is the DBA dead?
Welcome to part three of our series tackling the questions we hear most from our clients. Today we discuss the role of the DBA, and whether businesses have truly evolved to function without them. Question #3: Is...
You Asked: Will the Cloud Save Me Money?
Welcome to part two of our series on the most common questions we receive from clients – be sure to check out part one if you haven’t already. Question #2: Will the Cloud Save Me Money? The cloud is no...
You Asked: Why Do I Need a New Version of SQL Server?
All companies want to future-proof their data strategy, and that’s why they come to us. Despite the diverse range of industries that our clients operate in, most have the same questions because they’re encountering similar...
How to Move Thousands of Database Files with Minimal Downtime
Introduction Running out of disk space is an inconvenient symptom of a business doing well. Database file migration is rarely as easy as we want it to be – the downtimes alone can lead many people to put it...
Why Data Masterminds loves dbatools!
We have accumulated quite a toolbox when it comes to DBA resources. One of the most valuable assets we have come across is the free to use dbatools project.
Full disks and databases
I have recently had a number of discussions about dealing with hard drives or databases themselves filling up on SQL Servers.
Database objects can DIE in SQL 2016 without using the KILL command
When developing database code for SQL Server one issue that has got in the way of smooth deployment has been a simple check for the existence of an object before creation.