Lee posted on March 7, 2010 07:50
A solution that seems to work. I've been dorking with SSIS and Linq the last couple of days, and it's been enjoyable.  I tried an experiment with the "ORM" tool for Linq in a blog but that didn't work as I initially expected, and certainly needs some more work.  I probably shoul... [More]

Posted in: SSIS , .Net , SQLServerPedia  Tags:
admin posted on March 6, 2010 08:17
Introduction Last August I looked to add the LINQ library to a SQL Server Integration Services (SSIS) Script Task. Why? Two reasons: First, because if you’ve looked any LINQ, the features of it, the language, and most importantly why it exists, you know that it is the bomb for allowing you to do... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Lee posted on February 28, 2010 09:20
I enjoy blogging because it allows me to do the following: Research & Experiment- I find that I am oftentimes testing the limits of SQL Server, or an idea, or something that someone else says or writes about. Learn and then share ideas – I am always running into something, whether it’s a ... [More]

Posted in: Etc. (Off-topic) , SQLServerPedia  Tags:
Lee posted on February 24, 2010 10:25
Moving packages just got easy. I worked on a large project last year at a global company that sells household items, and one thing that I liked about the project was the fact that they used ‘relative’ paths for their SSIS packages when referencing resources, such as text files, executables, xml fil... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Lee posted on February 23, 2010 19:34
Awesome guide for installing/configuring SSIS A good friend of mine, Matt Ross, a super-DBA, developer, expert on Windows/VMWare/AD/etc., and teaching associate at North Lake College in Irving, TX, wrote a sweet guide for installing and configuring SSIS [1], and I talked him into letting me post on... [More]

Posted in: SSIS , SQLServerPedia  Tags:
admin posted on February 20, 2010 14:55
Penton going Chapter 11. I read today that Penton Media, the outfit that runs SQL Server Magazine, Windows & .Net Magazine, and DevConnections and SQLServerconnections, will bail from it's debt by restructuring.  Read about this at the link below.  You know - I saw this coming several... [More]

Posted in: Etc. (Off-topic) , SQLServerPedia  Tags:
admin posted on February 14, 2010 03:59
Introduction The Script Component in SQL Server Integration Services (SSIS) seems to be a somewhat inauspicious data flow task that is oftentimes avoided or misunderstood by some. When you open the task, you don’t see much - a few methods, a couple of references, and that’s about it. Truth be told,... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Interesting question about parameters. My good friend and super-stealth ninja middle-tier, business objects, BLL, DAL, bad*ss programmer Craig Boland asked me a question the other day about an oddity with stored procedures and functions. Eh, whassat you say? What’s a super-stealth ninja middle-tier... [More]

Lee posted on January 23, 2010 08:20
I was looking around the other day on Google! and elsewhere for info on SSIS transactions and MSDTC setup, but didn’t find much; actually what I found were a lot of questions around their use. Check out my screencast as I geek with them, and try to make heads or tails out of their use. Expand ... [More]

Posted in: SQL Server 2008 , SQLServerPedia , SSIS , Video  Tags:
Admin posted on January 21, 2010 06:34
I was notified of a database geek meme going around by some of the well-known SQL gurus (Paul Randal, Tom LaRock, Grant Fritchey, Tim Mitchell, and others) and since I was invited I thought that I would go ahead and participate as well.  This one asks “What three things or events brought ... [More]

Posted in: Etc. (Off-topic) , SQLServerPedia  Tags:
Geeking with sp_.   WHAT’S IN A NAME? We have all heard that prefixing SQL Server stored procedures with “sp_” is a no-no; you have probably read the many reasons not to do this, but the most familiar ones to developers are that 1) Microsoft uses the “sp_” naming convention for their syste... [More]

Posted in: SQLServerPedia , TSQL  Tags:
Lee posted on December 20, 2009 06:03
If it's not your work, it's not your work. I never paid much attention to the several articles out on the web about plagiarism with respect to SQL Server, blogs, etc., that is, until it happened to me. About a year ago I did a really cool blog on an interesting idea, and a month or so later, ther... [More]

Admin posted on November 26, 2009 13:49
Geeking with table variables. Again.     Table variables have always been somewhat interesting to work with when developing in SQL Server. I remember when they came out in SQL Server 2000 we were all excited about trying them out, something new from SQL 7 that mainly sparked our in... [More]

Posted in: SQL Server 2008 , SQLServerPedia , TSQL  Tags:
Lee posted on November 9, 2009 18:56
Effective, simple, and fun.   I always enjoy doing some ‘practical bitmasking’ whenever I can, if for no other reason than to show someone that there are some cool situations to use the technique. If you’ve happened to catch some of my other blogs or presentations on bitmask... [More]

Lee posted on November 6, 2009 18:14
Making 'dynamic' even more dynamic In this month’s SQL Server Magazine (11/2009) an article was featured on the concept of dynamic pivot.  This was of interest to me because, since I peruse the stats on how people arrive at this site, I have seen several searches from Google! looking f... [More]

Lee posted on October 25, 2009 07:24
Taking care of the transaction log (or not).   Introduction It’s great to see that the response from the first three in this series of blogs indicates that they have been help to some folks. I continue getting searches and questions of this simple yet effective technique; there are many SQL ... [More]

Posted in: SQLServerPedia  Tags:
Admin posted on September 22, 2009 15:57
Are Deadlocks becoming a thing of the past?   Unless I missed it, I didn’t see his example There was a blog post [1] awhile back by super-stealth DBA dude Brad McGehee that described the notion of using the new Try/Catch syntax for handling deadlocks. Great idea and good blog posting... [More]

Posted in: SQLServerPedia  Tags:

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog