2016-03-14
90 reads
2016-03-14
90 reads
The age old question of where should business logic be stored
2015-10-16
268 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)
24,181 reads
2015-01-26
12,019 reads
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
13,779 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,470 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,685 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,386 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers