Confusion of An Old Technologist
As someone who still actively pursues a career in technology, I’m a little on the older side. I got started...
2017-02-23
411 reads
The Scary DBA
Estimated Costs of All Queries
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...
2017-02-22 (first published: 2017-02-20)
2,495 reads
Export All Plans From Cache to a .SQLPLAN File
I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file....
2017-02-13
864 reads
Does Query Store Pre-Allocate Space
I love the questions I get while I’m presenting because they force me to think and learn. The question in...
2017-02-14 (first published: 2017-02-07)
1,507 reads
Still Grateful to Rodney Landrum
So, my blog got hacked. They edited the page where I thanked Rodney for all that he did. I had...
2017-02-06
440 reads
I have been hacked
I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.
The post I have been hacked...
2017-02-05
599 reads
Data About Execution Plans
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great...
2017-01-23
531 reads
Scheduling Statistics Maintenance in Azure SQL Data Warehouse
The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the...
2017-01-25 (first published: 2017-01-18)
1,111 reads
Query Optimizer and Data Definition Language Queries
Data Definition Language queries don’t go through the optimizer, right? While normally, my short answer to this question in the past would...
2017-01-10
597 reads
Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
465 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Alamat Kantor BCA KCU Wisma Millenia Telp:08218200174
Via Wa:628218200174 Alamat.Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec. Tebet,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers