Which version of SQL Server and SSMS can be installed on which Windows version?

January 17, 2020

As my Windows installation ages, it collects various versions of development tools, such as SQL Server, SQL Server Management Studio (SSMS), or Visual Studio.

But for every version of Windows the question is: will the next version of product X be installable on Windows Y?

So here is the answer for SQL Server and SSMS on Windows versions 7 (32-bit), 8.1 (64-bit) and 10 (64-bit)

SQL/SSMS Version Win7-32 Win8.1-64 Win10-64
2008 10 Y ? ?
2012 11 Y Y Y
2014 12 Y Y Y
SSMS 2016 13 Y Y Y
SQL 2016 13 Y Y
SSMS 17 17 Y Y
SQL 2017 14 Y Y
SSMS 18 18 Y Y
SQL 2019 15 Y

 


Solving Error 0x80092004 for Security Update KB4516655

January 13, 2020

Granting my Windows installations one last round of updates, I noticed that Windows Update would not let me install KB4516655.

Hopping around through the internets forums to figure out how to solve the situation, I found that the security update needed another update which is probably not on the list of dependencies of the update package:

KB4474419 had already been installed

KB4490628 this one was missing (and once linked correctly, and once linked to a different KB 4512506 here, which I did not immediately recognize)

KB4512506 (Monthly Rollup August 2019)

After applying those updates manually, KB4516655 could be installed, allowing the succeding rollups 2019-09 and 2019-12.

Of course, the WindowsUpdate.log file does not indicate, WHY things go wrong:

Misc =========== Logging initialized (build: 7.6.7601.24085, tz: +0100) ===========
Misc = Process: C:\Windows\system32\wuauclt.exe
Misc = Module: C:\Windows\system32\wuaueng.dll
Handler :::::::::::::
Handler :: START :: Handler: CBS Install
Handler :::::::::
Handler Starting install of CBS update 7CC120FB-9672-4AE5-BBA6-90651174A717
Handler CBS package identity: Package_for_KB4516655~31bf3856ad364e35~amd64~~6.1.1.1
Handler Installing self-contained with source=C:\Windows\SoftwareDistribution\Download\4009abf0458aef77b1e27406d1395603\Windows6.1-KB4516655-x64.cab, workingdir=C:\Windows\SoftwareDistribution\Download\4009abf0458aef77b1e27406d1395603\inst
Report REPORT EVENT: {0478CEF6-1B68-4959-A8F2-5DD5AD90DAFA} 2020-01-11 11:23:25:458+0100 1 181 101 {271A1B3A-DD7A-4D8A-94E1-9E44BFC9149F} 501 0 wusa Success Content Install Installation Started: Windows successfully started the following update: Sicherheitsupdate für Windows (KB4516655)
Handler FATAL: CBS called Error with 0x80092004, 
Handler FATAL: Completed install of CBS update with type=0, requiresReboot=0, installerError=1, hr=0x80092004
Handler :::::::::
Handler :: END :: Handler: CBS Install
Handler :::::::::::::

And the Windows Update “Help” is just as unhelpful.


Extraproxies spam comments

January 13, 2020

Garbage like this goes on page after page, resulting in ~350 spam comments within 3 days.

BTW who makes up all those account names and email addresses? Is this an actual job?

An attention-grabbing dialogue is worth comment. I feel that you should write extra on this topic, it won’t be a taboo subject but usually persons are not sufficient to speak on such topics. To the next. Cheers

Perfect just what I was looking for! .

I like this web site very much so much excellent info .

Very interesting topic, thanks for posting.

Great post, you have pointed out some excellent details , I also think this s a very wonderful website.

An impressive share, I simply given this onto a colleague who was doing a bit of analysis on this. And he in reality purchased me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the treat! However yeah Thnkx for spending the time to discuss this, I feel strongly about it and love studying more on this topic. If possible, as you turn out to be expertise, would you thoughts updating your weblog with extra details? It’s extremely helpful for me. Big thumb up for this blog put up!

