A Summit Rebirth in 2022

• by Steve Jones

• SQLServerCentral

• PASS Summit

An announcement for next year's Summit.

Azure Data Studio vs SSMS - Who is the winner?

• by Daniel Calbimonte

• SQLServerCentral

• Azure Data Studio
• DBA Tools
• Management Studio (SSMS)

Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]

Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6

• by Phil Factor

• SQLServerCentral.com

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.

Handling an unknown number of parameters in SQL Server

• by Additional Articles

• MSSQLTips.com

• T-SQL

In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more.

Managing Database Documentation during Flyway-based Development

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Learn how to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway.

An Introduction to Azure Databricks

• by Sucharita Das

• SQLServerCentral

Learn a bit about Azure Databricks in this article.

Perform API Operations Using Stored Procedures in CData SSIS Components

• by JerodJ

• SQLServerCentral

APIs require up-to-date and strong documentation, increased security levels, comprehensive testing, routine versioning, and high-reliability to be appropriately utilized. With the CData SSIS Data Flow components you can import and export data from various data sources. However, in some cases the type of operation you need does not fit the SSIS Source or the SSIS Destination model. The […]

SQL Server vNext

• by Steve Jones

• SQLServerCentral

We now know when the next version of SQL Server is coming. At Ignite last week, Microsoft announced SQL Server 2022, which comes nearly 3 years after the last version, SQL Server 2019. Apparently, the pandemic's effects include delays in product development as it's been nearly three years since SQL Server 2019. The new version […]

State of Database Monitoring Report 3

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Database professionals are spending 1/3 of their time on security tasks each day and say it’s their biggest professional challenge this year. Learn how 2500+ database professionals are reacting to these unprecedented demands in our third database monitoring insights report.

Text Mining and Sentiment Analysis: Data Visualization in Tableau

• by Additional Articles

• SimpleTalk

• BI

Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data.