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.
This year, Microsoft has been making a significant investment in new ways to support customers with deploying and using its products and services.
Introduction to the problem
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.
So, you're supporting a server. It might be yours directly, it might belong to a customer. Doesn't matter. You've got an urgent issue - an alert, a ticket, an end-user reporting a problem - and you need to get moving. Where do you start? Everyone has a method, and if you haven't developed yours..
Amidst the COVID-19 pandemic, businesses have been forced to implement short-medium term plans to protect not only their ability to transact, but also the health and wellbeing of their customers, partners and employees. Video calls, queueing at shops (and on websites) and home deliveries have..
In June’s news, we see a plethora of security related stories related to Covid-19, including information on staying secure and avoiding recent targeted phishing scams.
Additionally, we look at critical updates for both Windows and SQL Server, and the changes Microsoft has made regarding..
The Baker’s dozen originated from bakers adding the thirteenth loaf to avoid a beating for underselling bread. There will (hopefully?) be no such penalties for SQL Server indiscretions, but try to avoid adding technical debt to undersell your future happiness.