Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run...
2018-05-08
223 reads
Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run commands from outside of the container and this gave...
2018-05-08
11 reads
SQL Server Snapshot vs Read Committed Snapshot
For a quick introduction to transaction isolation levels see my previous post on them.
Once snapshot isolation is enabled on a...
2018-05-08
2,202 reads
T-SQL Tuesday: Giving back to the community
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
409 reads
#tsql2sday – Giving Back – Reprise
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us...
2018-05-08
235 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
287 reads
Day 8 Configuration- Command-line
Yesterday we discuss about different ways of options and configuring with environment variable which will place MySQL locate for values...
2018-05-08
231 reads
T-SQL Tuesday #102 – Giving Back
This month Rily Major (b | t) ask us to talk about how we are giving back to the community if...
2018-05-08
76 reads
T-SQL Tuesday #102 – Giving Back
This month Rily Major (b | t) ask us to talk about how we are giving back to the community if...
2018-05-08
282 reads
Extended Events – Using Azure Storage
Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks...
2018-05-21 (first published: 2018-05-08)
1,431 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers