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,...

Using Google Chrome with SSRS

In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.

Using Google Chrome with SSRS

In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome...

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/

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…

Starting and Stopping SQL Server with PowerShell

Have you ever had this issue? You are trying to explore new features of SQL Server or you want to install the latest version for some testing, but SQL...

T-SQL Tuesday 123: Life Hacks to make your day easier

This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life...

Ethics in Modern Data presentation at SQLSaturday Austin BI Edition 2020

Excited to launch another new presentation, the first co-presented with my wife, on Ethics in Modern Data. We'll explore the ethical considerations around historical bias, ethics in analysis and...

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...