PLESK FOR WINDOWS INSTALL

A lot of MySQL based software (notably, vBulletin and Xenforo, among others) rely on add ins like Sphinx or Enhanced Search, to deliver any kind of reasonable, full text search performance on large databases. Contains() is a simple way to access a very powerful text search feature set. MS SQLвЂ™s query language, Transact SQL, hasВ a contains() function, whichВ is one of the few things I like about MS SQL over MySQL. Microsoft includes this feature in the вЂњAdvancedвЂќ version of SQLExpress, but Plesk for Windows isnвЂ™t packaged with the Advanced version of MS SQL. Notably missing from PleskвЂ™s excellent MS SQL availability is built in support for full-text indices. If you are resource constrained,В I recommend only having one SQLExpress version service running. Any combination of these can exist on the same server.

PLESK FOR WINDOWS INSTALL

Even better, Plesk 12 lets you choose between 2008 (default), 2012, and now the 2014 versions of MS SQLExpress (you can install SQLExpress 20 via the Plesk updates page). In addition to MySQL, MS Access (aka вЂњJet EngineвЂќ, aka mdb) and MS SQL are supported.

While I generally prefer Linux for a variety of reasons, one of the nice things about Plesk for Windows is the broad database engine support given. In their recent versions, the folks at Parallels have done a nice job of minimizing the differences between their Linux and Windows Plesk control panel.

Plesk for windows