by The CRM Chap | Nov 29, 2020 | Analytics, Databases, Microsoft Azure
Getting your head around Azure Synapse Analytics can be challenging, even for the most seasoned SQL Server professional. With that in mind, this blog post will jump into the two concepts that you need to understand - table distribution and index types.
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 | Feb 9, 2020 | Databases, Identity, Microsoft Azure, SQL Server
If developers cannot deploy their code locally, then there’s a significant problem here that needs addressing. That’s why, in the context of SQL Server database development, the use of a publish profile becomes almost essential, by allowing you to ignore problematic components, such as Active Directory scoped user credentials.
by The CRM Chap | Nov 3, 2019 | Analytics, Compute, Databases, DevOps, Identity, Integration, Microsoft Azure, PowerShell, Security, Web
A few weeks ago, I did a post on the process involved when migrating Microsoft Azure Cloud Solutions Provider (CSP) subscriptions across tenants. Having done some actual work relating to this since then (shock horror!), I thought I'd follow up with a new post, sharing some additional thoughts and lessons learned.
by The CRM Chap | Oct 13, 2019 | Databases, Microsoft Azure
Microsoft Azure can throw up all sorts of different error messages when creating and updating resources. Typically, it will be straightforward to resolve these, with the exception of one I recently had to deal with involving Azure SQL Server failover groups…
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 | Aug 25, 2019 | Databases, DevOps, Microsoft Azure, SQL Server
Obscure error messages can be the bane of an IT professionals life, often hampering or even preventing outright any successful resolution of issues. An example of this happened to me recently, during what appeared to be a run-of-the-mill Azure SQL automated deployment.
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 23, 2019 | Databases, DevOps, Identity, Microsoft Azure
We saw a few weeks ago how to utilise Azure Active Directory (AAD) Security Groups to manage Azure SQL database access at scale. When using this feature, you must ensure database changes are deployed out using an AAD administrator account or similar, a task which may be difficult to achieve in an Azure DevOps Pipeline.
Recent Comments