In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS
The post Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services appeared first on SQLServerCentral.

How Dry Run scripts work, and how they can be used to deliver a single-script release artifact to Staging, verify placeholder substitutions in SQL migration scripts, and simply team code reviews.
The post Dry Runs for Database Migrations using Flyway Teams appeared first on SQLServerCentral.

Learn how you can get better charting in Azure Data Studio with SandDance.
The post Azure Data Studio - A SandDance demo appeared first on SQLServerCentral.

SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.
The post Using SQL Server sequence objects appeared first on SQLServerCentral.

Google Data Studio helps you create comprehensive reports and data visualizations. When combined with CData Connect Cloud, you get instant, cloud-to-cloud access to data from supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. CData Connect Cloud provides a live cloud-to-cloud interface for all your data, making it easy to build reports from […]
The post Access All Your Data in Google Data Studio with CData Connect Cloud  appeared first on SQLServerCentral.

SQL Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works.
The post Top Query Search in SQL Monitor appeared first on SQLServerCentral.

Learn about the changes to the STRING_SPLIT function in Azure SQL Database that allows you to specify ordinal position of the output.
The post Trusting STRING_SPLIT() order in Azure SQL Database appeared first on SQLServerCentral.

Introduction In SQL Server 2016, Microsoft introduced a new feature called dynamic data masking, which allows you to mask the values of certain columns and keep that data hidden from certain users, without having to modify your applications. Let's take a look at how SQL Server does data masking, and compare it to the way Gallium Data […]
The post SQL Server Data Masking: a comparison with Gallium Data appeared first on SQLServerCentral.