Additional Articles

Introduction to Running SQL Server 2019 on Kubernetes

by Additional Articles

Database Journal

SQL Server 2019

The release of SQL Server 2019 further extends the ability to host SQL Server instances on Linux, including running Docker-based SQL Server images on Kubernetes clusters. This latest release further extends the multi-platform capabilities by allowing for Kubernetes-based deployments of SQL Server Always On Availability Groups, delivering increased level of resiliency. Read on to learn more about the basic characteristics of these deployments!

2019-07-30

The ‘= NULL’ Mistake and other SQL NULL Heresies

by Additional Articles

Redgate

SQL PROMPT

The SQL Prompt Best Practice rule checks whether a comparison or expression includes a NULL literal ('NULL'), which in SQL Server, rather than result in an error, will simply always produce a NULL result. Phil Factor explains how to avoid this, and other SQL NULL-related calamities.

2019-07-30

Introduction to DevOps: The Application Delivery Pipeline

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Some of the terms in the DevOps pipeline, such as CI and CD, can be confusing. In the second article of this series, Robert Sheldon explains these terms and how they fit in the DevOps pipeline. He also talks about some of the tools you might use.

2019-07-29

New release: Data Masker 6.3 for SQL Server

by Additional Articles

Redgate

Dynamic Data Masking

The newest version of Data Masker for SQL Server includes a new rules window with in-product guidance for choosing the right rule, and a new menu bar for fast access to the items you need.

2019-07-29

Azure Data Factory Stored Procedure Activity Transformation Activities

by Additional Articles

MSSQLTips.com

Azure Data Factory

In this post we will discuss Azure Data Factory transformation related pipeline activities using Stored Procedure activity.

2019-07-26

Dealing with Server Objects, Settings and Features when Provisioning Databases

by Additional Articles

Redgate

SQL Provision

If we want the behavior and performance of our test databases to mimic that observed in production, then we must consider not only the database but also the server. Grant Frtichey reviews the server-level objects, settings and features that we may need to consider, and then shows how to 'synchronize' the linked servers, user logins and SQL Agent jobs, as part of an automated provisioning process, using SQL Provision.

2019-07-26

Modeling Time

by Additional Articles

SimpleTalk

T-SQL

There are those who argue that time doesn’t really exist; it’s just an illusion. That debate won’t keep you from storing and manipulating dates and time in SQL Server. In this article, Joe Celko discusses some of the many ways that SQL Server treats temporal data types.

2019-07-25

Static Data and Database Builds

by Additional Articles

Redgate

SQL Change Automation

Whichever way you wish to ensure that a database, when built, has all the data that will enable it to function properly, there are reasonably simple ways of doing it. Phil Factor explains the alternatives.

2019-07-25

Do you really know what’s happening with your servers?

by Additional Articles

Redgate

SQL Monitoring

As estates continue to grow and evolve, SQL Server professionals must continually adapt. But do you really know what’s happening with your servers? Jamie Wallis highlights the 4 key elements that are currently impacting the working life of an IT leader. Find out what they are here.

2019-07-24