Lee posted on February 8, 2010 16:40
This is what you do when you're bored. I saw a post on www.social.msdn.com about Excel data sources and SQL Server Integration Services (SSIS) that was answered by two folks, and not particularly correct by either one I might add. Someone asked a two-part question - the first was… “How... [More]

Posted in: SQL Server 2008 , SSIS  Tags:
Lee posted on February 3, 2010 07:20
New blog out on MSDN.   There is a new blog out on the MSDN SQL Server blogs called “REPL TALK” that I stumbled across the other day, and wanted to share the link:  http://blogs.msdn.com/repltalk/default.aspx. This might be a great venue to shoot a question over to a member o... [More]

Posted in: The Best of MSDN Blogs  Tags:
Admin posted on February 2, 2010 04:21
Looks like a cool presentation. I got notice yesterday of the SQL Server 2008 R2 Airlift presentation - seems like it would be very informative, although I have no idea what companies will be the first to bite on a system such as the "Madison" initiative.  Quite expensive, brand new, and unpr... [More]

Posted in:   Tags:
admin posted on January 31, 2010 09:50
Wiring-up to Excel can be a pain. This might help. Here's a screencast that might assist you in connecting to Excel in Microsoft SQL Server Integration Services.  Give it a try next time you have to go to an Excel data source.   Lee   ---------------------------- His name is Jas... [More]

Posted in: SQL Server 2008 , Video , SSIS  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 26, 2010 10:39
SQL Server 2008 R2 goodies are starting to rolling out. I was just looking around this weekend and noted all of the SQL Server 2008 Webcasts, virtual labs, etc. that have come out over the past few months; today I saw a post on the MSDN Blogs about some just coming out this week in fact, where... [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:
Good stuff courtesy of Microsoft!   Buck Woody, a program manager at Microsoft, had a blog over on the MSDN about the activity monitor, and a cool little feature that it has.  Check it out here: http://blogs.msdn.com/buckwoody/archive/2010/01/21/hovering-over-the-titles-in-activity-mon... [More]

Posted in:   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:
Lee posted on January 19, 2010 19:58
Understanding checkpoint files In the last blog on checkpoint files, I was dorking with and investigating their contents, looking to answer the question of whether or not variables were persisted within the process.  You would think they would; after all, if a task craps out, and the next task... [More]

Posted in: SQL Server 2008 , SSIS  Tags:
Lee posted on January 17, 2010 19:35
Congrats Tim! Just wanted to give a shout out and a congrats to Tim Mitchell on being nominated as a Microsoft SQL Server MVP. Way to go Tim!  Tim is a fellow-Texan who is an excellent DBA and trainer.  It is very apparent to anyone that follows his work that he goes above and beyond the ... [More]

Posted in:   Tags:
Lee posted on January 17, 2010 19:20
Everybody else is probably doing it wrong, too. Buck Woody posted a blog on SQLBlog.com requesting input to designing databases.  It might be an interesting way to share, compare, and study they way others go about creating entities and their attributes, and enlightening the pros and co... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on January 13, 2010 19:01
A peek inside a checkpoint file…good stuff. Someone asked me the other day whether user variables were somehow preserved when using SSIS checkpoints in SQL Server.  I honestly couldn’t answer, because I really haven’t used checkpoints that often.  Many of the SSIS packages that I have b... [More]

Posted in:   Tags:
admin posted on January 13, 2010 04:05
We’re losing ground…    Jamie Thomson, a SQL Server MVP, the original “SSIS Junkie”, and sometimes visitor on this site, wrote an interesting blog entitled “The SQL Developer Gap (Warning: rant coming up)” on some of the things that he sees in SQL Server with respect to other Microsoft t... [More]

Posted in:   Tags:
Lee posted on January 10, 2010 07:09
Stay up to date, or get left behind. I’m still amazed that this 3-year release cycle is still going according to plan with regards to SQL Server and Windows.  I wonder sometimes if Microsoft even knows how many huge, global companies are still on SQL Server 2000!  Here’s a l... [More]

Posted in: The Best of MSDN Blogs  Tags:
Just noticed that Bigint has been fixed in SSIS 2008 I mentioned the other day that I am in the beating as it is of a project with SSIS 2005.  Funny that about the time I blogged, a friend who I worked with on a large project put in his MSN messenger sigline..."SSIS 2005 can be described as ... [More]

Slick new feature to make INSERT go faster.   Check out my screencast on the minimally logging using INSERT SELECT in SQL Server 2008. Click the “Fullscreen view” button at bottom right of applet to expand the video image.  Code files, below. Lee   &... [More]

Posted in: SQL Server 2008 , Video  Tags:

by Lee Everest, M.S.

Search


Ads

Calendar

«  February 2010  »
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
1234567
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