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
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
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
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
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,576 reads
Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...
2017-04-30
617 reads
In this post we will remove some databases located in Azure.
This related to my last post where I am cleaning...
2017-04-30
1,615 reads
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,359 reads
For the past 6 months I’ve been paying for my own Azure subscription. My work has a plan but for...
2017-04-24
377 reads
This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...
2017-04-22
1,054 reads
Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...
2017-04-22
244 reads
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
By Rohit Garg
Why Microsoft Azure Certifications Are Beneficial for Your Career
How to Schedule...
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
We're currently on SQL 2019 and will likely be looking to migrate to a...
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers