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/  

Read More

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 … “Azure SQL Database Managed Instance ( public preview)”

Read More

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 … “DirectQuery in Analysis Services: Best practices, performance, use cases”

Read More

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 … “Microsoft SQL Operations Studio”

Read More