I enjoy the efforts you have put in this, appreciate it for all the great posts.

Whats up! I simply wish to give a huge thumbs up for the nice info you might have right here on this post. I can be coming back to your weblog for more soon.

I conceive you have remarked some very interesting points, regards for the post.

as I website possessor I believe the written content here is rattling good, appreciate it for your efforts.

After examine a number of of the blog posts on your web site now, and I actually like your means of blogging. I bookmarked it to my bookmark website listing and can be checking back soon. Pls take a look at my website online as well and let me know what you think.

Very wonderful visual appeal on this website , I’d rate it 10 10.

Absolutely indited written content, thankyou for entropy.

I am glad to be one of several visitants on this great internet site (:, appreciate it for posting.

I’d forever want to be update on new posts on this web site, saved to my bookmarks! .

I’d perpetually want to be update on new posts on this site, saved to my bookmarks! .

An fascinating dialogue is price comment. I think that it’s best to write more on this matter, it won’t be a taboo topic however generally persons are not sufficient to speak on such topics. To the next. Cheers

You made some respectable factors there. I seemed on the web for the problem and located most individuals will go along with along with your website.

Needed to compose you that very little note just to say thanks a lot the moment again for the breathtaking methods you’ve contributed here. It is simply tremendously open-handed of you to allow unhampered what exactly most people might have offered for sale as an e book to help make some profit on their own, precisely considering that you might well have tried it in the event you considered necessary. Those things additionally acted as the good way to be aware that the rest have the same dreams really like my very own to realize way more concerning this problem. Certainly there are a lot more fun periods in the future for many who examine your website.

I am usually to blogging and i really recognize your content. The article has really peaks my interest. I’m going to bookmark your web site and preserve checking for brand new information.

This actually answered my drawback, thanks!

 

 


Umbraco 8 back-office has no Dictionary node

January 8, 2020

In one of my new Umbraco 8 sites, I needed to create a dictionary to store texts, rather than hard-coding strings in C# code.

However, I could not find the Dictionary node in Content, where I would have expected it. (and others as well)

The solution is to login as administrator, and assign the user access to the group Translators, or to enable the section Translators for the group.

It seems that an administrator does not have access to the translation functionality by default.

Then, create Languages under the Content tab, and add dictionary items with their respective text values under Translation.

See the Umbraco forum for illustrations.

 


Finding Images and Links in WordPress Export XML

January 6, 2020

I re-created two of my websites, and needed to know which images on those websites were referenced by my blog posts, and which links in the blog needed to be updated to the new sites.

New tasks for my old tool WP XSL GUI.

I created a couple of XSLT files to handle the tasks:

  • List of Images lists the <img> tags for each blog post that contains images
  • List of Images (embedded) generates the same list, but also included the images directly
  • List of Links lists the <a> tags for each blog post that contains links
  • List of Links (linked) generates the same list, but also includes the hyperlinks

Additional changes include

  • Upgrading the .Net Framework from 2.0 to 4.6
  • Replacing the setup project with Advanced Installer for Visual Studio.
  • Suggesting a default output name depending on the source file name and the transformation option
  • Changing the font to Segoe UI

wpxslgui.104.png

The latest version 1.04 of WP XSL GUI is available for download here.


Anki crashes on Ubuntu

January 6, 2020

As I browsed through Ubuntu Software, I wanted to install Anki (build number 2.1.0+dfsg~b36-1) on my Ubuntu 18.04 machine.

Launching the application did not open a new window, but rather opened a Crash Report window after some time.

Fortunately, the solution to the problem was just a couple of comments down the application page:

sudo apt-get install python3-distutils

Running this command from terminal lets you start the application.

I had a look at the Ubuntu package definition, and indeed this dependency is missing there. Less encouraging is the fact that this very issue has been reported one and a half years ago.


Protected: JHK

January 5, 2020

This content is password protected. To view it please enter your password below: