admin posted on March 10, 2010 15: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 ... [More]

Posted in: The Best of MSDN Blogs , TSQL  Tags:
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:
admin posted on March 6, 2010 08: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:
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:
admin posted on February 21, 2010 12: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 14: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 16: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 04: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 10: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:
admin posted on February 14, 2010 03:59
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. Truth be told,... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  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