Blog: Kenneth Fisher


208 blogs updated: 2 min. ago
Updateable CTEs
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn't ... Continue reading
15
18-10-2017 16:06:49 Kenneth Fisher SQL Server
Permissions required for developing with Temporal Tables
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table ... Continue readi...
13
16-10-2017 16:00:49 Kenneth Fisher SQL Server
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
I've you've done much work with the system views (DMVs for example) then you've had to translate an object_id into ... Continue reading
13
11-10-2017 15:15:03 Kenneth Fisher SQL Server
Small identity columns
We frequently talk about dealing with outgrowing INT identity columns. What we don't talk about all that often is small ... Continue reading...
9
09-10-2017 15:34:07 Kenneth Fisher SQL Server
The Alpha and the Omega. The BEGIN and the END.
The BEGIN/END block is a fairly standard thing if you've ever done any coding, but it never hurts to do ... Continue reading
19
04-10-2017 15:33:34 Kenneth Fisher SQL Server
Haunted SQL
I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about ... Continue reading
12
03-10-2017 05:01:15 Kenneth Fisher SQL Server
SQL Homework – October 2017 – Sample/Test Database(s)
Last month your homework was to set up your own lab. Now it's time to put a sample database or ... Continue reading
11
02-10-2017 15:47:58 Kenneth Fisher SQL Server
SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word ... Continue reading
10
27-09-2017 15:50:02 Kenneth Fisher SQL Server
Saving and restoring session options settings
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations....
9
25-09-2017 16:16:42 Kenneth Fisher SQL Server
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, ... Continue reading
22
20-09-2017 16:10:40 Kenneth Fisher SQL Server


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.