Carefully Giving Normal Users Security Permissions
When we need to delegate work to less privileged users, Steve has an idea.
2020-07-16
200 reads
Editorials
2020-07-15
220 reads
2020-07-14
125 reads
Beating the Cloud Vendors
Can you run a system better than cloud vendors? You should know and be able to prove it.
2020-07-13
146 reads
Controlling Intelligent Query Processing Features
I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
2020-07-11
825 reads
Moving away from an RDBMS
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
708 reads
2020-07-09
107 reads
Better Laptop Life
Intel is building hybrid processors, combining the power of the regular CPUs most of us use with Atom power saving technology.
2020-07-08
127 reads
2020-07-07
752 reads
2020-07-06
142 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