Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates...
2017-09-12
510 reads
Blog Posts
Power BI Report Server (On-Premises) for All Data Sources is Available!
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server...
2017-09-12 (first published: 2017-08-28)
3,814 reads
Remove an Active Lease on a Blob in Azure
I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted....
2017-09-12
502 reads
Setting the Sample Rate for Auto Stats updates
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,312 reads
Someone is not following the best practices – dbatools and Pester don’t lie!
This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t) and we will "Let’s...
2017-09-12
723 reads
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,769 reads
SQLOrlando
We’ve haven’t had a good solution for managing money for SQLSaturday and our groups here in Orlando. In the early...
2017-09-12
430 reads
T-SQL Tuesday #94 - Automating Configuration Comparison
This month’s T-SQL Tuesday is hosted by Rob Sewell and he’s posed the following question:
What are you going to automate today with PowerShell?
I’m cheating a little bit in that...
2017-09-12
18 reads
Turn on/off Azure VMs with Powershell
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked...
2017-09-12
450 reads
Warning Handling in dbatools Automation Tasks
So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote that was reporting success but the job was actually...
2017-09-12
6 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