I wonder if this is Super High Intensity Training? I received an invite the other day to a SQL Server 2008 Fast Track Data Warehousing Technical Training Workshop over at the MTC – Microsoft Technology Center in Irving, TX. Sounds pretty cool, so I said sure thing…I always enjoy gorging myself with... [More]

Posted in:   Tags:
Nice slide deck on replication from SQL Saturday #33.    I try to sift and sort through the MSDN blog postings for the readers of this site and give a 'best of' each week, and this week is from the http://blogs.msdn.com/chrissk/default.aspx; he has posted a blog on replicatio... [More]

admin posted on March 12, 2010 10:59
Just geeking with nothing.    We have NULLs and empty strings in TSQL, but I should explore nothing more than I have. What's nothing you say?  I'm not sure, it's sort of tough to describe.  Run the following    SELECT   id FROM sys.sysobjects WHER... [More]

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

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