How the gym made me a better database bloke…..
A blog post about how many reverse bicep curls or Romanian DeadLiftsI can do…? As Rob Farley (t | b | w)...
2017-10-04
490 reads
The Hybrid DBA's Blog
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
519 reads
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
276 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
500 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,764 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
650 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
388 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,585 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
628 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers