SQL Server 2017 on Linux in the Azure portal

SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to...

SQLSaturday Tools

Much has been said about SQL Saturday tools and how PASS is pulling back from development of those tools past...

Syspolicy Phantom Health Records

SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is...

Use Boot Diagnostics to see what your Azure VM is doing at boot time

This blog post is about how to diagnose what your Azure VM is doing while it is booting.
I have a...

When was my last backup / CheckDB / index maintenance?

Keep a good eye on your backup and maintenance; they’re kind of important to the health and well-being of your job wait I mean...

Changing the port for SQL Server in Azure Container Services

I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...

Creating Bar Graph In SQL Server 2017 Using R

Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...

Extending built-in data types

add generic user defined table data types as extension to built-in ones

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:
{ "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location":...

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:

{

"comments":...