SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos

Learn how to correct an error that is overloading SCOM by fixing an SPN.

The Real Life Software Movie Plot

A recent thwarted attack reads like a movie plot.

The Two Ways Containers Will Revolutionize Database DevOps

Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.

Do You Have Big Data?

Data sizes are always growing. Stats on world data are astounding, as are the stats many of us experience in our lives. Plenty of us have moved from MB management to GBs, and I see plenty of people dealing with TB storage at home. Most of that data is likely from images and video, but […]

Half Of You Don’t Understand Variables and Transactions.

Do table variables and variables respect transactions? If we set the value of a variable during a transaction, and we roll it back, what happens?

Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication

Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

The Best Security for Database Administrators

Today Steve talks about limiting security issues for administrators.

The Future of DevOps

Join Microsoft MVP Kendra Little to discover how you can fully left-shift your deployments with version control and automatic cloning using Redgate's latest innovations.

Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets

In this article we look at two methods of using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets.