Posts in “Mssql”

Microsoft MSSQL doesn’t have a split() function (like in Ruby, Perl), so here’s one I wrote.

I’m porting some code from MySQL to Microsoft MSSQL, and unfortunately MSSQL doesn’t have a SUBSTRING_INDEX function. Here’s a version I quickly implemented, called my_substring_index.

Creating an SSIS Catalogue on Microsoft SQL 2012 seems to have an interface bug - you need to both “enable CLR” and provide an “encryption password”, but the options are mutually exclusive ie when I tried to type in a password, the interface locks the password fields.

MSSQL Resources

log shipping hints

In this exerise, you are required to move two of the system databases (master and model) to c:data. Here are some web pages that may help:

Here’s a couple of links on how to move the MS SQL Server system databases:

multiserver jobs exercise

guest and public