Instead of pure lift-and-shift migrations to the cloud, we often encounter lift-shift-tinker migrations. In such a migration, you modify some of the application components to take advantage of cloud services. Often, that’s the database but it could also be your web servers (e.g. replaced by Azure Web App). When you replace SQL Server on-premises with… READ MORE
By reading this post, you will be able to compare and choose the right one service for our database deployments (SQL or NoSQL). Definition SQL: A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. NoSQL: NoSQL is a class of database management systems (DBMS) that do not… READ MORE
Migrating a dotnetcore 2-tier Application to Azure, using Different Architectures and DevOps Best Practices is a very practical hands-on guide to learn about Azure Infrastructure as a Service, Platform as a Service, Containers and DevOps. Interested in learning how to migrate your on-premises workloads to Azure, but don’t know what architecture to choose or how… READ MORE
Join Mustafa Toroman, MVP, Lead System Engineer/Program Architect at Authority Partners, Bosnia and Herzegovina for this short video on How To add Dynamic Data Masking and Transparent Data Encryption in Azure SQL.
Since SQL Server 2012 SP1 you’ve been able to backup and restore SQL Server using Azure Blob storage. This can be useful to have offsite replicated backups or if you need to move data securely between sites, and now with Azure hosted SQL Server (of various stripes) it makes it easy to get data into… READ MORE
Before you can do anything with SharePoint 2019 you have to install SQL Server. You have a couple of options available as both SQL Server 2016 and 2017 can be used. I want to go with SQL Server 2017 (all the latest features right?). So in this post I will be demonstrating how to install… READ MORE
I’m working on a PowerApps project that uses Microsoft SQL as the back end. Recently we have noticed that amendments to the SQL DB such as new fields and field amendments can take around 5 hours to show in a PowerApp as a selectable option in the formula bar and also in Flow as a… READ MORE
Introducing InnoDB Cluster by Charles Bell teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works… READ MORE
Microsoft has a great solution for persisting your local data collected by the IoT Edge. It’s up to you to get the data in and out of your database. But you have a convenient way of storing your precious information into some kind of persistent storage. As seen in my previous blog, it’s not that hard to deploy… READ MORE
Power BI is a big factor, but where does it fit? What do all of these changes mean for your new and existing BI investments? This session will walk through the various changes, and call out the good the bad, and the ugly of these changes.
