--- title: The Coeo Blog | Andy Jones (3) description: "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. \n\nSince 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.\n\nMy home is North Wales, where I live with my wife and three children. In addition to family and data, my passion is marathon running. (3)" --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://www.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # The Coeo Blog ## Andy Jones ![](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg) 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 ## [How Vulnerable is Your Data? Stop Malware Attacks using Azure SQL Database](https://blog.coeo.com/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](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.. [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/how-vulnerable-is-your-data-stop-malware-attacks-using-azure-sql-database) [Andy Jones](https://blog.coeo.com/author/andy-jones) | November 09 , 2017 ## [Why Don't You Unit Test SQL Server Code?](https://blog.coeo.com/why-dont-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 [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/why-dont-you-unit-test-sql-server-code) [Andy Jones](https://blog.coeo.com/author/andy-jones) | June 20 , 2017 ## [10 Steps to Enterprise Business Intelligence with Power BI](https://blog.coeo.com/andrewjones/2017/04/10/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: [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/andrewjones/2017/04/10/10-steps-to-enterprise-business-intelligence-with-power-bi) [Andy Jones](https://blog.coeo.com/author/andy-jones) | April 10 , 2017 ## [Return of the (DBCC) Clones](https://blog.coeo.com/andrewjones/2016/12/30/return-of-the-dbcc-clones-2) SQL Server 2014 SP 2 introduced an interesting feature to provide a data free copy of a production database. [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/andrewjones/2016/12/30/return-of-the-dbcc-clones-2) [Andy Jones](https://blog.coeo.com/author/andy-jones) | December 30 , 2016 ## [Globally Drop Objects](https://blog.coeo.com/andrewjones/2016/09/01/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: - [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/andrewjones/2016/09/01/globally-drop-objects) [Andy Jones](https://blog.coeo.com/author/andy-jones) | September 01 , 2016 ## [SQL Server 2016 Upgrade Advisor Automation](https://blog.coeo.com/andrewjones/2016/08/26/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. [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/andrewjones/2016/08/26/sql-server-2016-upgrade-advisor-automation) [Andy Jones](https://blog.coeo.com/author/andy-jones) | August 26 , 2016 ## [When Two Billion is Not Enough](https://blog.coeo.com/andrewjones/2016/05/03/when-two-billion-is-not-enough) **Introduction** [![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)](https://blog.coeo.com/andrewjones/2016/05/03/when-two-billion-is-not-enough) [Andy Jones](https://blog.coeo.com/author/andy-jones) | May 03 , 2016 ### Recent posts ### Categories - [SQL Server (118)](https://blog.coeo.com/topic/sql-server) - [Azure (58)](https://blog.coeo.com/topic/azure) - [Microsoft (49)](https://blog.coeo.com/topic/microsoft) - [Dedicated Support (47)](https://blog.coeo.com/topic/dedicated-support) - [Coeo News (43)](https://blog.coeo.com/topic/coeo-news) - [Professional Development (34)](https://blog.coeo.com/topic/professional-development) - [Industry News (27)](https://blog.coeo.com/topic/industry-news) - [cyber security (27)](https://blog.coeo.com/topic/cyber-security) - [power bi (25)](https://blog.coeo.com/topic/power-bi) - [Opinion (21)](https://blog.coeo.com/topic/opinion) - [Cloud (17)](https://blog.coeo.com/topic/cloud) - [Business Intelligence (16)](https://blog.coeo.com/topic/business-intelligence) - [analytics (15)](https://blog.coeo.com/topic/analytics) - [Security (14)](https://blog.coeo.com/topic/security) - [career (14)](https://blog.coeo.com/topic/career) - [SQL Server updates (13)](https://blog.coeo.com/topic/sql-server-updates) - [windows Updates (11)](https://blog.coeo.com/topic/windows-updates) - [Azure Databricks (10)](https://blog.coeo.com/topic/azure-databricks) - [data platform (10)](https://blog.coeo.com/topic/data-platform) - [Clustering (9)](https://blog.coeo.com/topic/clustering) - [Finance (9)](https://blog.coeo.com/topic/finance-news) - [podcast (9)](https://blog.coeo.com/topic/podcast) - [azure sql database (8)](https://blog.coeo.com/topic/azure-sql-database) - [data (8)](https://blog.coeo.com/topic/data) - [Data Science (7)](https://blog.coeo.com/topic/data-science) ### Popular posts ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top