While it's been a relatively quiet month in terms of security news, a number of Windows updates have been released, and we have a cumulative update for SQL Server 2014 and 2017. Full details can be found below:
While performing an in-place SQL Server upgrade for a customer, I came across the KB2919355 issue. This article will show you how to resolve this this problem and point out why this can be misleading.
This month has all been about the General Data Protection (GDPR) deadline which came into effect on the 25th May and is why you are likely being bombarded by every company you ever gave a shred of personal information to asking you to review their terms and conditions.
If you’re running SQL Server 2016, you may want to install SQL Server Service Pack 1, CU8. I came across an issue recently that effectively caused the transaction log backups to hang. Through our proactive monitoring, we were alerted to the fact that a log backup had not been taken in 4 hours...
Managed Instance is now in public preview and with it is a purchasing option we haven't yet seen with traditional Azure SQL Database offerings, known as the vCore purchasing model. Earlier this month, Microsoft announced this model is now available in preview for Single Database and Elastic..
It’s been a while since my last blog post, but the beauty of time marching forwards is that lovely new features get released in Azure for me to write about.
Something I always remember as a kid is that when we got a cool new bit of technology, I'd use it for a while and then my next port of..
During February, we’ve seen the tech industry warn ministers not to drop EU data laws when Brexit eventually kicks in. We’ve seen the biggest ever DDoS attack, and we’ve seen a robot autonomously open a door while giving us flash backs to one of the more recent Black Mirror episodes (for those..
SQL Bits is a highlight of the year for European data professionals and this February's conference schedule is shaping up to be an exciting one.
Looking back over 2017, we can see it has been another year highlighting the importance of good cyber security and procedure with the cost of ransomware attacks estimated to cost $5 Billion alone.One particularly critical issue is the recently discovered Meltdown and Spectre bugs affecting CPUs...
Update February 2020: Azure SQL Data Warehouse is now part of the Azure Synapse analytics service.
Recently I was asked what the difference was between Azure SQL Database (SQLDB) and Azure SQL Data Warehouse (SQLDW). If you connect to them both via Management Studio there doesn't seem to be much..