Transactional replication allows you to replicate data from one database to another hosted on either SQL Server or Azure SQL Managed Instance. SQL Managed Instance can be a publisher, distributor, or ...
Community driven content discussing all aspects of software development from DevOps to design patterns. In helping students prepare for this exam, I have identified a number of commonly misunderstood ...
I’ve been studying for the DP-700: Designing and Implementing Microsoft Azure Data Solutions certification, focused on the data engineer role. To make my learning process stronger, I decided to ...
Data often contains observations that do not fit the rest of the dataset. It is best practice to regularly check for outliers, providing useful takeaways about the data. Outliers occur for various ...
After a brief gap since releasing SQL Server Public Preview 6, and having survived through the February 2019 Snowcalypse in Seattle, I’m happy to share that everyone in the SQL Tools team has made it ...
Revokes permissions granted and denied on a database. :::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax ...
Data has become the lifeblood of the enterprise. It’s the foundation for keen insight and effective decisions that lead to business growth. One of our primary design goals for SQL Server 2016 was to ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results