2016-03-14
90 reads
2016-03-14
90 reads
The age old question of where should business logic be stored
2015-10-16
276 reads
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)
29,535 reads
2015-01-26
12,022 reads
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,238 reads
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,477 reads
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,784 reads
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,407 reads
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Hello, I want to have value Month ago Year ago So far, I've this...
Comments posted to this topic are about the item The Fake Speakers
Comments posted to this topic are about the item Stairway to Database DevOps Level...