ASCII Text Dump

• by saga

• SQLServerCentral

• T-SQL

Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with characters whose ASCII values were above 127. Eyeballing the text that I dumped using a […]

Improving Availability Groups

• by Steve Jones

• SQLServerCentral

• High Availability (HA)

Availability Groups are a good way to use High Availability in SQL Server, Today Steve wonders if you have any improvements you would make to the technology.

Azure Blob Storage Data Upload with SSIS

• by Additional Articles

• MSSQLTips.com

• Azure
• Azure BLOB Storage

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
• Security

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.

Security in the Aftermath

• by Steve Jones

• SQLServerCentral

• Security

Once a physical space is breached, likely all electronics are suspect.