Lee posted on March 10, 2010 10: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 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:
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:
Great post on creating SQL counters. Found a nice post on the MSDN blogs by Jay on how to create a custom perfmon counter for SQL Server.  Good stuff!  I’ve always wondered about this back to, oh, SQL Server 7.0 at least, but I never knew how to create one and really didn’t have a reaso... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on February 10, 2010 15:54
More things for your consideration. A couple of more things for now (since I’m still bored). In Figure 1,  do you notice anything different here in my list from yours (I’ve right-clicked on a random table): Figure 1. Table right click shortcut of commands menu Right on. I’ve changed m... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on February 9, 2010 16:19
IDENTITY discussion...again. Check out Aaron Bertrand's blog on the bad habits of haphazardly throwing IDENTITY attribute on a numeric field and calling it a primary key at http://sqlblog.com/blogs/aaron_bertrand/archive/2010/02/08/bad-habits-to-kick-putting-an-identity-column-on-every-table.aspx.&... [More]

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

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