When should you use Storage Pools for your Windows VM in Azure?
If you are creating a SQL Sever failover cluster instance (FCI) in Azure, you can use Storage Spaces Direct (S2D) and configure Storage Pools to set-up the Cluster Storage.
The other main reason for using Storage Pools in Azure is ..
We have all heard of locks and can probably even name a few; shared or exclusive locks, for example. We notice them more when something goes wrong and we run into blocking or other performance problems, but what are locks and how do they work in SQL Server?
In this blog, I aim to give a basic..
In July's news, Amazon confirms that its cloud computing platform, AWS, was subject to largest distributed denial of service (DDoS) attack in recorded history back in February. The 2.3Tbps attack, which took place on 17th February, surpassed the previous record of 1.35Tbps sustained by GitHub in..
Today I want to tell you about an issue we ran into while working on one of our customers and, while it’s easy to understand when explained, it might be tricky to get done when you don’t look at the whole picture.
As a follow up to my recent post, we’ll be discussing Microsoft’s DP-201 exam (“Designing an Azure Data Solution”); the second exam and final step required in gaining the Azure Data Engineer Associate certification.
It’s been a while since I last wrote about my favourite piece of tech, which is not the latest neither sometimes the greatest, but we’ve been together for over a decade now and I still love it. That is the SQL Server engine.
At Coeo, we are actively encouraged to take exams and broaden our understanding in new areas. Not only do these exams help focus our learning, they help to build a breadth of qualifications throughout the company.
In this post, we’ll be discussing Microsoft’s DP-200 exam; the first of two exams..
Recently I was working with a client to build an Azure analytics solution, replacing an existing on-premises SQL Server implementation. The scope of the project was to transform and model data from XML files and present the output through Power BI.
Here we are again, I hope you’re already feeling like an astronaut or Carl Sagan exploring the Cosmos.
In my previous posts, we have seen basic concepts of No-SQL databases and how to start with Azure Cosmos DB, if you haven’t read those posts, I’d recommend you take a minute and check them.
We recently worked with a client who wanted to report on the number of sales per region with the ability to drill down to a specific county and town. Out of this came a requirement for a Power BI report with stacked bar charts with concatenated labels.
The data consisted..
