+44 (0)20 3051 3595 | info@coeo.com | Client portal login

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.
Find me on:

Recent Posts

Power BI Security in Ten Steps

Are you fearful of migrating to a new data visualisation solution or hosting data in the cloud? The power of Power BI is too much to ignore and offers many security features to ease your concerns.

Dataflows – the Future of Power BI

Ready to create an enterprise Power BI solution with no data warehouse? Read on.

Get DRY with Power BI

Save yourself time working with Power BI.

You Must Upgrade SQL Server to Stay Secure

A whole series of “speculative execution side-channel attacks” were disclosed in the first week of 2018, as detailed in this Microsoft article: https://portal.msrc.microsoft.com/en-US/security-guidance/advisory/ADV180002

Major security events like this highlight the severe risk companies are..

Power BI – 15 Ways to Share Data

Power BI is free of charge to use. Anyone can download the Power BI Desktop application from the Microsoft Store, import and mashup data from various sources and create beautiful visualisations of business metrics.There comes the point, however, when you wish to share this content with your..

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: -

Back to top