How to Suck at Database Administration
Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.
Build a Career Radar
A technology radar can help you assess what's important and where to focus your effort. Companies use these, and Steve Jones says you should as well.
Get Set For Speed
Loops are common in application code, but set-based solutions are the way to go with SQL.
"But It Worked in Development!" - 3 Hard SQL Server Performance Problems
You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.
An AI Loophole
We can't always explain how AI systems work. Steve Jones wonders if this is a loophole in the GDPR legislation.
Performance Comparison Between SQL Server 2014 and 2016
This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.
Degree of Duplication
Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.
Brush Up on Your ETL Skills
The need for data imports, exports, and transformations seems to be growing.
Stairway to Database Design Level 9: Normalization
In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.
SQL Server Reporting Services 2017 Tutorial
SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Alamat BCA KCP Bursa Efek Jakarta Tlp:0821°7555°651
Tlp/Wa 62 8217555651 Gd. Bursa Efek Jakarta, Jl. Jend. Sudirman kav 52-53 Tower II...
Alamat BCA KCP WTC Sudirman Telp:0821.8200.233
Telp/Wa 62 8218200233 World Trade Center I, Jl. Jenderal Sudirman No.Kav. 29, RT.8/RW.3, Kuningan,...
BCA KCP Sampoerna Strategic Square Telp:08218200203
Telp/Wa 62 8218200203 Gd. Sampoerna Strategic Square, Jl. Jenderal Sudirman Tower A - Ground...