Happy with SSMS - I've grown used to it over the years and know how to find the things I need. The only thing I miss is the TSQL debugger...

Do your applications have to change their connection strings to connect to the new 2019 instance?

There used to be a real annual Turing Test called the Loebner Prize (see https://en.wikipedia.org/wiki/Loebner_Prize or https://www.chatbots.org/awards/loebner_prize/loebner_prize/ ). This had 4 judges, 4 AI's and 4 "real people"....

I have been migrating TSQL code from SQL 2008 to later versions. The code consists of complex SPs that call more SPs that call functions, and my tests were based...

• This reply was modified 6 months, 1 week ago by  William Rayer.
• This reply was modified 6 months, 1 week ago by  William Rayer.

You could try importing it as a blob (use OPENROWSET with SINGLE_BLOB), this should always succeed. But you would then need to parse the string before putting it into your...

I have used TSQL and SSIS and my thoughts are:

• There is a learning curve with SSIS and you need to use it in the appropriate situations. It's not worth...

• This reply was modified 1 year, 2 months ago by  William Rayer.
• This reply was modified 1 year, 2 months ago by  William Rayer.

It can be difficult to link Excel and SQL Server and many different obscure errors are possible. The issue here is likely because you are running multiple imports at the...

I think Microsoft could partly address this by increasing the max DB size of SQL Server express to say 50 GB

I think this is unfair for at least three reasons:

1. Microsoft added Semantic Search to SQL Server 2012, this adds a lot of new functionality (see https://docs.microsoft.com/en-us/sql/relational-databases/search/semantic-search-sql-server?view=sql-server-2017 )

2....

• This reply was modified 1 year, 7 months ago by  William Rayer.

"Also, there is a 900 byte max key length that you have to stay within"

In SQL Server 2016 this has been increased to 1700 bytes for non-clustered indexes, see

• This reply was modified 1 year, 8 months ago by  William Rayer.
• This reply was modified 1 year, 8 months ago by  William Rayer.

In theory you could do the following:

1. Set up a FILESTREAM column to contain the DOCX files. This column could be in the existing table or you could create a...

• This reply was modified 1 year, 8 months ago by  William Rayer.

I would like to see an increase in the capacity of SQL Server Express (the free version). I suggest to increase the maximum amount of memory from 1GB to 2GB...

• This reply was modified 1 year, 8 months ago by  William Rayer.

I have come across this with complex SELECT statements using views that call other views that use scalar functions. One example I experienced during an upgrade was code that ran...

I will check it out. Actually the spreadsheet is useful as I can archive them and check them historically if jobs start clashing.

Just to say I have run this several times and copied the results into your template spreadsheet. It's extremely useful as it would be difficult to detect 'overlapping' jobs otherwise. Well done...