--- title: The Coeo Blog | David Morrison description: As a senior consultant, I’m involved in both the BI and data platform side of SQL Server. I’ve worked with SQL Server for some 15 years in one way or another and have been doing BI for about 9 years. Outside work I can often be found either playing board / video games or rolling around in black pyjamas training in martial arts! --- [![](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 ## David Morrison ![](https://blog.coeo.com/hubfs/Profile%20photos/DavidCircle.jpg) As a senior consultant, I’m involved in both the BI and data platform side of SQL Server. I’ve worked with SQL Server for some 15 years in one way or another and have been doing BI for about 9 years. Outside work I can often be found either playing board / video games or rolling around in black pyjamas training in martial arts! Find me on: ### Recent Posts ## [Using "With (nolock)"? Read this](https://blog.coeo.com/using-with-nolock-read-this) Anyone that's worked with SQL for any length of time will undoubtedly have seen and heard the following [![David Morrison](https://blog.coeo.com/hubfs/Profile%20photos/DavidCircle.jpg)](https://blog.coeo.com/using-with-nolock-read-this) [David Morrison](https://blog.coeo.com/author/david-morrison) | March 12 , 2018 ## [PowerApps Blog Series - Recursion Using a Numbers Table](https://blog.coeo.com/powerapps-blog-series-recursion-using-a-numbers-table) This post is the first in a series I'll be doing, showing you how to achieve certain things in PowerApps that aren't immediately obvious but are very useful to enable you to create powerful, feature rich applications. [![David Morrison](https://blog.coeo.com/hubfs/Profile%20photos/DavidCircle.jpg)](https://blog.coeo.com/powerapps-blog-series-recursion-using-a-numbers-table) [David Morrison](https://blog.coeo.com/author/david-morrison) | December 20 , 2017 ## [PowerApps – 500 Record Limit, Delegation and How to Work Around it](https://blog.coeo.com/davidmorrison/powerapps-500-record-limit-delegation-and-how-to-work-around-it) Update - April 2018: PowerApps now has an experimental feature that can be turned on to increase the 500 row limit. I've not tested it with large sets but its a nice step forward. To increase the limit, in the app developer studio (web or desktop) go to File->App Settings->Experimental Features and.. [![David Morrison](https://blog.coeo.com/hubfs/Profile%20photos/DavidCircle.jpg)](https://blog.coeo.com/davidmorrison/powerapps-500-record-limit-delegation-and-how-to-work-around-it) [David Morrison](https://blog.coeo.com/author/david-morrison) | June 21 , 2017 ### 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