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..
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).
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..
Individuals who believe their talents can be developed, as opposed to believing such talents are innate gifts, are known to have a "growth" mindset. Such people tend to achieve more than those with a "fixed" mindset because they spend less time worrying about looking smart, and more time being..
There are many posts out there on installing SQL Server 2019 on Linux and in fact the Microsoft tutorials do a pretty good job of taking you through the installation.
This blog post takes you through my experiences with those tutorials and down some of the rabbit holes that I stumbled into along..
Recently we have helped a number of customers with moving system and user databases from one drive to another. We also regularly receive questions regarding how to do this safely and minimising risks associated. As such, we have produced a step-by-step guide with best practice recommendations..
At Coeo, we have the opportunity to deal with a wide range of problems every day and sometimes they manifest in mysterious ways.
Backup to URL was introduced in SQL Server 2012 SP1 CU2 and allows backups to be taken directly to an Azure Storage Account. This post will expand on the evolving syntax when using Backup to URL and what I would consider to be best practice for Storage Account access.
If you would like a more..
SQL Server 2008 and 2008 left Extended Support on 9th July 2019. In the latest episode of the Coeo Conversations Podcast Sales and Marketing Director James talks about the issue and explores the options available to businesses.
The Database Administrator (DBA) is often the organisation’s main source of technical database operational knowledge and they are difficult to obtain and retain.