In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.

Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet

by Additional Articles

Redgate

Vendors/3rd-party Products

SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell.

Microsoft Fights Back

by Steve Jones

SQLServerCentral

Microsoft fights back against hackers after a recent vulnerability in a management framework.

Working with NULL Values in an ADF Data Flow?

by diponkar.paul

SQLServerCentral

Azure Data Factory

Learn how to replace NULL values in an ADF data flow.

Dynamic Power BI Slicer Using DAX Logic

by Additional Articles

MSSQLTips.com

Power BI

Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.

Getting your SQL Server Development Data in Three Easy Steps

by Additional Articles

Redgate

Vendors/3rd-party Products

Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.

Exploring Facts About SQL Server Tables: Stairway to Exploring Database Metadata Level 5

by Phil Factor

SQLServerCentral.com

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.