Lee posted on February 28, 2010 11: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 12: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 21: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 21, 2010 14:04
Want to chat about SQL Server? Join my group!   Join my blog group on Facebook, and let's chat, discuss blog postings, and share thoughts on Microsoft SQL Server.  Comment on the posts from this site, other blogs, or add new information of interest. Click the below image and join –... [More]

Posted in: Etc. (Off-topic)  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:
admin posted on February 20, 2010 16: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 19, 2010 18:36
Great posting by Jeff Atwood! Heads up, everyone - every day is International Backup Awareness Day!!! So a buddy of mine today at lunch goes "Hey man, you backed up your blog lately?"  I says, "naaa, my hosting company does all of that, right??. Uh, wrong.  I go out to m... [More]

Posted in:   Tags:
admin posted on February 19, 2010 06:06
Doesn't appear to be fixed! I thought that in SQL Server 2008 sp1, the ORDER BY bug was fixed, but it isn't. We ran into it yesterday.  http://support.microsoft.com/kb/926292.  Scanning the sp1 fix list, apparently this one wasn't added to it: http://support.microsoft.com/kb/968369. ... [More]

Posted in: SQL Server 2008  Tags:
Admin posted on February 17, 2010 12:58
Cool. But want real performance? Get one of these… I saw a blog by Paul Nielsen today on putting tempdb in ram via the software ram download called RamDisk. Actually this is pretty cool!  I’ve never seen it before, but it looks like something i’d like to geek with. Essenti... [More]

Posted in:   Tags:
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. Tr... [More]

Posted in: SQL Server 2008 , SQLServerPedia , SSIS  Tags:
admin posted on February 13, 2010 09:44
Check it out for some good stuff. The SQL Server Evangelism Team has released a free download for developers that might be helpful on the new stuff in SQL Server 2008 R2. Go to their page at http://blogs.msdn.com/usisvde/archive/2010/02/09/free-bi-developer-training-kit-for-sql-server-2008-r2-re... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on February 10, 2010 17: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 18: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 18: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 09: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 06: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:

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