The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,230 reads
Selecting a Random Row From a Table
A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...
2018-07-26 (first published: 2018-07-20)
735 reads
Friday Reading 2018-07-20
Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.
I’ve...
2018-07-20
336 reads
My #SQLCareer Day–July 19
I’ve asked for #SQLCareer posts, and I haven’t done any. My job isn’t a data platform DBA or developer, but...
2018-07-20
475 reads
Getting Schooled by Brent
Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training...
2018-07-27 (first published: 2018-07-19)
2,393 reads
SQL Solver
A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective...
2018-07-19
417 reads
Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers...
2018-07-19
892 reads
Data Masker for SQL Server and Temporal Tables
A customer had a question recently about using Data Masker for SQL Server and temporal (or system versioned) tables. I...
2018-07-18
947 reads
TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends...
2018-07-18
18 reads
TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates...
2018-07-18
243 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