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

Entering the Dark Side

If any of you follow me on SQLServerCentral.com, then you know I recently started a new job.  Well, after two weeks of in-processing training, I have finally started getting involved in actual work.  One of the things I am getting to learn is Agile techniques, in this case SCRUM.  Interesting… Read more

5 comments, 869 reads

Posted in SQL Musings from the Desert on 26 August 2010

Sins of a Recursive CTE?

On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com.  I’m not going to discuss the pro’s or con’s of his approach to solving what he considers a problem with Time Dimensions, that may well be the target of a separate… Read more

1 comments, 1,346 reads

Posted in SQL Musings from the Desert on 3 June 2010

Getting Scared

This is not a technical post, it’s personal, but I need to express my fears.  It isn’t about our economy, or that I may lose my job.  I’m confident our economy will rebound (eventually) despite the best efforts of Congress and the President.  My job is fairly secure, at least… Read more

7 comments, 800 reads

Posted in SQL Musings from the Desert on 1 April 2010

My next republished article is now available

Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com.  This article compares two methods of creating a dynamic tally table.  You will find this article here: http://www.sqlservercentral.com/articles/T-SQL/67899/ .  This article has had 615 views since it was published on 6/1/2009 on sswug.org.  Not a… Read more

3 comments, 557 reads

Posted in SQL Musings from the Desert on 21 September 2009

Republished Article

Well, the first of two articles I originally had published on sswug.org will be published on ssc tomorrow.  I'm looking forward to the expanded exposure this article will receive and the feedback I will see starting tomorrow.  In the first 90 days this article was published on sswug.org it had… Read more

1 comments, 710 reads

Posted in SQL Musings from the Desert on 14 September 2009

Welcome Home !!

I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us at work.  Finishing things up for the school year and getting ready for the next year.  However, today I am going to talk about something non-technical.

Friday night my youngest… Read more

1 comments, 629 reads

Posted in SQL Musings from the Desert on 22 August 2009

Learning a New Development Platform

This past week at work we have been having some in-depth training.  The interesting thing is it hasn't been SQL Server, although the Microsoft product involved uses it extensively, it has been Windows SharePoint Services and Microsoft Office SharePoint Server.

The reason I thought I'd talk about it briefly is… Read more

3 comments, 650 reads

Posted in SQL Musings from the Desert on 18 June 2009

SSC, more than a Forum, it is a Community

I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent.  So far, there haven't been a whole lot of votes, but those who have, have been unanimous in using SQLServerCentral.com and have indicated that there are a few other sites they may be visited occasionally.  What… Read more

8 comments, 767 reads

Posted in SQL Musings from the Desert on 7 June 2009

My Latest Articles

A few weeks ago I mentioned my blog that I would have two articles published on sswug.org.  Well, they have been published and are available to members of sswug.org.

The first article, published on May 26th, is titled Deleting Large Number of Records.

The second article, published on June… Read more

3 comments, 690 reads

Posted in SQL Musings from the Desert on 4 June 2009

Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries.  In this particular case, in the column list of a SELECT statement.  Did it make sense to encapsulate a routine to strip of the time portion… Read more

6 comments, 1,665 reads

Posted in SQL Musings from the Desert on 7 May 2009

Published, Again!

I have written two new articles and they are going to be published, not on SSC but on SSWUG.  I thought I'd help out Chris Shaw a bit and write a few articles for him as well.  Plus it broadens my horizons some as well.

The first article, based on… Read more

4 comments, 562 reads

Posted in SQL Musings from the Desert on 2 May 2009

When a Community Rallies!

I have been a bit lax these past few days, but I have been having a bit of a writers block not knowing what to write about.  Well, I realized this evening there is something worth writing about, and it is happening right now on SQLServerCentral.com.  An amazing thing is… Read more

5 comments, 625 reads

Posted in SQL Musings from the Desert on 27 April 2009

Career Development and Training

I know I discussed this in an early post, but it seems to have reared its ugly head again.  This time during the discussion of Barry Young's first article in his series on removing cursors from your code.

It seems interesting that there are individuals and companies out there the… Read more

3 comments, 705 reads

Posted in SQL Musings from the Desert on 17 April 2009

Dealing with Difficult Forum Users - The Flip Side

Earlier I talked about dealing with the difficult forum user from the perspective of providing help.  Now let us look at from the flip side of the coin.  You are asking for help and you aren't getting what you want or need.

The first thing you have to realize is… Read more

20 comments, 840 reads

Posted in SQL Musings from the Desert on 5 April 2009

A Variable Length Random String

I was looking through some of the active threads on SQLServerCentral.com tonight, and I ran across one with some code that looked familiar.  While reading this thread, I noticed that the function returned a fixed length random character string.  This told me that if you needed a random character string… Read more

0 comments, 1,607 reads

Posted in SQL Musings from the Desert on 4 April 2009

Keeping Relevant in the Face of Changing Technologies

I was recently asked by a co-worker on my team at work what he should do to keep up with changing technologies in our career field.  I was slightly amazed at the question, as I know I have made my thoughts on the matter fairly clear for several years.  My… Read more

2 comments, 840 reads

Posted in SQL Musings from the Desert on 31 March 2009

Some Common Date Routines

I'm sure that these routines are available in a variety of locations, this just adds one more place that people can find them if they need them.  These are some common routines for generating commonly needed dates.  I hope people find them useful in MS SQL Server.

 

declare @ThisDate…

Read more

15 comments, 7,632 reads

Posted in SQL Musings from the Desert on 25 March 2009

How to Deal with the Difficult Forum User

It has happened to us all at one time or another.  We are trying to help someone on an online forum and they won't cooperate when asked for more details regarding the problem they are experiencing.  You may have written some code and they come back and say it doesn't… Read more

6 comments, 820 reads

Posted in SQL Musings from the Desert on 25 March 2009