Modernizing Your T-SQL: String Aggregation

This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
SQL Server 2016 gave us the STRING_SPLIT() function,...

Why I Support Code Automation Tools Like ORMs

I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in...

#PowershellBasics: Run a file and pass it a parameter.

I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional ... Continue reading

SQL Undercover TV – Instant File Initialisation

Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script…

AWS RDS SQL Server Announcements - 2020

AWS RDS SQL Server Announcements - 2020

1.   Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs using Managed Microsoft AD: https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/

2.  Amazon RDS for SQL...

AWS RDS SQL Server Announcements - 2020

1.    Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs using Managed Microsoft AD: https://aws.amazon.com/about-aws/whats-new/2020/02/amazon-rds-for-sql-server-now-supports-joining-domain-across-aws-accounts-and-vpcs-using-microsoft-managed-ad/

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on implementing High Availability (HA) (AlwaysOn Availability group) on MSSQL Server.

Asciidoc Distributed Docs as Code

TEST The Problem

I want to keep my code and my documentation in the same place.
I want to separate the presentation layer from my documentation content.
I want to be flexible...

I Presented with Live Captioning and Sign Language Interpreters

I had the pleasure of presenting a full-day pre-conference session on the Friday before SQLSaturday Austin-BI last weekend. I could spend paragraphs telling you how enjoyable and friendly and...

I can do better; we can do better; let’s do better

In the past week or so, the Microsoft Data Platform community has begun having a discussion about inclusivity, both on Twitter and across community blog posts. This conversation began...