Azure Data Studio (ADT) is tool for managing SQL Server databases on-prem and Azure SQL databases. There are multiple reasons to use Azure Data Studio. Seems like Microsoft did not want to rewrite its nice and powerful tool SMSS, so they decided to develop new one from scratch with focus on DevOps style of work. After spending some time with it i came up with 6 reasons why use Azure Data Studio.
Continue reading…TUTORIALS
Tutorials, how to
Move Registered Servers from SSMS into Azure Data Studio
Azure Data Studio is new cool cross-platform tool. It has several nice features like: connection to different type of databases, run different type of code, integration with version control, create notebooks which can be type of documentation with built in code. But before you start work with this nice tool you probably want to move registered servers from SSMS into Azure Data Studio.
Continue reading…
How to set up SSIS Scale-out 2019 (part1)
Have you ever wondered how to increase performance and availability of SSIS? To achieve it in terms of SQL SSIS Scale-out 2019 you can implement scale-out setup, which allows to distribute workload between several servers and make sure that at least one set of services is always available to execute your workload. In this tutorial you will understand why you should have SSIS Scale-out on clustered SQL environment.
Continue reading…