Interesting question about parameters. My good friend and super-stealth ninja middle-tier, business objects, BLL, DAL, bad*ss programmer Craig Boland asked me a question the other day about an oddity with stored procedures and functions. Eh, whassat you say? What’s a super-stealth ninja middle-tier... [More]

SSIS 2005 errors...glad many go away with SSIS 2008   It’s amazing to me on just how much better, nicer running, and less clunky SQL Server Integration Services (SSIS) 2008 is over its’ SQL Server 2005 counterpart. Every time I (have to) open it up – usually because client v... [More]

Posted in: SQL Server 2005 , SSIS  Tags:
Verifying our results.   I received an email the other day from Kevin Stephenson, a SQL Server guru from the Microsoft SQL Server Customer Advisory Team, SQLCAT, who prompted my interest in the “Deleting Data Quickly…” series of blogs found on this site. Kevin mentio... [More]

admin posted on October 8, 2009 09:34
A million lists out there, this one isn't too bad. As I embark on my new project, before starting the SSIS stuff, I am building control tables. The client uses a series of tables and switches to drive data warehouse loads, so I need to change the names of attributes in these tables before pointin... [More]

admin posted on August 18, 2009 20:01
Kind of a slow news week, but whatcha gonna do? If I had to vote, I’d say that my favorite keyboard shortcut in SQL Server Management Studio (SSMS) is, by far… CTL + ALT + R.  This little gem opens a browser window in a separate tab; works perfectly for my exchange mail connection because... [More]

Lee posted on August 8, 2009 22:22
I’ve always enjoyed dorking with NULLs. Couple of new ones.  I wrote an article a few years back entitled Nulls and Related Oddities. I think it was published by SQL Server Standard, the hard copy magazine that used to be published by the SQLServerCentral.com folks. It was a pretty good re... [More]

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