Real World DevOps

• by Steve Jones

• SQLServerCentral

• DevOps and Continuous Delivery (CI/CD)

Steve agrees with some real world thoughts on DevOps from some customers.

New release: Redgate Change Control now integrates with Git

• by Additional Articles

• Redgate

• Redgate Software

In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.

SQL Server Management Studio Connection to Integration Services Error Class Not Registered

• by Additional Articles

• MSSQLTips.com

• Management Studio (SSMS)

In this article we look at some reasons why you cannot connect to SSIS using SQL Server Management Studio and how to solve the problem.

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

• by iLearnSQL

• SQLServerCentral

• Collation
• Install
• Server-Level Collation

As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]

Confidential VMs

• by Steve Jones

• SQLServerCentral

• Encryption
• Virtualization, containers, and k8s

Google is introducing encrypted virtual machines.

How Many Databases Can You Name?

• by Additional Articles

• Database Journal

• MS SQL

There is a huge number of databases available. How many could you name? Create our list and then compare to our list of well over 100 databases!

Good Morning!

• by Grant Fritchey

• SQLServerCentral

• Career
• Database Weekly

Grant notes that helping others can help you personally.

Removing Extended Properties

• by Steve Jones

• SQLServerCentral.com

• extended properties

With the new labeling and classificiation options in SQL Server, there might be a need to remove these labels before deploying the database.

Research on the Changing Workplace

• by Steve Jones

• SQLServerCentral

• the modern workplace

The workplace is certainly changing with the COVID-19 pandemic. Steve shares a few learnings from Microsoft's work from home experiment.

Install SQL Server Integration Services in Visual Studio 2019

• by Additional Articles

• MSSQLTips.com

• Integration Services (SSIS)

Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.