Finding Composite Primary Key Columns

You never know when the idea for a script will make an appearance.
I had to work with composite primary keys...

Public preview of Azure SQL Database Managed Instance

Microsoft has announced the public preview of Azure SQL Database Managed Instance.  I blogged about this before.  This will lead...

Public preview of Azure SQL Database Managed Instance

Microsoft has announced the public preview of Azure SQL Database Managed Instance.  I blogged about this before.  This will lead...

Set New Errorlog File location – SQL Server on Linux

For SQL Server 2017 RTM, the fourth cumulative update was released on 20th February, and it is available for download...

Using the Analysis Services Execute DDL Task

My grandfather used to say, “There’s more than one way to skin a cat.”  I always thought it was a...

Win at IT Contracting: The recruitment Agent Business Model

WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships

Welcome to WIN at IT contracting: A...

Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances

For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....

Dates and Times in SQL Server: DATE

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

How to Move Master Database to Another Location – SQL Server On Linux

With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...

Learning Goals 2018–February Review

Better than month 1. Only XE this month.
My first week I got a reminder to spend some time on XE,...