Viewing 15 posts - 196 through 210 (of 245 total)
chrisn-585491 (8/15/2013)
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 15, 2013 at 9:47 am
wolfkillj (8/14/2013)
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 14, 2013 at 9:13 am
This conundrum has always been one of my favorites. Apply the patches to keep your systems secure but potentially break something, or leave yourself vulnerable while testing patches (or...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 13, 2013 at 8:26 am
CSV files can also alleviate some headaches from newer versions of Excel, which don't always play so well with SSIS 2005.
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 12, 2013 at 5:45 am
Seems there's a little confusion (or else I'm confused).
As I understand it, checkpoint file usage is set in the Control Flow Properties sheet. Then you set the FailPackageOnFailure to...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 7, 2013 at 6:44 am
I'll admit I'm mostly ambivalent about the newsletter change, though I prefer the older version only because it was easier on the old eyeballs.
And I must admit I'm not all...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 5, 2013 at 8:35 am
I'll add one that's so obvious it's easy to miss:
PLAY
Speaking as one who is living proof you can learn and improve SQL Server skills on the cheap, one of my...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 5, 2013 at 8:18 am
In SSIS, I assume you have some DATEADD, DATEDIFF, CAST functions you can use. Or put this query in your task.
SSIS does have DATEADD(), DATEDIFF(), and DATEPART() as well as...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 2, 2013 at 6:29 am
In view of the coming big data/data analytics wave, I'm working my way through a book on calculus. I took an online Statistics class sponsored by Univ of Toronto...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
August 2, 2013 at 5:57 am
My boss related a story about some software he was troubleshooting in a call center. I don't recall if he developed it, but every so often the entire system...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 31, 2013 at 5:55 am
Be it article or editorial, it's still a good summarization of the "third wave" so to speak of the database world. Right now the role of the data scientist...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 30, 2013 at 6:04 am
If you check BOL, the OnPostExecute event fires after an executable finshes running. An error causes an executable to finish running.
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 25, 2013 at 6:02 am
2103? Lowell: You're ahead of your time. 🙂
Also, it should be DATEPART(hh,PIT) <> 12 in the second part of the WHERE condition.
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 24, 2013 at 6:17 am
You could use a Script Task to check for a valid connection before your Data Flow and then take different actions depending on the result. For example a Success...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 19, 2013 at 7:01 am
I was thinking SSDT, too.
Software updates in general seem to be driven more by marketing and perception than anything else, and don't EVEN get me started on version numbers. ...
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 19, 2013 at 5:46 am
Viewing 15 posts - 196 through 210 (of 245 total)