10 steps you can take to be compliant worldwide – free whitepaper

• by Additional Articles

• Redgate

• Data Privacy and Protection

Learn how data protection legislation is changing around the world and the 10 steps database teams can take to ensure compliance and defend against data breaches.

Reporting Services Basics: Understanding Data Sources and Datasets

• by Additional Articles

• SimpleTalk

• BI

Data sources and datasets are critical components of an SSRS report, but many people new to SSRS struggle to understand them. In this article, Kathi Kellenberger shows you how to create these components and explains when they should be shared vs. embedded.

Do You Have the Gifts to Be a DBA?

• by Louis-Davidson-(@drsql)

• SQLServerCentral

• Database Weekly

I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. A familiar tale he tells is about when he wrote the song Yesterday. He woke up with the tune […]

Azure DWH part 20: Create External and Internal tables As Select

• by Daniel Calbimonte

• SQLServerCentral.com

• CTAS

CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.

Dig Out the Root Cause

• by Steve Jones

• SQLServerCentral.com

• Editorial

Finding the basis for a problem is always the best solution.

4 Ways to Move Data Into a Reporting Server

• by Additional Articles

• Brent Ozar Unlimited Blog

• Reporting

You’ve decided that you need to offload reports to a different SQL Server, and you’re willing to pay the costs. Here are the most common ways to move the data from production to a reporting server, arranged roughly from easiest-to-implement to hardest.

Loading data into SQL Data Warehouse

• by Additional Articles

• Redgate

• SQL Data Warehouse

In this step-by-step guide, we’ll be walking through the process of moving data from an on-premises SQL Server to Azure SQL Data Warehouse using the Copy Data feature in Azure Data Factory. The use case we’ll focus on is the first-time loading of data.

A DBA's Look at the Data Catalog

• by Steve Hall

• SQLServerCentral

• data catalogs
• Redgate Software

A data catalog is a way of classifying and adding metadata about the information in your database for compliance purposes. Take a look at how one DBA is using Redgate's Data Catalog.

Learning to Stop Being a Hero

• by Steve Jones

• SQLServerCentral

• Career

There is a hero complex for many in IT. Steve provides some advice in how we should look at our workload and our employer's expectations when we consider a new job.

Data privacy: don’t look forward, look back

• by Additional Articles

• Redgate

• Data Privacy and Protection

What does Amazon’s Alexa have to do with a wiretapping law from the 1960s? With all the talk about new data privacy legislation, we don’t stop to think about existing laws. Legislation like the GDPR kick-started the way the world views data privacy, and this blog post explores how existing laws are being used in new ways around the globe to enforce similar protection.