2018-05-23
100 reads
Editorials
Checking CHECKDB
Everyone should be running DBCC CHECKDB on their systems. We not have some help in determining if we are doing this.
2018-05-22
102 reads
SQL Server Gets Smarter and Smarter
With each recent version of SQL Server, Microsoft has added features that can be used to improve query performance with much less effort than traditional index and query tuning require. First was Query Store, introduced with 2016. When enabled, this feature allows you to easily find regression in query performance due to changing execution plans. […]
2018-05-21
94 reads
Mercenary
Steve Jones talks about making deliberate career choices, or just moving from place to place without any worry about the job. Do you care about what work you do? Or is it just a job?
2018-05-18 (first published: 2014-10-14)
236 reads
2018-05-17
124 reads
The Value of Data
Data can be valuable, and there's a new book that compares the value of data today to that of oil in the previous century. Steve Jones has a few thoughts on why we should consider this to be the case.
2018-05-16 (first published: 2014-09-25)
162 reads
Does the Tone matter?
Does the tone of communication matters to you that much that it affects your work in some way?
2018-05-15
120 reads
How do you deal with disappointment?
Disappointment is hard, but you get to choose how you react to it.
2018-05-14
122 reads
2018-05-11
80 reads
Power BI Desktop on the Mac
Power Bi is one of the neatest tools that Microsoft has built for data professionals. It allows anyone to build fantastic interactive visualizations that can help tell a story and help someone make decisions. There have been some amazing demo visualizations from Microsoft customers. I've seen a predictive maintenance visualization for airplanes, one for diabetes […]
2018-05-10
3,620 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
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers