Ozzie.eu

Issues with SQL Server 2014 Service Pack 1

Microsoft chose to remove SQL Server 2014 Service Pack 1 (SP1) from the Microsoft
Download Center due to a significant installation issue discovered
shortly after release.

When applying the patch, any SQL Server instance with SSISDB catalog enabled runs into an installation error during SQL Server 2014 SP1 upgrade. The
instance is then in an invalid and unusable state.

• In the 11 hours of availability, there were 270 downloads from the Download Center. No other distribution channels were affected.
• The original release was version 12.0.4050.0, the new release will have a new KB and build number.
• When SP1 is released again, Microsoft will recommend that 12.0.4050.0 is uninstalled prior to applying the new SP1 update. This includes any “Side by Side” instance scenarios.
• Microsoft is targeting release in a few weeks and will share updates as we go.

You can follow the updates on the official release page. If you have installed the update, there are also steps for a workaround.

For the Linux/Mac fans that find Windows less secure

Don’t blame the OS, blame the users. Reading this news about how Russian cyber attackers used security flaws to hack diplomatic targets in the US, I was particularly  fond of the statement:

The Microsoft problem by itself is less dangerous, since it
involves enhanced powers on a computer from those of an ordinary user.

This is really about all those IT expert wannabes that make the machines go faster by disabling all security enhancements, such as the User Access Control.

Imagine a Linux machine with no password for sudo/su commands. Or a Mac that doesn’t prompt you for the password when something is trying to change the system.

That’s pretty much the same.