Exit Codes, systemd and SQL Server on Linux

In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit...

Create a Login in a SQL Server Availability Group

Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where...

Line-Continuation in T-SQL

Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e....

Check out my Tips for Friday Blog Series

In case you missed, I started a new blog series several weeks ago called 5 Tips for Friday on SQL...

Drop That Schema

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change.
Related...

Drop That Schema

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of...

Cumulative Update #1 for SQL Server 2017 RTM

The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.

CU#1 KB Article: https://support.microsoft.com/en-us/help/4038634/cumulative-update-1-for-sql-server-2017

Microsoft® SQL Server® 2017 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=56128

Cumulative Update #1 for SQL Server 2017 RTM

The 1st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site.
CU#1...

Friday Reading 2017-10-27

Morning all! PASS Summit is coming next week but unfortunately I can’t make it this year. I hope everyone who...

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

150th Blog Post . So, the post involves video demo :)Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few...