SQL Replication SubscriptionStreams setting
In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be...
2017-10-23 (first published: 2017-10-14)
6,997 reads
Blog Posts
SSMS error – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service
Issue: SQL Server Integration Service (SSIS) 2016 unable to connect from SQL Server Management Studio (SSMS) 17.0.
Error:
Connecting to the Integration...
2017-10-23
2,332 reads
Webcast: Troubleshooting SQL Server Connection Issues
I will be doing a live webcast on Thursday, November 9th 2017 at 3 PM Eastern Time (8 PM UTC...
2017-10-23
447 reads
Why would a SQL Server DBA be interested in Python?
If we follow blogs and publications on the technological advancement with respect to SQL, we notice the increase in the...
2017-10-23
491 reads
SQLSaturday Orlando 2017 Notes – Part 2
SQLSaturday is really three sites. The public facing one (www) plus one for event admins and one for HQ to...
2017-10-22
398 reads
SQLSaturday Orlando 2017 Notes – Part 3
This year we held our fourth Student to IT Pro Seminar for the students at Seminole State College. It runs...
2017-10-22
396 reads
A virtualized CPU forced me to eat my lunch early, every day, for weeks
I worked one particular contract where I was forced to take my lunch at 11:35 every day, and it was all virtualisations fault!
To set the scene it was a...
2017-10-21
12 reads
A virtualized CPU forced me to eat my lunch early, every day, for weeks
I worked one particular contract where I was forced to take my lunch at 11:35 every day, and it was...
2017-10-21
46 reads
A virtualized CPU forced me to eat my lunch early, every day, for weeks
I worked one particular contract where I was forced to take my lunch at 11:35 every day, and it was...
2017-10-21
50 reads
Azure SQL Database Level Firewall Rules
I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...
2017-10-20 (first published: 2017-10-11)
1,713 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