February 13, 2009 at 11:38 am
That just bout answer it... open straight in BOL...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d33985f7-1048-4023-83e4-274090acda78.htm
UPPER (SSIS)...
February 13, 2009 at 11:39 am
Ninja's_RGR'us (2/13/2009)
That reminds me of those 2 procs... hoping you don't need to use them anytime soon :exec sp_update_resume
exec sp_distribute_resume
If it was in my company and something like this happened, then I will surely need to use those two procs. I think I will have to let everyone in the IT company execute that.:D
-Roy
February 13, 2009 at 11:43 am
Ninja's_RGR'us (2/13/2009)
That just bout answer it... open straight in BOL...ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d33985f7-1048-4023-83e4-274090acda78.htm
UPPER (SSIS)...
Sad more than anything. Can't believe someone could take so much time working out a solution that already exists in a function BUT I'm sure it happens all the time. I do know that I would feel really STUPID if that was me presenting only to find that out. OUCH! Can you imagine? Laughing as I think about it. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 11:45 am
Most of the DBA folk I have worked with came from non-computer science educational backgrounds. Our current DBA at my place of employment is a cartographer by training. My degree is in psychology. When I left college, all I was really qualified to do was to shock rats, so naturally I became a DBA. 😛
It does take a particular mindset to be good at this work: curiosity, analytical thinking skills, a willingness to experiment, a smattering of non-linear thinking, and, eveidently, a deeply seated love of sarcasm.
I've been doing management stuff for the last 3 years and I hope to get back into the technical arena before too long. My boss keeps telling me I should use all I learned about psychology when dealing with my staff. I tell him they won't stand still long enough for me to attach the electrodes to their legs.
February 13, 2009 at 11:50 am
Well, My BS degree is a dual major in Computer Science and Business Administration and my MA is a dual major in Computer Information Resource Management and Space Systems Management (that means satellites and such).
Oh, I have been involved with computers and programming since 9th grade. I love working with them, but I'm not a hacker.
February 13, 2009 at 12:27 pm
I have a BA with lots of BS on the side 😛
February 13, 2009 at 12:39 pm
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
I don't know about that. Here's a thread with links to about a 100 examples that are just as bad.
It's dead, Jim
February 13, 2009 at 1:22 pm
Well I earned a BS (Mechanical Engineering) and while working as a development engineer I had problems having my budgets being approved by the bean counters. So as a defensive measure I earned a MBA (Master of Business Administration - or in the vernacular More Bull S**t A**hole)so as to prepare for the bean counters a financial analysis favorable to their granting my request. My assumption that the bean counters being over worked would except without question my budget requests proved to be true. And away I went designing rocket engines, that's right I was as many scathingly said a "rocket scientist" . This design work was my introduction to computers specifically an IBM 901 - darn am I giving away my age ... shhh tell no one, but heck it was better than using a slide rule to do the calculations.
Should anyone here be curious my one claim to engineering fame is know in the following link as the "thermo-jet torch".
http://www.stonemountainpark.com/outdoors-recreation/outdoor-detail.aspx?AttractionID=486
If you are ever in the Atlanta Georgia area, visit the park and see the carving, it is well worth the parking fee.
February 13, 2009 at 1:33 pm
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspxI don't know about that. Here's a thread with links to about a 100 examples that are just as bad.
It's dead, Jim
After reading the thread there, seems like the SSC team are angels when dealing with irritating posters.:P The Sql team people can be really mean... 🙂
-Roy
February 13, 2009 at 2:49 pm
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspxI don't know about that. Here's a thread with links to about a 100 examples that are just as bad.
It's dead, Jim
After reading the thread there, seems like the SSC team are angels when dealing with irritating posters.:P The Sql team people can be really mean... 🙂
A testament to the professionalism of the founders and those that call SSC home.
February 13, 2009 at 3:03 pm
Lynn Pettis (2/13/2009)
A testament to the professionalism of the founders and those that call SSC home.
Very much agreed! 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 13, 2009 at 3:40 pm
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspxI don't know about that. Here's a thread with links to about a 100 examples that are just as bad.
It's dead, Jim
After reading the thread there, seems like the SSC team are angels when dealing with irritating posters.:P The Sql team people can be really mean... 🙂
I don't know about generalizing like that, especially since a lot of the regulars post in both places.
Peter Larsson's 22,000 plus posts on SQL Team are a record of the most understanding and patient posts ever dealing with some of the most irritating people that ever posted on the internet.
SSC people have shown they plenty of mean available when it's called for, and sometimes when it isn't.
February 13, 2009 at 3:54 pm
Michael Valentine Jones (2/13/2009)
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspxI don't know about that. Here's a thread with links to about a 100 examples that are just as bad.
It's dead, Jim
After reading the thread there, seems like the SSC team are angels when dealing with irritating posters.:P The Sql team people can be really mean... 🙂
I don't know about generalizing like that, especially since a lot of the regulars post in both places.
Peter Larsson's 22,000 plus posts on SQL Team are a record of the most understanding and patient posts ever dealing with some of the most irritating people that ever posted on the internet.
SSC people have shown they plenty of mean available when it's called for, and sometimes when it isn't.
I'll agree to a point. I think Steve gets involved when things get a little heated. I have read some pretty nasty things on both sites, but I've seen Steve remove inappropriate posts from this site that have been allowed to stay publicly visible on other forum sites. Again, goes to the professionalism of the founders and those who call SSC home.
February 13, 2009 at 4:52 pm
Thanks, Lynn, hopefully we'll meet in person soon.
February 13, 2009 at 10:27 pm
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
When I saw his question, I couldn’t believe that he didn’t do any backup of his production database for 5 months. I thought that maybe he did have a backup routine that backed up the database every day without init to the same file. When you do that, you get one backup file that holds lots of backup sets in it and when you restore the database you need to specify which backup set you want to restore. If you don’t specify SQL Server will take the first (and oldest) backup in the file. That was the reason that I asked him to check if he has some newer backups. Maybe it sounds strange, but I did find it easier to believe that the poster made the mistake that I just described, then believing that he simply didn’t backup a production database for 5 months.
I noticed that many people write about the importance of backing up the databases. For some reason, I hardly see remarks about importance of testing the restore procedure. I started working as a DBA with SQL Server 6.5. Each day I used to check that the backup jobs succeeded. When service pack 5 for SQL Server 6.5 was released, I installed it on one of our dev machines. The next day I was asked to restore a database on that machine, but the restore operation failed. It turned out that the service pack damaged the backups that were done with the maintenance wizard and Microsoft had to release service pack 5A. I was just a beginner at that time and made few mistakes. Today I have a different procedure to install service packs, I hardly use the maintenance wizard, but the most important lesson that I’ve learned was to try and test the restore procedure from time to time. Doing so did save few databases (and few asses?) in the past.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 15 posts - 1,336 through 1,350 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply