Lee posted on September 29, 2010 23:22
So I was chatting with a buddy of mine (Tom Davis from work, maybe about as good as they come DBA/Dev-wise, computer science guy with about 20 years experience in programming and database stuff) and he pointed out something kind of funny to me today.  Run my previous example from last year on t... [More]

Posted in: TSQL  Tags:
The guys and gals over at SQLCat - The SQL Server Customer Advisory Team – are some pretty cool cats.  Their latest blog is a good one…Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks.  In this effort they show that adding more tasks while doi... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on September 24, 2010 06:50
In the Microsoft SQL Server 2008 Feature Pack, whichever release that you may choose to download, one of the first mentioned is Microsoft ADOMD.NET.  The description for this part of the feature pack is as follows: Microsoft ADOMD.NET ADOMD.NET is a Microsoft .NET Framework object... [More]

Posted in: SQL Administration , SQL Server 2008  Tags:
Lee posted on September 22, 2010 23:08
Here's a new whitepaper that just came out extolling the virtues of virtualization for SQL Server 2008 R2 and Windows Server 2008 R2 and Live Migration, all the very latest and greatest from Microsoft.  I really need to read this, because I have a super-nice setup at home, but who knows if I ac... [More]

Posted in:   Tags:
Someone asked me the other day why SQL Server Management Studio (SSMS) scripts datetime data as binary. I told them I have no idea. Then they asked me whether or not the data would ‘port’ (geezsh we use that port word too much these days, don’t we?) to another server. Now, I didn’t laugh at while st... [More]

Posted in: SQL Administration , SQL Server 2008 , TSQL  Tags:
If you use the OLE DB Source, OLE connection manager, and Data access mode of “SQL command from variable”, you might get the following error: Command text was not set for the command object. What I’m guessing that you are trying to do is place TSQL in a table, use an Execute SQL Task to fetch y... [More]

Posted in: SQL Server 2008 , SSIS  Tags:
Lee posted on September 16, 2010 14:15
Not really a SQL Server product, but worth mentioning nonetheless, I move around from company to company as a consultant, usually 6 months to a year seems to be the average stay although I was at one place for almost two years. Normally when you get some place you have to set up your workstation wit... [More]

Posted in: Etc. (Off-topic) , SQL Server 2008  Tags:
Lee posted on September 13, 2010 21:18
You see, this is the type of blog that I like - showing why you do something such as choosing the correct data type along with a fact-based example proving the point. Great stuff!  In this blog, I think he's gonna lay a "mini-series" on us entitled "Advanced Performance Tuning&qu... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on September 12, 2010 22:40
I just got word from work that I won an iPad. Cool! I got it from my stellar performance, great personality, and overall just being a kick-ass dude and good guy.  Thank you very much!  Just kidding...none of the above actually. So, um, what do you do with an iPad anyway?  Things that... [More]

Posted in:   Tags:
Just dorking with XML for a bit, didn't you really abhor the old XML EXPLICIT back a few years ago?  I sure did, and we got it much better now.  Run the following: DROP TABLE ClassXML_Student, ClassXML_StudentCourse GO CREATE TABLE ClassXML_Student (StudentID int ,StudentFirst... [More]

Posted in: TSQL , SQL Server 2008  Tags:
Ran into a problem yesterday that I thought was worth mentioning...one of the former developers (a seasoned TSQL coder I might add) at the local gig where I'm stationed used a combination of greater than/less than for dates in their TSQL predicates without at least one being an equal to, really not ... [More]

Posted in: SQL Server 2008 , TSQL  Tags:
You may get this error when setting up database mail in SQL Server.  I blog about this because I never, ever set up mail, so thought that it might be handy for someone. Error message when trying to send SQL 2005 mail: No global profile is configured. Specify a profile name in the @profile_name... [More]

Posted in: SQL Administration  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