Since its announcement 8 years ago, Azure SQL Database (DB) has been the go-to Platform-as-a-Service (PaaS) offering for SQL Server workloads in Microsoft Azure. During that time, SQL DB has matured to the point where the chasm that once existed with the boxed product we know and love, has..
This is a quick start guide to PowerShell and by the end of reading it, you should be able to be write your own scripts and explore the language confidently.
Since becoming a Mum I’ve found working life hard. Really hard. Don’t get me wrong, I expected disruption and compromise but what I didn’t expect was the overwhelming feeling of guilt. Guilt I impose upon myself, I’m sure, but it’s constant. I'm pretty sure that the guilt that comes along with..
Licensing is confusing at the best of times, but even more so when the product is constantly in flux, improving and evolving. Coeo has recently been delivering more and more training on Power BI and common questions we get from delegates revolve around licensing and deployment options and..
The second CU for SQL Server 2017 was released on November 28th which contains a variety of fixes for both Windows and Linux platforms. Since January 2016, SQL Server CU's are certified to the same levels as Service Packs and so Microsoft recommend ongoing, proactive installation of CUs as they..
In a climate where data breaches are all too frequent, and more and more data lives in the cloud, the challenge of protecting your data can seem daunting. Coeo recently took part in a webinar with our partner Redgate Software, looking at the myths around compliance, database DevOps and the..
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 difference, but the real answer is 'a lot'.
Following one of my earlier blog posts about Always Encrypted, I thought I'd stick with the security theme for my latest one. With the General Data Protection Regulation (GDPR) on the horizon, encrypting connections is one of the most common discussion points that comes up during customer..
"We are going to see 2 or 3 more of these seismic events in the next 12 Months" RunAsRadio, episode 546 http://runasradio.com/Shows/Show/546
People don't notice great security practice. End-users and Business Managers want new features and better performance, sometimes leaving..
In my previous post Getting Started with SSIS Scale Out I discussed the use cases for SSIS Scale Out and how to install and configure it. In this post I'll look at how to execute packages in Scale Out, depending on your type of workload and security considerations.