admin posted on March 18, 2010 20:30
Geeking with INFORMATION_SCHEMA. Information schema views are very handy. Books online describes these views as follows: Information schema views provide an internal, system table-independent view of the SQL Server metadata. Information schema views enable applications to work correctly althou... [More]

Posted in: SQL Server 2008 , TSQL  Tags:
Gonna get trained! 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 cookies and coffee for a few da... [More]

Posted in:   Tags:
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:
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:
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:
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:
admin posted on February 13, 2010 07: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:
Admin posted on February 2, 2010 04: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:
admin posted on January 31, 2010 09: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 , Video , SSIS  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