SQL DBA Tools

Dear All,

Take a look at and share with customers/friends who need scripts/migration plans etc….. dbatools is a free PowerShell module with over 300 SQL Server administration, best practice and migration commands included. https://dbatools.io/ ,https://dbatools.io/functions/ and https://dbatools.io/introducing-dbachecks/ ( with PowerBI dashboard )

command index

 

Also refer the some good blog found https://www.sqlskills.com/

 

Azure SQL Database Managed Instance ( public preview)

Managed Instance offers full engine compatibility with existing SQL Server deployments including capabilities like

SQLAgent, DBMail, and Change Data Capture, to name a few, and built-on the highly productive SQL Database service

It is designed to enable database lift-and-shift to a fully-managed service, without re-designing the application.  SQL Database Managed Instance provides the broadest SQL Server engine compatibility and native virtual network (VNET) support so you can migrate your SQL Server databases to SQL Database without changing your apps

https://azure.microsoft.com/en-us/blog/migrate-your-databases-to-a-fully-managed-service-with-azure-sql-database-managed-instance/

DirectQuery in Analysis Services: Best practices, performance, use cases

if you have large data set which cannot loaded to PowerBI model then available options are DirectQuery or Live connection, the best way is to define your data model in the data source and connect to PowerBI,

Microsoft has given Analysis Service both on-prem as well as Azure to get the same experience , Tabular model becoming a more popular and the same technology is being used PowerBI too ( both using same in-memory engine )

for more details on DirectQuery in AS refer below

 

 

 

Microsoft SQL Operations Studio

Microsoft SQL Operations Studio is described as a cross-platform, lightweight tool for modern database development and operations. Along with SQL Server, it will be used to work with other Microsoft data offerings like Azure SQL Database and Azure SQL Data Warehouse.

it’s a combination of SSMS + SSDT tools with many new features. please try out and get the experience of cross platform , code snippets (in the T-SQL language) and dashboards to monitor performance of DBs.

download link https://docs.microsoft.com/en-us/sql/sql-operations-studio/download

more details

https://docs.microsoft.com/en-us/sql/sql-operations-studio/what-is

https://www.youtube.com/watch?v=s5DopE7ktwo