admin posted on March 29, 2010 10:52
A tutorial on the Script Component, continued. Introduction The Script Component allows you to 1) connect to source data, 2) transform data in the pipeline on a row-by-row basis, or 3) build a custom data flow destination.  In part one we looked at two examples for using it as a source.... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Get messages while the batch is running. Coming back to data warehousing in July 2009 has been a lot of fun for me. I haven’t done this stuff since I left Transamerica Life in 2005 I think it was, and realize that I enjoy working with facts, dimensions, etc. designing and building data marts and wa... [More]

Posted in: TSQL , SQLServerPedia  Tags:
admin posted on March 24, 2010 06:14
I wonder if it worked?  Great idea :)     Check out this article [1] on Gizmodo. Hilarious!  I hope he dropped all of the tables in the database, frankly.  LOL.  Come to think of it,  I'm gonna try it out on the President Bush Turnpike in Dallas next time I'... [More]

Posted in: Etc. (Off-topic) , SQLServerPedia  Tags:
Lee posted on March 23, 2010 12:11
One thing that I have not done lately is delve into all of the cool SQL Server 2005-2008 features that are targeted for administrators as much as I would like;  although my roles lately have been centered on our around development and SSIS, I still try to remain knowledgeable, because my next g... [More]

admin posted on March 20, 2010 18:22
About 6 months ago, SQL Server magazine (SQLMag.com) came out with a list of free downloads for SQL Server; it included both totally free as well as trial downloads, all of which were lots of neat third party add-ins for SQL Server.  I thought it would be cool to review a bunch of them to see w... [More]

Posted in: SQL Server 2008 , TSQL , .Net  Tags:
admin posted on March 20, 2010 10:49
Experimenting with the CultureInfo class I found a thread on SSIS and References, in particular culture info using System.Globalization in c# on the internet...said that it didn't work with SSIS. And at this point, I agree. I've been dorking with this thing yesterday afternoon and this morning and ... [More]

Posted in:   Tags:
admin posted on March 18, 2010 22:30
Geeking with INFORMATION_SCHEMA. Information schema views are very handy. Books online describes these views as follows: Information schema views provide an internal, system table-independent view of the SQL Server metadata. Information schema views enable applications to work correctly althou... [More]

Posted in: SQL Server 2008 , TSQL  Tags:
Gonna get trained! I received an invite the other day to a SQL Server 2008 Fast Track Data Warehousing Technical Training Workshop over at the MTC – Microsoft Technology Center in Irving, TX. Sounds pretty cool, so I said sure thing…I always enjoy gorging myself with cookies and coffee for a few da... [More]

Posted in:   Tags:
Nice slide deck on replication from SQL Saturday #33.    I try to sift and sort through the MSDN blog postings for the readers of this site and give a 'best of' each week, and this week is from the http://blogs.msdn.com/chrissk/default.aspx; he has posted a blog on replication ... [More]

admin posted on March 12, 2010 12:59
Just geeking with nothing.    We have NULLs and empty strings in TSQL, but I should explore nothing more than I have. What's nothing you say?  I'm not sure, it's sort of tough to describe.  Run the following    SELECT   id FROM sys.sysobjects WHER... [More]

Posted in: TSQL  Tags:
admin posted on March 10, 2010 17:26
I learn something every day. Perusing the MSDN blogs, I noticed a cool one by Joe Sack that I wanted to make note of here... it doesn’t appear that Joe blogs a whole lot, but when he does, it’s usually worth reading.  This time he writes about the TSQL command ALTER INDEX REBUILD ... [More]

Posted in: The Best of MSDN Blogs , TSQL  Tags:
Lee posted on March 10, 2010 12:24
Check out the courses at NLC. I had a meeting with the person who runs the scheduling up at North Lake College last weekend, where I teach on a part-time basis, and we came to the conclusion that most of the interest right now in SQL Server is either in BI or TSQL.  Because of this we’ve decid... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on March 7, 2010 09: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 10: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:
Interesting blog by the SQL Customer Advisory Team This week’s MSDN Blogs category found me on the SQLCat site reading about enabling partition-level locking in SQL Server 2008.  I’ve never heard of this “hidden” feature, so it sounded cool. Essentially what they did was demonstrate a method... [More]

Posted in: The Best of MSDN Blogs  Tags:
I love these etc. posts. I've oftentimes describe myself as an inventor, because I invent all kinds of things. I like inventing things, such as words.  You are probably an inventor yourself when you think about it. When I come up with a new cool word I check the highly-respected www.urbandi... [More]

Posted in:   Tags:
Well, this one is a "non-feature" to me A buddy of mine came up to me today and goes, "Hey man, I scripted this proc out and the syntax is red".  (He's a Cognos guy, and not a SQL Server guy).  I said, "Yeah, some Einstein wraps everything around an sp_executesql ... [More]

Posted in: Etc. (Off-topic)  Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
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 2012 Lee Everest's SQL Server, etc. weblog