Most of MSDN blogging was shut down last week for a site upgrade, but I happened across this one that I thought was interesting.  Apparently for all versions of SQL Server (beginning 2005) there's a problem with expanding the transaction log: whenever the difference between the new size and... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on May 30, 2010 10:30
Excitement abound. Tidbits on my Memorial Day Weekend 2010...no I don't Twitter, so I'll just use this forum: Sleeping on the couch - Made it through Friday night sleeping on a couch. I'm having foundation (re)work done this week; for those living in N. Texas, you know what I'm talking about.... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on May 27, 2010 13:28
Thoughts on some of the latest items removed. Perusing the list here are a few notable ones for me.  We can’t let these go by without a commentary on my favorites, so enjoy! Features not in the next version 1) Compatibility level 80 – Finally after ten years we’re getting away from SQL Serve... [More]

Posted in: SQL Server 2008 , SQLServerPedia  Tags:
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:
Lee posted on May 25, 2010 10:58
Just geeking some more.  There are a few caveats to using SELECT INTO, the singleton-select statement that is used often for fast loading data and creating a copy of a table on the fly. First off, it doesn’t create an exact copy of your source table. Indexes, constraints, defaults, computed co... [More]

Posted in: TSQL  Tags:
Lee posted on May 23, 2010 10:12
SQL Server 2005 BIDS error that I got last week. You might get the following error using SSIS 2005 when connecting, using an OLE DB Source: There was an error displaying the preview. Additional information: Index and length must refer to a location within the string. Parameter n... [More]

Posted in: SSIS , SQL Server 2008  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:
Lee posted on May 17, 2010 21:19
One of those… “Best features you’ll never see”. I love reading the blogs from SQLCat (SQL Server Customer Advisory Team) and from the SQL Server Storage Engine group; any time you can get information from the guys and gals that work with the internals is worth stopping to take note.  One po... [More]

Posted in: The Best of MSDN Blogs  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:
INTRODUCTION The folks at SQL Cat (SQL Customer Advisory Team) post some really great stuff, and had a blog a couple of months back [1] on partitions and locking.  I haven’t played much with partitions yet in SQL 2005 or 2008 -  haven’t really had a need to up to this point, and haven’t r... [More]

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

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