In this tutorial, you learn how to set up SQL Data Sync by creating a sync group that contains both Azure SQL Database and SQL Server instances. The sync group is custom configured and synchronizes on the schedule you set. The tutorial assumes you have at least some prior experience with SQL Database and SQL Read More
How to Do Lookups with Returning Multiple Column Values
This is the first post in a series where we’ll talk about how to use the FILTER function as an alternative to lookup functions including VLOOKUP. Why? Well, as we’ll discover in this series, the FILTER function offers several key benefits. For example, FILTER supports: Multiple return columns Multiple lookup columns Multiple matching row values In this first post, we’ll see Read More
Features Comparison: Azure SQL Database and Azure SQL Managed Instance
APPLIES TO: Azure SQL Database Azure SQL Managed Instance Azure SQL Database and SQL Managed Instance share a common code base with the latest stable version of SQL Server. Most of the standard SQL language, query processing, and database management features are identical. The features that are common between SQL Server and SQL Database or SQL Managed Read More
Upwork vs. Fiverr: Which Freelance Job Site is Best?
We take a deep dive into freelance service platforms, and here we look at key differences between Upwork vs. Fiverr. By Lena Borrelli Remote work is increasingly taking off as technological developments continue to change and shape how we live and, more importantly, how we earn. Freelance job sites have become a new lifeline to both Read More
How to Filter Out Multiple Criteria Using Excel VBA
Questions: I have 8 variables in columns A, 1,2,3,4,5, and A, B, C.My aim is to filter out A, B, C and display only 1-5. I can do this using the following code: But what the code does is filters variables 1 to 5 and display them. I want to do the opposite but yield Read More
Understand What is Retire / Wipe / Delete / Fresh Start / Autopilot Reset in Microsoft Intune
It feels there are a million different reset options in Microsoft’s endpoint manager (aka Intune). Some of the options even provide additional „suboptions“. I would like to explain the different options, their differences, and their main use cases here. If you prefer it short and concise summary can be found at the end. Retire/Delete Let us get Read More