SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


We Do Need To Upgrade


We Do Need To Upgrade

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)

Group: Administrators
Points: 449248 Visits: 20592
Comments posted to this topic are about the item We Do Need To Upgrade

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (680K reputation)SSC Guru (680K reputation)SSC Guru (680K reputation)SSC Guru (680K reputation)SSC Guru (680K reputation)SSC Guru (680K reputation)SSC Guru (680K reputation)SSC Guru (680K reputation)

Group: General Forum Members
Points: 680717 Visits: 45603
Each new release of Windows is almost as bad as a new product instead of an upgrade. While I appreciate new functionality, upgrades are frequently expensive because of the removal of deprecated functionality. Because, for Windows users, Microsoft has a bit of a corner on the market, they seem to do whatever the hell they want without any concern for the customers that have been so very loyal (willingly or not) over the years.

I also cannot understand the lunacy that appears to be driving supposed improvements. For example the DATETIME datatype very nicely follows simple spreadsheet capabilities, which also mean ISO standards, for STARTDATETIME+PERIOD = ENDDATETIMEand ENDDATETIME-STARTDATETIME = PERIOD. Such simple temporal math is no longer possible with the DATE or the DATETIME2 datatypes.

Another great example of design lunacy came with the release of PIVOT. Microsoft owns MS ACCESS and yet they seemed to ignore the extreme and very simple to use functionality of PIVOT there when the designed the computational travesty of PIVOT in T-SQL.

The thoughtless, apparently market driven, design lunacy continues with such things as not returning an ordinal position for their SPLIT_STRING() function and the fact that the "new' FORMAT function takes 44 times longer to format than the ol' CONVERT() function does just to name a few of many examples of "what the hell were they thinking" designs.

The really bad part of all of this is that most people are deeply invested in the Microsoft stack and, since most of their associates are also invested in the same stack, they need to continue to drink the Kool-Aid that MS has served up, no matter how ridiculous it may be, to be able to communicate and stay in business with dependencies on that stack.

Now they're even making it so that you MUST upgrade to the damned awful Window 10 if you want or need to upgrade to the latest version of Office or expose all your goodies to the security horror known as Office 365.

Microsoft has always been a bit pushy but, especially lately, they've become a damned bully to drive sales through a captive audience.

Oddly enough, MS can't even follow their own deprecation suggestions. Take a look at the stored procedures MS still uses in SQL Server and look for semi-colons.

Between the half-assed, half-fast, and half-done code that MS has been pushing lately, I'll be surprised if anyone can write code that works the first time in the future. Let's hope that none of that is military or critical civilian code, although I think it may be too late even for those.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
robert.sterbal 56890
robert.sterbal 56890
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6760 Visits: 1520
Losses should not be covered if the insurer can show they were the fault of the operating system not being patched.
Summer90
Summer90
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23042 Visits: 4128
This will only get worse and worse over time. IT Dept budgets are being strained more and more. The mindset can become if it's running why upgrade? VM can allow older physical systems to be virtualized to live on forever as well.
Megistal
Megistal
SSCertifiable
SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6509 Visits: 2616
imo: For most companies, they will comply only if it will cost less than taking the risk of not doing it.
Eric M Russell
Eric M Russell
SSC Guru
SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)SSC Guru (82K reputation)

Group: General Forum Members
Points: 82910 Visits: 13682
Regarding the ATM hack cited, it seems to me that the vulnerability has more to do with a machine design that allows someone to patch in a laptop, and also a lack of protocols that should have prevented someone from impersonating an onsite ATM technician. Even if there were a Windows OS security fix to block one form of malware, the hackers will simply create a new version so long as they have physical access to the machine's USB port.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Steve Jones
Steve Jones
SSC Guru
SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)

Group: Administrators
Points: 449248 Visits: 20592
robert.sterbal 56890 - Sunday, February 4, 2018 10:12 PM
Losses should not be covered if the insurer can show they were the fault of the operating system not being patched.


I hope that gets written into policies. To me, Insurance is the best way to drive security.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)

Group: Administrators
Points: 449248 Visits: 20592
Summer90 - Monday, February 5, 2018 7:01 AM
This will only get worse and worse over time. IT Dept budgets are being strained more and more. The mindset can become if it's running why upgrade? VM can allow older physical systems to be virtualized to live on forever as well.


That's been happening for a long time. Saw plenty of people VM SQL 6.x,2000 systems as well as older W2K servers.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)SSC Guru (449K reputation)

Group: Administrators
Points: 449248 Visits: 20592
Eric M Russell - Monday, February 5, 2018 7:58 AM
Regarding the ATM hack cited, it seems to me that the vulnerability has more to do with a machine design that allows someone to patch in a laptop, and also a lack of protocols that should have prevented someone from impersonating an onsite ATM technician. Even if there were a Windows OS security fix to block one form of malware, the hackers will simply create a new version so long as they have physical access to the machine's USB port.
It's a couple items ,and for sure, physical access makes things harder, but the longer an OS lives, the more vulnerable it can be if not kept patched.

This is a constant race between security and criminals.


Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
jay-h
jay-h
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10897 Visits: 2694
Steve Jones - SSC Editor - Monday, February 5, 2018 8:32 AM
robert.sterbal 56890 - Sunday, February 4, 2018 10:12 PM
Losses should not be covered if the insurer can show they were the fault of the operating system not being patched.


I hope that gets written into policies. To me, Insurance is the best way to drive security.

That makes it far to easy for insurance companies to evade claims. Your auto insurance is not nullified if you have a worn tire. Your medical coverage is not nullified if you weren't being careful with that knife.


...

-- FORTRAN manual for Xerox Computers --
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search