SQL Server 2017 — change the tag for your docker images
Firstly:
SQL Server 2017 is now officially released!
I have been using SQL Server 2017 running on Linux for a while now...
2017-10-03
513 reads
HeyMo0sh
Want to know what software is running on the VSTS Hosted Agent? Go here….
This is related to my previous post about installing things on my Private-Hosted agent that I use for my VSTS...
2017-10-02
265 reads
When upgrading a Visual Studio project — you need to upgrade your TFS/VSTS Agent
This post is linked to my post about hosting VSTS private agents . I had recently upgraded my Visual Studio environment...
2017-10-01
485 reads
DevOPs is not just about the latest & greatest tools
I’m a technical guy.
Thus – I love tools. They make stuff go.
Tools are great.
Except – as I wrote in my other post...
2017-08-10 (first published: 2017-07-26)
1,753 reads
DevOPs and Databases — the one thing you may be doing wrong.
This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b) – for hosting this month’s...
2017-06-13
645 reads
var Microsoft_Data_Platform_MVP = “Yip.”;
The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...
2017-06-06
649 reads
Removing an App Service Plan in Azure
In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in...
2017-05-18 (first published: 2017-05-07)
1,513 reads
Creating an Azure SQL Database via PowerShell
This post is about using the brilliance of PowerShell to script the creation of databases in Azure.
Background:
Apart from the obvious question...
2017-05-11 (first published: 2017-04-30)
1,348 reads
T-SQL Tuesday #90 — Bringing Continuous Delivery to a ‘brownfield’ database system
This blog post is part of T-SQL Tuesday #90 – Shipping Database Changes.
I have decided to write about a client’s SQL...
2017-05-09
384 reads
Creating an App Service in Azure that connects to an Azure SQL Database.
Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...
2017-04-30
595 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Alwyason availability group can set primary role permanently?
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
Ask SSC