February 17, 2016 at 9:54 am
Steve Jones - SSC Editor (2/17/2016)
On one hand, I'm glad I no longer code in C, on the other hand, lots of work available: http://arstechnica.com/security/2016/02/extremely-severe-bug-leaves-dizzying-number-of-apps-and-devices-vulnerable/
WOW. That is going to take a long time to unravel from the sounds of it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 18, 2016 at 6:39 am
Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by now.
You all have a great day.
February 18, 2016 at 7:28 am
djj (2/18/2016)
Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by now.You all have a great day.
Maybe people had to actually get some work done. No, that can't be it. :hehe:
February 18, 2016 at 9:43 am
Work, what's that? :w00t:
February 18, 2016 at 10:15 am
Lynn Pettis (2/18/2016)
Work, what's that? :w00t:
Seeing as your employer is the same as my employer (or at least I think it is,) that's what people in the "real world" do to earn a paycheck.
:hehe::-P
February 18, 2016 at 10:19 am
Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going to start testing in a couple months. I just found out that the system which is the source data for this ETL is being upgraded to a new version "in a couple months". This is not a minor upgrade. It is a whole new set of servers and they changed the entire engine and database structure that drives the whole thing. I am now in a hover pattern until this new version is installed so I can throw away 6 of the last 8 weeks of effort. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 18, 2016 at 12:06 pm
Sean Lange (2/18/2016)
Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going to start testing in a couple months. I just found out that the system which is the source data for this ETL is being upgraded to a new version "in a couple months". This is not a minor upgrade. It is a whole new set of servers and they changed the entire engine and database structure that drives the whole thing. I am now in a hover pattern until this new version is installed so I can throw away 6 of the last 8 weeks of effort. :w00t:
Team building exercise?
Character building exercise?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 18, 2016 at 12:15 pm
Sean Lange (2/18/2016)
Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going to start testing in a couple months. I just found out that the system which is the source data for this ETL is being upgraded to a new version "in a couple months". This is not a minor upgrade. It is a whole new set of servers and they changed the entire engine and database structure that drives the whole thing. I am now in a hover pattern until this new version is installed so I can throw away 6 of the last 8 weeks of effort. :w00t:
/me in best Marty Feldman voice
Could be worse...
They could've told you a couple months from now that they were upgrading to a new version.
😉
February 18, 2016 at 12:23 pm
SQLRNNR (2/18/2016)
Sean Lange (2/18/2016)
Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going to start testing in a couple months. I just found out that the system which is the source data for this ETL is being upgraded to a new version "in a couple months". This is not a minor upgrade. It is a whole new set of servers and they changed the entire engine and database structure that drives the whole thing. I am now in a hover pattern until this new version is installed so I can throw away 6 of the last 8 weeks of effort. :w00t:Team building exercise?
Character building exercise?
This is SOP around here. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 18, 2016 at 1:37 pm
No need to pile on (in fact, please don't) but the post below reminds me of the interviews that I've conducted over the last decade. The problem is, it's actually getting worse. It's really getting to be a much more prevalent and totally disgusting fact of life and I refuse to "give in" to it on interviews.
http://www.sqlservercentral.com/Forums/Topic1761876-3077-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
February 18, 2016 at 1:47 pm
I had to resist giving this poster truly horrific advice: http://www.sqlservercentral.com/Forums/Topic1762515-2799-1.aspx
I was so, so tempted to tell him something like "stop the SQL Server service, then delete the log file!"
I'm a horrible, horrible person, aren't I?
February 18, 2016 at 1:48 pm
Jeff Moden (2/18/2016)
No need to pile on (in fact, please don't) but the post below reminds me of the interviews that I've conducted over the last decade. The problem is, it's actually getting worse. It's really getting to be a much more prevalent and totally disgusting fact of life and I refuse to "give in" to it on interviews.http://www.sqlservercentral.com/Forums/Topic1761876-3077-1.aspx
It's scary to hear that things are getting worse. I haven't had to conduct an interview for five years now. But five years ago, the overwhelming majority of the people I interviewed were not qualified to the level that they thought they were. It's creepy how people can get 6-9 months of experience and then multiply that out to 5 years and think they actually have 5 years of experience.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 18, 2016 at 2:10 pm
jasona.work (2/18/2016)
Lynn Pettis (2/18/2016)
Work, what's that? :w00t:Seeing as your employer is the same as my employer (or at least I think it is,) that's what people in the "real world" do to earn a paycheck.
:hehe::-P
Work is something I've done a good job of avoiding while on vacation. It's been a genuine pleasure to only get online to check the thread and not much else. My phone hasn't rang once and the only texts I've received have been about dinner reservations. Add to that the fact that I've been in sunny Florida wearing shorts in 75 F weather and it's been a truly awesome week. My daughter has more memories to last a lifetime. I need more relaxing weeks like this in my life.
February 18, 2016 at 2:12 pm
Sean Lange (2/18/2016)
SQLRNNR (2/18/2016)
Sean Lange (2/18/2016)
Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going to start testing in a couple months. I just found out that the system which is the source data for this ETL is being upgraded to a new version "in a couple months". This is not a minor upgrade. It is a whole new set of servers and they changed the entire engine and database structure that drives the whole thing. I am now in a hover pattern until this new version is installed so I can throw away 6 of the last 8 weeks of effort. :w00t:Team building exercise?
Character building exercise?
This is SOP around here. 😉
Knowing what I know about the ERP you're working with, my condolences, Sean. If memory serves regarding the one of those I had to go through with that system, your base tables won't change but your data types will. I guess they call that "job security" for the people who do the work. I called it a huge pain. Best of luck, sir.
February 18, 2016 at 2:51 pm
Ed Wagner (2/18/2016)
Sean Lange (2/18/2016)
SQLRNNR (2/18/2016)
Sean Lange (2/18/2016)
Just kill me now. I have been working on a pretty large and complicated ETL process for the past couple months to support our new ERP that we are going to start testing in a couple months. I just found out that the system which is the source data for this ETL is being upgraded to a new version "in a couple months". This is not a minor upgrade. It is a whole new set of servers and they changed the entire engine and database structure that drives the whole thing. I am now in a hover pattern until this new version is installed so I can throw away 6 of the last 8 weeks of effort. :w00t:Team building exercise?
Character building exercise?
This is SOP around here. 😉
Knowing what I know about the ERP you're working with, my condolences, Sean. If memory serves regarding the one of those I had to go through with that system, your base tables won't change but your data types will. I guess they call that "job security" for the people who do the work. I called it a huge pain. Best of luck, sir.
Thanks Ed. Actually this one is going the other direction and the upgrade is to a third party system. I am actually extracting data from the ERP for this system where they have their own ETL process to pick up data from some staging tables and massage it into their own version of insanity. But the pain is the same either way. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 52,786 through 52,800 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply