SQL Server 2019 in Containers

• by Steve Jones

• SQLServerCentral

• Virtualization, containers, and k8s

SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production.

Investing in Speed

• by Steve Jones

• SQLServerCentral

• Career

Much of what we do to improve ourselves is an investment in our work. The same thing could be said about businesses. Today a little advice about making an investment.

Stairway Level 2 : Restore a Backup of a TDE Database to Another Server

• by Vishnu Gupthan

• SQLServerCentral

• Stairway Series
• Transparent Data Encryption (TDE)

In Level 1 of this Stairway, we discussed how to configure TDE in a user database using a Database Master Key and Certificate. In this level, we explain the steps for backing up and securing this certificate, as well as how to restore the database on another server instance. Backup the Certificate and Private Key […]

Free eBook: Fundamentals of SQL Server 2012 Replication

• by Press Release

• Redgate

• Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.

Rolling Back One Bug for Another

• by Steve Jones

• SQLServerCentral

• software development

Today Steve asks what you do when a patch causes another bug.

The Products-Often-Purchased-Together Problem Solved in R

• by Alex Chamchourine

• SQLServerCentral

• Data Science
• R
• R Services
• statistics (data)
• T-SQL

Learn how to analysis products that might be sold together using R and SQL Server.

Run SQL Server Agent Job from SSIS

• by Additional Articles

• SQLServerCentral

• Integration Services (SSIS)
• SQL Server Agent

While we can schedule SQL Server Agent jobs and SSRS report subscriptions, the actual time that we want to run them is dependent on when certain processing in our SSIS packages is completed. We also have certain business rules surrounding launching these jobs that we need to enforce which the built-in scheduling capabilities cannot accommodate. For example, we execute a SQL Server Reporting Services (SSRS) report subscription every Monday at 8:00AM but we want to skip it if the current week coincides with our month end processing which will also execute a report subscription for the same report. Can you provide a solution that we can use to accomplish this?

Creating a Azure Cosmos DB Account

• by Deepak Prasad Sahu

• SQLServerCentral

• Azure Cosmos DB

Learn how to get started with a CosmosDB account.

The Challenge of Chat

• by Steve Jones

• SQLServerCentral

• Communication

Today Steve talks about the distractions of chat applications at work.

Six reasons to version control your database

• by Additional Articles

• Redgate

For most application developers, it’s unthinkable to work without version control. So why is the database any different? This blog lays out 6 clear benefits to applying version control best practice to your database alongside your application.