For years, I’ve done consulting around helping organizations tune their database platforms, both from within the database and underneath, to help boost performance and availability. Some database design or...
2020-02-06 (first published: 2020-02-03)
774 reads
If you read the title to this post and your first thought was That’s not SQL is it? then you ... Continue reading
2020-02-05 (first published: 2020-01-27)
869 reads
Welcome to February 2020. It’s the second month of the year 2020! I remember sitting at a server with SQL Server 6.5 installed on it, worrying about the Y2K...
2020-02-05
399 reads
We can now pass dynamic values to linked services at run time in Data Factory. This enables us to do things like connecting to different databases on the same...
2020-02-05 (first published: 2020-01-30)
1,160 reads
When we use ADF to call Databricks we can pass parameters, nice. When we finish running the Databricks notebook we often want to return something back to ADF so...
2020-02-05
52 reads
When we use ADF to call Databricks we can pass parameters, nice. When we finish running the Databricks notebook we often want to return something back to ADF so...
2020-02-05
3 reads
When implementing any kind of automation for database deployments, it’s important to implement safeguards for your production environment. This is needed even in the best conditions when team members...
2020-02-05
18 reads
Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...
2020-02-04
9 reads
Working on a SQL 2017 database where an external, non-Microsoft application has direct access to read/write data via the ODBC Driver 17 for SQL Server.
They suddenly began to experience...
2020-02-04 (first published: 2020-01-24)
399 reads
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for Azure Data Factory - Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and...
2020-02-04 (first published: 2020-01-28)
3,457 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers