The Coeo Blog

Andy Jones

I am a principal consultant at Microsoft Gold Partner Coeo. My passion is helping customers profit from their data using the Azure cloud platform, SQL Server and Power BI. Since 2001 I have been a Consultant, SQL Server DBA, Developer and Business Intelligence professional and am a Microsoft Certified Solutions Expert: Data Management and Analytics and hold the Microsoft Professional Program in Data Science. Presenting at data community events and blogging about data and analytics are also activities I much enjoy. My home is North Wales, where I live with my wife and three children. In addition to family and data, my passion is marathon running.

How Vulnerable is Your Data? Stop Malware Attacks using Azure SQL Database

"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

Ransom Demands

People don't notice great security practice. End-users and Business Managers want new features and better performance, sometimes leaving..

Why Don't You Unit Test SQL Server Code?

"The best time to plant a tree is twenty years ago, the second-best time is now" Chinese Proverb

10 Steps to Enterprise Business Intelligence with Power BI

You have worked with Power BI to produce beautiful visualisations of your data. The Power is its simplicity, but you can encounter the following problems:

Return of the (DBCC) Clones

SQL Server 2014 SP 2 introduced an interesting feature to provide a data free copy of a production database.

Globally Drop Objects

PowerShell provides an extremely efficient method to globally clean up and drop objects within your SQL Server estate based on some pattern matching in the object names. Some of the reasons you may wish to do this are: -

SQL Server 2016 Upgrade Advisor Automation

The SQL Server 2016 Upgrade Advisor is a great graphical user interface for analysing your existing SQL Server database to discover any features or syntax you are using that are not compatible with a 2016 upgrade.

When Two Billion is Not Enough

Introduction

Andy Jones

Recent Posts