admin posted on January 31, 2010 11: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 , Vids , 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]

Posted in: SQL Server 2008 , SQLServerPedia , TSQL  Tags:
Lee posted on January 26, 2010 12: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 10: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 , Vids  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 08: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 21: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 21: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 21: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 cons on t... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on January 13, 2010 21: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 06: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 09: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 , Vids  Tags:
admin posted on January 1, 2010 08:42
Thanks for visiting the site! It’s been a great year, and will be an even better one in 2010. I want to thank you for your support, emails, and visits over the past year. Traffic is way up, and I have enjoyed jotting down my experiences in SQL Server.  As always, I will con... [More]

Posted in:   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