Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: July 2013

Using DTEXECUI to generate a DTEXEC command line statement the easy way

SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool but to be honest it feels like it was written not just one committee but several different ones. And I won’t say they weren’t talking to each other (I kind… Read more

2 comments, 1,251 reads

Posted in SQLStudies on 31 July 2013

Notes on debugging Database Mail problems

I’ve had to debug database mail problems several times over the last year or so. Below is a collection of the stored procedures and queries that I’ve ended up using. I’ve added notes to most of them to help explain and work with them.

USE msdb
GO

-- Check that…

Read more

4 comments, 324 reads

Posted in SQLStudies on 29 July 2013

I’m going to my first SQL Saturday!

I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused by my own stupidity. Shortly after that I got to go to the Pass Rally in Dallas and had an even more fantastic time (no travel problems this time). My… Read more

0 comments, 235 reads

Posted in SQLStudies on 24 July 2013

Generic Dynamic SQL Stored Procedure

Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle dynamic SQL. Honestly I found the idea interesting and coming up with a solution rather fun.

Another user, HABO, also provided an answer, which in several ways was… Read more

3 comments, 2,612 reads

Posted in SQLStudies on 22 July 2013

Amusing SQL Trick – Hide yourself from SQL Server

I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead to one of the most amusing SQL Blogs I’ve ever read. It’s completely serious, and yet the trick discussed so fits my sense of humor I couldn’t help but laugh. Read more

0 comments, 370 reads

Posted in SQLStudies on 17 July 2013

Scripting a partitioned table or index, a caution.

I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.

First here is a script to create a simple partitioned table so you can follow along if you like.

CREATE PARTITION FUNCTION fn_PartTestFunction (int)
AS RANGE LEFT FOR VALUES  (1,2,3,4)
GO…

Read more

10 comments, 1,454 reads

Posted in SQLStudies on 15 July 2013

Ordering steps in a SQL Agent job

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is also a limited amount of control flow available in SQL Agent jobs. Here are a couple of examples of how it works and what you can do with it.

First… Read more

2 comments, 1,020 reads

Posted in SQLStudies on 8 July 2013

Writing Dynamic SQL (A how to)

A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions for good habits when writing dynamic SQL. Along the same lines, this is my methodology for writing Dynamic SQL. Again this has nothing to do with when it is a… Read more

2 comments, 1,406 reads

Posted in SQLStudies on 1 July 2013