Welcome to the Lounge

Kornfeld Eliyahu Peter14-Aug-19 1:49

Kornfeld Eliyahu Peter

14-Aug-19 1:49

What the customer cares about EOL?! He bought a license for 2005, and it still runs...

"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012

GenJerDan14-Aug-19 2:55

GenJerDan

14-Aug-19 2:55

He and I both work for people who are dictated to by yet another organization. A very annoying organization which pays no attention whatsoever to the real-world issues their dictates create. I often DISAgree with their ideas, and really want to tell them to STIG it where the sun don't shine.

We won't sit down.
We won't shut up.
We won't go quietly away.

YouTube, VidMe and My Mu[sic], Films and Windows Programs, etc. and FB

PIEBALDconsult14-Aug-19 4:30

PIEBALDconsult

14-Aug-19 4:30

EOL is when a product becomes stable.

MadMyche14-Aug-19 1:55

MadMyche

14-Aug-19 1:55

I feel ya.. getting much needed SQL version updates in the near future, starting with DEV machines first

Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional

W∴ Balboos, GHB14-Aug-19 2:13

W∴ Balboos, GHB

14-Aug-19 2:13

Without competition in inhouse development, I get off easy in a certain way.

I have a parallel set of all the main web-app pages. They live on production and differ only by a nuance in the name that distinguishes them. When a page in this set is opened it checks its own name and determines if it's targets are also live production or dev.

If and when everything works (a couple of competent testers who will also be the users for other development), the original files are archived for quick-replacement in an emergency and the dev versions are all saved to the live production names.

It already worked on production so it will work on production.

This works because, at least for quite a few years, it's all my private domain for development so there's no conflicts (human or code). Roll-backs are rare because we (myself and the testers/users) keep the attitude that this stuff has our name on it and one ought to have pride in their work (i.e., don't make a jackass out of yourself in front of 400-500 people). An error shows up in well under a minute after go-live, if there is one, with ca. 3000-4000 hit/hr for the internal site as a whole.

Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

#realJSOP14-Aug-19 3:45

#realJSOP

14-Aug-19 3:45

The web app itself was fine (although I don't know what OS version is running on the web server). It's the db servers that caused the issue.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

W∴ Balboos, GHB14-Aug-19 3:50

W∴ Balboos, GHB

14-Aug-19 3:50

That's the beauty of my luck position. I am developing the item where it will run - accessing the same DB's and all.

Usually they're generic and the actual SQL is by one of those two users (DBA's) - I need to make sure connections work, interfaces work, all the usual. Makes it all beautifully transparent.

But you're in a more realistic situation - unless someone will clone the entire production system for you, frequently, there's going to be deviations developing. If it feels a bit better, you'll probably find out it's a very small thing - but you know how computers are: "almost doesn't count".

Good luck with what certainly will be a tweak.

Ravings en masse^
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010

Sander Rossel14-Aug-19 2:29

Sander Rossel

14-Aug-19 2:29

You should hire me![^] Big Grin | :-D

Seriously though, you might as well not test at all if your test environment is eight years more modern than your production environment... Unsure | :~

I know it's easy to say, but your environments really should be as similar to each other as possible.
That makes it a lot easier to find environment specific bugs should they arise.
Maybe you can set your dev and QA environments in 2008R2 compatibility level[^] so at least your modern code doesn't work in those databases either even if it's supported by the engine?
I know you're in a difficult situation and such changes have to go through umpteen layers of management, but it's a thought Smile | :)

Best,
Sander

sanderrossel.com
Continuous Integration, Delivery, and Deployment
arrgh.js - Bringing LINQ to JavaScript
Object-Oriented Programming in C# Succinctly

kmoorevs14-Aug-19 6:20

kmoorevs

14-Aug-19 6:20

FYI, the compatibility setting won't help. I checked and that function works fine under sql 2014 with a db comp. setting < 110.

This is a lesson (thanks JSOP) that testing should be done in the same environment as production. Our desktop apps are compatible with 2005 (90) so any possible breaking changes always get tested against that environment. I've been bitten by the backward compatibility issue more than a few times, mostly for dumb stuff like older versions requiring any field in the order by to appear in the select.

"Go forth into the source" - Neal Morse

kmoorevs14-Aug-19 5:55

kmoorevs

14-Aug-19 5:55

Just for fun! Laugh | :laugh:

('cause I know you're a sql guru)

create function [dbo].[datefromparts]
(
	@year int, @month int, @day int
)
returns date
as
begin
	declare @rtnDate date;

	set @rtnDate = convert(date, ltrim(str(@year)) + '-' + case when @month < 10 then '0' + ltrim(str(@month)) else ltrim(str(@month)) end + '-' + case when @day < 10 then '0' + ltrim(str(@day)) else ltrim(str(@day)) end)

	return @rtnDate

end

Strangely, the datefromparts built-in function comes up in the intellisense in SSMS 2008R2 but then of course fails. Hmmm | :|

Of course, I would never recommend using a scalar function like this anyway, but hey, I learned a new function today...doubt if I'll ever use it. Smile | :)

"Go forth into the source" - Neal Morse

#realJSOP14-Aug-19 6:35

#realJSOP

14-Aug-19 6:35

The point isn't that we can't come up with a workaround. The point is that whatever workaround we come up with hasn't gone through a formal testing cycle prior to the deployment.

WSO CCC OTD 2019-08-14

OriginalGriff13-Aug-19 21:39

13-Aug-19 21:39

The family craft! (7)

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

PeejayAdams13-Aug-19 22:01

PeejayAdams

13-Aug-19 22:01

That's rather neat (assuming it's what I think it is, but I'm not around tomorrow so I'll leave it to someone else).

Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain

OriginalGriff13-Aug-19 22:06

13-Aug-19 22:06

I liked it.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

jsc4213-Aug-19 23:46

jsc42

13-Aug-19 23:46

I'm assuming that no one has posted an answer because it is easy. It must be easy, even I guessed it in only a few seconds. [Just hope I'm right after making a statement like that]

OriginalGriff13-Aug-19 23:49

13-Aug-19 23:49

Perhaps we'll find out soon?

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

jsc4214-Aug-19 2:03

jsc42

14-Aug-19 2:03

I was right! (as proof, I'd emailed my answer to you soon after my earlier response). Was going to wait for 2 hrs before 'going public' but got delayed.
It must be just the way one sees them.

Michael Martin14-Aug-19 1:43

Michael Martin

14-Aug-19 1:43

SCROTUM

Michael Martin
Australia

"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004

OriginalGriff14-Aug-19 1:50

14-Aug-19 1:50

Sadly, no.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

20 bits of entangled kitty

DRHuff14-Aug-19 6:51

DRHuff

14-Aug-19 6:51

Dammit! I thought he had that one in the bag this time...

This space for rent.

BillWoodruff13-Aug-19 21:17

BillWoodruff

13-Aug-19 21:17

is an infinitely echoing 'meow' in either life or death ? [^]

«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot

kalberts13-Aug-19 21:29

kalberts

13-Aug-19 21:29

If a cat in a box feels a pain but noone is there to hear its 'meow', is there then any 'meow'?

CodeWraith13-Aug-19 22:48

CodeWraith

13-Aug-19 22:48

Jülich. Spent a few years there.

I have lived with several Zen masters - all of them were cats.

His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.

MadMyche14-Aug-19 3:42

MadMyche

14-Aug-19 3:42

There is no cat

Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional