|
|
Front Page News
-
|
My faithful readers will remember one of my orginal posts in which I expressed my enthusiasm for a new phone I was planning on purchasing, the Pantech Matrix . Well, tragedy struck today when, for no apparent reason, the slider keyboard no longer functions....
|
-
|
Introduction This post is part of a series titled An Introduction to the SSIS Expression Language . In this post, I demonstrate the SSIS Expression Language and Dynamic Property Expressions. To build the demo project described in this article you will...
|
-
|
Introduction This post is part of a series titled An Introduction to the SSIS Expression Language . In this post, I demonstrate the SSIS Expression Language and the Conditional Split Transformation. To build the demo project described in this article...
|
-
|
When I start to learn a new technology, I find I learn best if I jump right in, get my hands dirty, and play around with it for a while. After a couple initial ah-HA moments and early successes, I inevitably hit a wall where I can't seem to solve a particular...
|
-
|
Jeremiah Peschka tagged me in recent blog post, asking me about things I know now, not necessarily SQL related, that I wish I'd known when I started my 'professional career'. Here's my stab at it: Almost Nobody Knows What They Want To Be When They Grow...
|
-
|
Victim: Sugar Rabbit; Age: approximately 4 days; Eyes: dark; Skin: brown; Height: 2" and 3" (respectively, post-crime) Suspect: Riley Cooper Leonard; Age: 1.5 years; Eyes: shifty and innocent all at the same time; Skin: tan; Height: 31" On the morning...
|
-
|
I was helping some developers with their upgrade of an ISV application, when we hit a snag. It seems that our installation of the application had columns defined as binary(8) when the standard data structure called for timestamp. I seemed to recall that...
|
-
|
Introduction This post is part of a series titled An Introduction to the SSIS Expression Language . In this post, I demonstrate the SSIS Expression Language and the Derived Column Transformation. To build the demo project described in this article you...
|
-
|
Introduction This post is part of a series titled An Introduction to the SSIS Expression Language . In this post, I demonstrate the SSIS Expression Language and Variables. To build the demo project described in this article you will need SSIS 2005 and...
|
-
|
The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language....
|
-
|
A month or so ago I was tagged in a blog post by SQL Batman to share my professional resolutions for this year, 2009. It might seem a little late to be thinking about this sort of thing, but honestly, there is a method to my madness. I like to use the...
|
-
|
I normally do not write opinion pieces, I feel that if I can contribute anything worthwhile to the community my efforts are best served explaining or demonstrating a technical area where I have some level of expertise. I have however one subject that...
|
-
|
A request came in from one of the developers asking if there was a way to script out all of the triggers for a list of tables in a database on SQL Server 2005. This database has around 60k tables, and navigating to each of the 40 some tables that the...
|
-
|
I know my faithful readers are waiting on pins and needles for me to post my goals for 2009. I promise they are forthcoming, but I prefer to take my wife's advice and use the entire month of January to review the previous year, define goals for the new...
|
-
|
A new application called Tweet-SQL was just released yesterday. It allows the use of the Twitter API with standard T-SQL. It works with SQL Server 2005 and above. I have downloaded a 30 day trial and I'm playing around with it now. I already have a couple...
|
-
|
If your company is like mine, you are largely at the mercy of your software vendors as to when you'll be upgrading to SQL Server 2008. But, if you're like me, you want to start taking advantage of the features of the SQLPS mini-shell in your regular PowerShell...
|
-
|
To everyone wanting to get into all aspects of SharePoint, I encourage you to attend SharePoint Saturday on January 10th, in Hampton Roads. For more details check out the site! I hope to see you there!...
|
-
|
I admit that I'm not on the cutting edge of technology. Sure, I follow the news to see what's out there, but I can't afford to be an early adopter, either in terms of coin or in terms of time. Plus, I'm a pretty conservative guy when money's involved,...
|
-
|
How am I going to get from point A, this nebulous idea of a dictionary website, to point B, which is the completed project? That question indicates the need for a road map or plan of some sort. But, as I've been thinking about this over the past week,...
|
-
|
Two weeks ago I attended my first PASS Community Summit in Seattle, WA, and, on top of having a great time, I was inspired to blog. But, what to blog about? In the past, every time I had the inkling to blog, to add my voice to the electronic chorus, that...
|
-
|
Alright everyone has written the obligatory "Hello World!" program when they start to learn a new language. I have my own variety of that practice and its PrimeFinder. Whenever I start to learn a new language I write a program that finds primes. I know...
|
-
|
Hello all! Its been a good year overall, despite the fact that I was laid off from Land America due to the economic conditions in the real estate market and the ripple effect it has had on companies like Land America. I was laid off two weeks ago, along...
|
-
|
This is a relatively short post about raising an error in T-SQL and having SSIS not recognize that error. If you have an SSIS package that calls a SQL Task and that T-SQL for whatever reason ends up raising an error the SSIS package that called the T-SQL...
|
-
|
Introduction I'm a big fan of intellectual integrity. It appeals to my engineer nature. I'm also an amateur student of all things social, which covers philosophy and politics. So I'm really energized about the Web 2.0 social networking I see all around...
|
-
|
I'm a little late getting something posted for Blog Action Day . This year's focus is on poverty. I thought I'd share a story. There was this guy who grew up in a rural area in the US. Rural in the US is not necessarily poor. And poor in the US is wealthy...
|
|
|
|