Politics makes for bad databases - plus calculate British holidays

• by Pete Revell

• SQLServerCentral

• Date Calculations
• T-SQL

In this piece, learn about changes in UK holidays and get a script to calculate them.

Ransomware and DevOps

• by Steve Jones

• SQLServerCentral

• DevOps and Continuous Delivery (CI/CD)
• Security

Ransomware is becoming a bigger and bigger problem. Steve has some thoughts on how you should think about security in your database environment.

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.