In the modern data market we're bombarded by advice on how to set up our tech to last the test of time and be perfect. While that is admirable and very important for reports used by a wide audience it is important to keep in mind that Power BI is also useful for small-scale personal use and to..
How to sit your first Microsoft exam (from home!)
Due to the on-going COVID-19 pandemic, the way we spend our everyday lives has changed drastically over the last few months. For many of us, sitting an exam is likely to be towards the bottom of the agenda during these periods of social lockdown and isolation. One benefit of this, however, is that..
Is your transaction as lonely as you think? A cheat sheet for isolation levels in SQL Server
This post aims to give you a brief introduction into what isolation levels are and how they work within SQL Server. In short, they are a measure for controlling concurrency on the server.
Power BI Tips & Tricks: Using PowerPoint to create and standardise your Power BI reports
In this post we’ll be walking through a quick and easy way to standardise and simplify your Power BI reports using backgrounds. Here’s an example of what we will be building today:
Managing SQL Server Compatibility Levels using Query Store
Managing SQL Server production databases can become a nerve-wracking situation for administrators, especially when your organisation or business can have hundreds of databases that are vital to its existence and commerce.
How to avoid a rabbit hole while troubleshooting SQL Server performance
Performance analysis can be a tricky landscape at the best of times and looking at the performance of your SQL Server is no different. An initial glance at your recent high CPU usage can often spiral into a lengthy investigation, deviating far from the initial investigation.
In this blog I aim to..
Availability groups in Azure – when always on is sometimes off
You picked the cloud because of the promises around VM availability. You deployed your data platform using availability groups to achieve the highest availability possible, but now you’re seeing outages – what’s going wrong?
Podcast: Power BI Adoption and Data Governance (with Nick Anderton, M&G)
In the latest episode of the Coeo Conversations Podcast, we chat to M&G's Head of Data Services - Nick Anderton - about their approach to data governance, the challenges of data ownership in finance companies and their Power BI journey so far.
Please wait your turn: A basic Introduction to Latches in SQL Server
Following on from my recent blog post on locking, a level deeper in the concurrency chain leads us to latches. A lot of people will have heard of them or will have seen the related waits within SQL, for example in the sys.dm_os_wait_stats DMV, but, I would wager, not many people could give me a..
Who is afraid of this lovely creature called Gremlin?
Travelling in time is something humans have dreamed of and written many novels and movies about, and today I felt kind of like that - from A Space Odyssey to another 80's classic, Gremlins 😊.