admin posted on May 25, 2010 11:22
Movin’ on up!  I found this link on one of the MSDN blogs, but I can’t give any credit to whoever posted it because I didn’t bookmark it and MSDN is changing up their blogs right now.  Going to new software or whatever. Anyway, here’s a link that I wanted to share – I’m going to upgrade m... [More]

Posted in: SQL Server 2008 , SQL Administration  Tags:
admin posted on May 23, 2010 08:03
A smashing success! I certainly enjoyed my time at SQLSaturday and thought that the team, including Sri Sridharan, president of the North Texas SQL Server Users Group, did an excellent job putting it together.  From all accounts that looked like a tremendous amount of work to pull off such a... [More]

Posted in: Etc. (Off-topic) , SQLServerPedia  Tags:
A tutorial on the Script Component, continued. Introduction The thrilling conclusion to my three-part series is upon us!  Actually the series isn’t terribly thrilling, nor is this part all that interesting. (Well, it’s alright I guess, but nothing earth-shattering.  This is because if ... [More]

Posted in: SSIS , SQL Server 2008 , SQLServerPedia  Tags:
admin posted on May 12, 2010 19:54
Here's my list of what needs to go. Ok, everyone seems to be creating a list of five things that SQL Server should get rid of, so I'll do one of those as well.  (I already did a "five things that SQL Server needs", but apparently I jumped the gun on that one. Oh well). ... [More]

admin posted on May 11, 2010 20:44
Here's my list...enjoy! Super-stealth DBA/SSIS expert Jamie Thomson came up with a great list entitled "Five things SSIS should drop", and Aaron Bertrand offered the blog "5 things SQL Server should drop"; I thought I'd throw in my .02 cents and give my own list...Five... [More]

Posted in: SQLServerPedia , Etc. (Off-topic)  Tags:
SSIS-related posts getting the most traffic by far. I was looking at Google Analytics the other day on my blog and wanted to know what topics and pages generate the most traffic;  I sort of had a good idea but wanted to verify by checking over the past year or so. Here’s the list of the top fi... [More]

Posted in: SSIS , SQLServerPedia  Tags:
About a year or so ago, SQL Server Magazine (SQLMag.com) came out with a list of free downloads for SQL Server [1]; it included both free as well as trial downloads, all of which were neat third party add-ins for SQL Server.  I thought it would be cool to review a bunch of them to see which one... [More]

Posted in:   Tags:
Just in case you have to. Some Einstein on another team decided to switch all of his surrogate IDs from integer to DECIMAL (38,0) in his table.  Brilliant.  Wait what?  Why on earth someone would do this I have no idea. Maybe we all need to find out what he/she is smoking and get som... [More]

Posted in: SSIS  Tags:
About a year or so ago, SQL Server Magazine (SQLMag.com) came out with a list of free downloads for SQL Server [1]; it included both totally free as well as trial downloads, all of which were lots of neat third party add-ins for SQL Server.  I thought it would be cool to review a bunch of them ... [More]

Posted in: Etc. (Off-topic)  Tags:
Get signed-up! There are still openings (as of yesterday) for SQL Saturday #35 in Dallas.  Get to this link and join us, won’t you?  I hear that Joe Celko, Brian Knight, Jason Massie, Tim Mitchell, Sean McCown, and other top SQL Server MVPs and pros will be there, so it is surely going to... [More]

Posted in: TSQL  Tags:
admin posted on April 12, 2010 22:14
Interesting finding, I reckon. I see some posts on the internet about the cost of updating a column to itself; you might find a statement (or maybe you have used one) that looks like so: UPDATE TABLE SET id = ISNULL(@var,id) Essentially, if the variable is NULL, you update the column to itself... [More]

Error when redirecting a row in SSIS. This is a super-easy fix when you come across the following while trying to move error rows from an OLE destination in SSIS to a different destination: The error row disposition on “input “ OLE DB Destination Input” ()” cannot be set to redirect t... [More]

Posted in: SSIS  Tags:
admin posted on April 8, 2010 21:00
I found two interesting ones for this week. It's been kind of slow on MSDN site for SQL Server, not sure why.   By the way, ever wonder why, as I have, their blog site is running on Community Server and not Sharepoint? Not that I'm knocking Community or anything; on the contrary, it's o... [More]

Posted in:   Tags:
Ran across this one the other day. I was searching for something the other day on Google!, can’t remember what right now, and happened upon an old post [1] (old for the internet – 1998) entitled The EXISTS Flaw.  This referenced a C.J. Date from September, 1989 and his postulate on a flaw with... [More]

Posted in: TSQL , SQLServerPedia  Tags:
admin posted on March 29, 2010 10:52
A tutorial on the Script Component, continued. Introduction The Script Component allows you to 1) connect to source data, 2) transform data in the pipeline on a row-by-row basis, or 3) build a custom data flow destination.  In part one we looked at two examples for using it as a source.... [More]

Posted in: SQL Server 2008 , SSIS , SQLServerPedia  Tags:
Get messages while the batch is running. Coming back to data warehousing in July 2009 has been a lot of fun for me. I haven’t done this stuff since I left Transamerica Life in 2005 I think it was, and realize that I enjoy working with facts, dimensions, etc. designing and building data marts and wa... [More]

Posted in: TSQL , SQLServerPedia  Tags:
admin posted on March 24, 2010 06:14
I wonder if it worked?  Great idea :)     Check out this article [1] on Gizmodo. Hilarious!  I hope he dropped all of the tables in the database, frankly.  LOL.  Come to think of it,  I'm gonna try it out on the President Bush Turnpike in Dallas next time I'... [More]

Posted in: Etc. (Off-topic) , SQLServerPedia  Tags:

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
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