A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
237 reads
Editorials
The Network Bottleneck
Computer networks are critical for our work, but if they get clogged with new types of data, we might have a problem.
2019-11-08
249 reads
2019-11-07
229 reads
Predictions for PASS
Steve is missing the PASS opening keynote, but he has a few predictions for the day.
2019-11-06
168 reads
Logging Tables
Today Steve Jones looks at the need to log data from an application or process. Are there good and bad ways to design the structures to log information?
2019-11-05 (first published: 2015-09-25)
639 reads
2019-11-04 (first published: 2015-11-13)
428 reads
A Faster tempdb
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,173 reads
A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
321 reads
2019-10-31
286 reads
Falling Behind and Digital Bankruptcy
The challenges of information overload can weigh on technology workers.
2019-10-30
205 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers