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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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