by The CRM Chap | Nov 15, 2020 | Dynamics 365, Dynamics CRM, Microsoft Dataverse, Power Platform
More changes are afoot in the Power Platform! And this time around, not even the commonest terms within the Common Data Service are safe from being replaced with something entirely different...
by The CRM Chap | Sep 6, 2020 | Databases, Dynamics 365, Microsoft Azure, Microsoft Dataverse, Power Platform, PowerShell, Sales, Security, Service, SQL Server, Transact-SQL (T-SQL)
Today, we are looking at the final topic for the MB-400 exam – the Data Export Service - a convenient tool to use when performing simplistic integrations involving Dynamics 365 Online or the Common Data Service. What’s more, it’s dead easy to set up too...
by The CRM Chap | Jul 12, 2020 | SQL Server, Transact-SQL (T-SQL), Visual Studio
Having never used the feature before, I recently discovered the benefits of the Schema Comparison tool within SQL Server Data Tools. By using this, it allowed me to resolve a baffling issue involving a database project and a computed column field...
by The CRM Chap | Oct 6, 2019 | Analytics, Databases, DevOps, Microsoft Azure, SQL Server
One of the best things about Azure Data Factory is its ability to incorporate continuous integration and automated deployments quickly alongside your solution. However, if you’re working with SQL Server data sources and are using square brackets to interact with tables, then you may be in for a bumpy ride…
by The CRM Chap | Sep 15, 2019 | Databases, Microsoft Azure, SQL Server, Transact-SQL (T-SQL)
I’ve worked with SQL Server for several years now, and I am continually amazed at its capabilities, Recently, my work in this area has focused on the products change tracking feature, a nifty tool that can assist you in monitoring how your data evolves.
by The CRM Chap | Jul 14, 2019 | Analytics, Databases, Microsoft Azure, SQL Server, Transact-SQL (T-SQL)
When you are amid a pesky IT issue, it can be difficult determining whether the problem is down to a bug/system fault or human error. Like this recent example involving Azure Data Factory illustrates, it is generally best to assume the latter, to avoid any prolonged difficulty.
by The CRM Chap | Jun 9, 2019 | Databases, Identity, Microsoft Azure, SQL Server, Transact-SQL (T-SQL)
Azure SQL Server has long supported the ability to use Azure Active Directory user accounts to access and work with databases. What you may not know is that it is also possible to add users via membership of a security group, a feature which, I believe, is incredibly useful for managing large-scale deployments.
by The CRM Chap | Sep 16, 2018 | Databases, Microsoft Azure, SQL Server, Transact-SQL (T-SQL)
Is it just me or is British Summer Time (BST) AKA Daylight Saving Time (DST) an utterly pointless endeavour these days? Admittedly, on its introduction in 1916, it fulfilled a sensible objective - to provide more daylight hours during the summer. For agricultural, construction or other services that are reliant on sufficient light to carry [...]
by The CRM Chap | Sep 9, 2018 | Databases, Microsoft Azure, SQL Server, Transact-SQL (T-SQL)
When it comes to handling large datasets in a formal, structured and highly scalable manner, nothing beats SQL Server. Having worked with the product for almost six years, I always look forward to the opportunity of putting together some SQL queries or to build out a new database. I think of it as a nice [...]
by The CRM Chap | Mar 4, 2018 | GDPR, SQL Server
This week's blog post is sponsored by ActiveCrypt Software. Encryption appears to be a topic of near constant discussion at the moment, spearheaded primarily by the impending deadline of the General Data Protection Regulations (GDPR). These are, in essence, a new set of data protection rules that will apply to all organisations operating within the [...]
Recent Comments