Do I Need to Learn Linux and R and Python?

The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.

How to deploy a database plus static data using SQL Compare and SQL Data Compare

This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.

It’s not you, it’s me (I/O troubleshooting)

Monica Rathburn talks about a few of the more common elements she always checks for when troubleshooting I/O problems.

Audio Attacks

We will start to deal with more and more types of data. Steve Jones worries about the possibility of hacking.

Getting Started with Azure SQL Data Warehouse - Part 4

Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.

Training: Zero to BIML

A four-day course aimed at BI developers who want to use Business Intelligence Markup Language (BIML) to generate SQL Server Integration Services packages.

Byte Me: Taking it to the top

Masking your on-premise database with SQL Data Mask

In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They're pleased to say this version of the prototype is now available - here are the details.

Naming Conventions for the Cloud

Today Steve Jones looks at how you might track the various items you use in the cloud.

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.