June 3, 2016 at 1:21 pm
Ed Wagner (6/3/2016)
Sean Lange (6/3/2016)
The end of this week is almost here. This is a major milestone week at our company. We have been working for over 2 years on implementing a new ERP system to replace our hideously out of date RPG system. Some you know the system we are going to and others do not. Suffice it to say that I am not a fan of the decision that was made to use the new system we chose. In fact, in many ways it is not any improvement at all and in other cases it is a MAJOR step backwards.Be that as it may the decision was made by people way further up in the pecking order than I am. We are going live on Monday with this new system at one of our remote locations. The rest of the company will be coming online over the next 6-9 months or so. It is quite nerve wracking to make such a complete systemic change while still attempting to maintain the business. My portion of the work and deployment has been done for awhile now but there are many people scrambling to finish everything up. Here is hoping that my phone doesn't ring in the middle of the night Sunday (our remote location is 6 hours ahead of me) and that Monday ends sometime before the rest of the world gets to next weekend.
Well, count me as one of those that know where you're going and offer my condolences on the topic.
So, people are scrambling to get things done today and you're supposed to launch one location on Monday? That doesn't sound like sufficient time for UAT or even proper validation. I don't envy the time you might have on Monday. I hope it doesn't happen, but I fear it will. Good luck, Sean.
I knew you would know!!! We have been in full UAT mode for several months. The system side of things seems to be solid....well as solid as the system we are using can be. Mostly they are scrambling to get data 100% squared away. Things like inventory counts and GL balances are difficult, it not impossible, to get situated well ahead of time. Honestly I don't think my Monday will be too bad as I can't actually directly influence any code or database stuff. It all has to go through their craptastic APIs and such. Even then, almost everything I can do has been done for months. We just get to see how much fun we can have next week.
_______________________________________________________________
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/
June 3, 2016 at 3:03 pm
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.Wait. Client tools are no longer an option to install with the rest of SQL Server?
That sucks.
I disagree, since I install them separately often. Plus, we'll see SSMS updated more often, and it needed to be decoupled from the install of the engine to allow this (from an org view, not technical view)
June 3, 2016 at 8:19 pm
Sean Lange (6/3/2016)
Ed Wagner (6/3/2016)
Sean Lange (6/3/2016)
The end of this week is almost here. This is a major milestone week at our company. We have been working for over 2 years on implementing a new ERP system to replace our hideously out of date RPG system. Some you know the system we are going to and others do not. Suffice it to say that I am not a fan of the decision that was made to use the new system we chose. In fact, in many ways it is not any improvement at all and in other cases it is a MAJOR step backwards.Be that as it may the decision was made by people way further up in the pecking order than I am. We are going live on Monday with this new system at one of our remote locations. The rest of the company will be coming online over the next 6-9 months or so. It is quite nerve wracking to make such a complete systemic change while still attempting to maintain the business. My portion of the work and deployment has been done for awhile now but there are many people scrambling to finish everything up. Here is hoping that my phone doesn't ring in the middle of the night Sunday (our remote location is 6 hours ahead of me) and that Monday ends sometime before the rest of the world gets to next weekend.
Well, count me as one of those that know where you're going and offer my condolences on the topic.
So, people are scrambling to get things done today and you're supposed to launch one location on Monday? That doesn't sound like sufficient time for UAT or even proper validation. I don't envy the time you might have on Monday. I hope it doesn't happen, but I fear it will. Good luck, Sean.
I knew you would know!!! We have been in full UAT mode for several months. The system side of things seems to be solid....well as solid as the system we are using can be. Mostly they are scrambling to get data 100% squared away. Things like inventory counts and GL balances are difficult, it not impossible, to get situated well ahead of time. Honestly I don't think my Monday will be too bad as I can't actually directly influence any code or database stuff. It all has to go through their craptastic APIs and such. Even then, almost everything I can do has been done for months. We just get to see how much fun we can have next week.
Well, if it's anything like the implementation I experienced with it's predecessor, you'll have a period of pain. The people involved need to remember that at the end of the day, it's about getting the work done. The missing parts will be discovered over time. Just discourage management from rushing to implement a solution that cripples other areas or creates "temporary" manual steps to resolve.
I'm glad to hear your stuff is done. I know some of what you went through to get it to perform well. I hope next week is painless.
June 3, 2016 at 8:20 pm
Steve Jones - SSC Editor (6/3/2016)
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.Wait. Client tools are no longer an option to install with the rest of SQL Server?
That sucks.
I disagree, since I install them separately often. Plus, we'll see SSMS updated more often, and it needed to be decoupled from the install of the engine to allow this (from an org view, not technical view)
It also helps developers have a simpler installation to update SSMS on their workstations.
June 5, 2016 at 5:52 pm
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!
BTW, I really enjoyed your session!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
June 6, 2016 at 6:34 am
Any Oracle users out there who are keen to move to SQL Server? This may be of interest.
June 6, 2016 at 7:16 am
I need the assistance of someone well-versed in SQL Server internals who might be able to explain why SQL is behaving oddly. I'd actually like an explanation of why this is happening before I work toward a solution because I can't see that I'll find a solution unless I understand what SQL is doing.
Can anyone take a look here at my cluster/standalone issue and let me know if it's just me or if SQL really is behaving oddly?
June 6, 2016 at 7:40 am
Brandie Tarvin (6/6/2016)
I need the assistance of someone well-versed in SQL Server internals who might be able to explain why SQL is behaving oddly. I'd actually like an explanation of why this is happening before I work toward a solution because I can't see that I'll find a solution unless I understand what SQL is doing.Can anyone take a look here at my cluster/standalone issue and let me know if it's just me or if SQL really is behaving oddly?
Nevermind. It was just a serious brain fart. <headdesk>. I've been working on these stupid alias connection issues for way too long.
June 6, 2016 at 8:25 am
Ray K (6/5/2016)
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!BTW, I really enjoyed your session!
Yes WayneS, it was nice to finally meet you. I enjoyed your sessions the most and it was extra nice to win the copy of your book.
Ray K, sorry I didn't get to connect with you.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
June 6, 2016 at 9:47 am
drew.allen (6/6/2016)
Ray K (6/5/2016)
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!BTW, I really enjoyed your session!
Yes WayneS, it was nice to finally meet you. I enjoyed your sessions the most and it was extra nice to win the copy of your book.
Ray K, sorry I didn't get to connect with you.
Drew
Strangely, I think I might've been standing next to you during the raffles at the end! I think I saw your name tag, and it didn't register that it might've been you!
I was the heavyset Asian guy with the goatee and the receding hairline. I was wearing shorts and a black T-shirt.
Sorry that I didn't introduce myself! 🙁
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
June 6, 2016 at 10:13 am
Ray K (6/6/2016)
drew.allen (6/6/2016)
Ray K (6/5/2016)
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!BTW, I really enjoyed your session!
Yes WayneS, it was nice to finally meet you. I enjoyed your sessions the most and it was extra nice to win the copy of your book.
Ray K, sorry I didn't get to connect with you.
Drew
Strangely, I think I might've been standing next to you during the raffles at the end! I think I saw your name tag, and it didn't register that it might've been you!
I was the heavyset Asian guy with the goatee and the receding hairline. I was wearing shorts and a black T-shirt.
Sorry that I didn't introduce myself! 🙁
I skipped out before the raffles at the end, so it couldn't have been me.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
June 6, 2016 at 10:26 am
drew.allen (6/6/2016)
Ray K (6/6/2016)
drew.allen (6/6/2016)
Ray K (6/5/2016)
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!BTW, I really enjoyed your session!
Yes WayneS, it was nice to finally meet you. I enjoyed your sessions the most and it was extra nice to win the copy of your book.
Ray K, sorry I didn't get to connect with you.
Drew
Strangely, I think I might've been standing next to you during the raffles at the end! I think I saw your name tag, and it didn't register that it might've been you!
I was the heavyset Asian guy with the goatee and the receding hairline. I was wearing shorts and a black T-shirt.
Sorry that I didn't introduce myself! 🙁
I skipped out before the raffles at the end, so it couldn't have been me.
Drew
I could've sworn that I was standing next to someone with "Drew Allen" on his name tag. Go figure!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
June 6, 2016 at 11:23 am
Ray K (6/5/2016)
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!BTW, I really enjoyed your session!
Thanks Ray. It was nice to meet you also!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 6, 2016 at 11:24 am
drew.allen (6/6/2016)
Ray K (6/5/2016)
WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!BTW, I really enjoyed your session!
Yes WayneS, it was nice to finally meet you. I enjoyed your sessions the most and it was extra nice to win the copy of your book.
Ray K, sorry I didn't get to connect with you.
Drew
Well, someone on The Thread just had to win it...
It was nice to meet you also
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 6, 2016 at 11:27 am
PRO TIP:
If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 54,451 through 54,465 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply