-
How are COALESCE and ISNULL different?
6August 7, 2013 by Kenneth Fisher
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2) …
Continue reading -
Database Permissions Queries
3August 5, 2013 by Kenneth Fisher
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
Continue reading -
Using DTEXECUI to generate a DTEXEC command line statement the easy way
8July 31, 2013 by Kenneth Fisher
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool …
Continue reading -
Notes on debugging Database Mail problems
10July 29, 2013 by Kenneth Fisher
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
Continue reading -
I’m going to my first SQL Saturday!
Leave a commentJuly 24, 2013 by Kenneth Fisher
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused …
Continue reading -
Generic Dynamic SQL Stored Procedure
5July 22, 2013 by Kenneth Fisher
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
Continue reading -
Amusing SQL Trick – Hide yourself from SQL Server
1July 17, 2013 by Kenneth Fisher
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
Continue reading -
Scripting a partitioned table or index, a caution.
14July 15, 2013 by Kenneth Fisher
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
Continue reading -
Ordering steps in a SQL Agent job
2July 8, 2013 by Kenneth Fisher
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
Continue reading -
Writing Dynamic SQL (A how to)
6July 1, 2013 by Kenneth Fisher
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 