2016-03-14
120 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
Where should middle tier business logic be stored?
The age old question of where should business logic be stored
2015-10-16
327 reads
Cumulative sum of previous rows
I had an update statement that took 3 minutes to run after this code change it took 6 seconds.
2015-03-27 (first published: 2014-05-08)
34,992 reads
2015-01-26
12,078 reads
Why Primary Keys can be important on large tables
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,801 reads
What is your default database set to?
Some people set their default database to the database they use most often. This can cause issues when a restore fails.
2013-11-14
7,526 reads
A simple math expression solver
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,950 reads
A Search and Replace Script when Moving Objects from Prod to Test
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
2010-02-03
7,503 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers