We know how tough the recruitment marketing for database professionals is right now. If you're concerned about downtime and want peace of mind when it comes to mission-critical data assets, our Dedicated Support team can help.
Podcast: Data Platform Modernisation (with Simon Osborne)
Coeo's Simon Osborne (Cloud, Data & AI Architect) explores the benefits of modern data platforms, how organisations can embark on their modernisation journey and the future of SQL Server as a Microsoft product.
Cyber Security Monthly News - October 2020
Many SQL Server and Windows Updates were introduced in September and early October, including the latest Cumulative Update for SQL Server 2019, which addresses the snapshot issues introduced by CU7.
Stay C.A.L.M. - Analyzing Space Alerts
Hello again. We've talked about a process to help you deal with alerts - so now let's start looking at some specifics, shall we? I'm going to lay these out in no particular order - this one is inspired by a colleague of mine, who asked me a great question: "Why do we care about low disk space?" So,..
Preventing Brute Force Attacks in SQL Server
SQL Server provides two different forms of authenticating the users that connect to the database server: Windows Authentication, which is the default and preferred method, and SQL Server Authentication, which needs to be explicitly enabled.
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.
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..
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..
A Basic Overview of Locks in SQL Server
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..