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..
A Consultant's guide to saving money on your Microsoft data platform
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..
Cyber Security Monthly News - June 2020
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 Cumulative..
The Dirty (Baker’s) Dozen of SQL Server Technical Debt
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.
First Steps with Cosmos DB, Building your Own Rocket
In my previous post, I talked about how No-SQL databases are different from relational ones, now I’m going to show you how to get started building your first No-SQL database using Cosmos DB.
Killing Your SQL Server with Kindness
When you discover a poor, uncared for SQL Server instance that has been neglected for years, your immediate response is to get maintenance going and give it some love. Get it back to its former glory and running optimally.
But you need to approach this with caution.
An Ode to the DBA
It has been now quite a few years since I was sitting in school, being pleasantly bored by the works and sonnets of Shakespeare, and failing to grasp the meanings and intricate language he used. Now in hindsight, I realise that I just never understood (or tried to understand) some of the meanings..
Azure Data Studio – Don't Manage SQL Server with a Wooden Racket
How do you manage SQL Server?
Azure Data Studio is the new (ish) open-source, cross-platform tool from Microsoft to manage and interact with your SQL Servers or PostgreSQL instances. If you haven’t used it yet, I recommend you check it out (https://docs.microsoft.com/en-us/sql/azure-data-studio).
Helping you adapt to the new normal: watch our webinar
As the world experiences unprecedented social distancing and lockdown, businesses are having to adapt to change faster than ever. Whilst organisations rush to change ways of working, their supporting IT platforms must be flexible enough to enable them to do so and able to support increased load.
Azure Cosmos DB: To Infinity and Beyond
One of the technologies that surprised me when I heard of it was No-SQL databases.
As a database administrator that really distressed me at first; what is no-SQL? How can a database not be a relational database? Well, it’s been a few years, but finally my eyes opened and I’m ready to embrace No-SQL.