Sorry for the late reply.

Currently we have an onsite system where images/documents are stored in the database. We are considering if these should be placed on the file system, or...

You might be able to use Convert_HtmlToXml in the following to get XML which you might then be able to process as you want.

https://sqlsharp.com/features/

I suspect it would be better...

Yes. I would have thought this is the main use of Micro...

Fair enough, the SQL generated by EF is a lot better than it used to be. It is just my experience that...

While EF has some nice advanced features, is there any reason why the bulk of the DB access cannot be done with Dapper and...

What is an AOR job?

If ESP means...

I have experience with two large systems - one with FILESTREAM blobs and the other using normal blobs.  Both ultimately got migrated out of the database into an object...

Another approach would be to sign the stored procedure and create a certificate user in MSDB with appropriate permissions. It can get a bit involved but the following may help:

If you are using four part naming try using OPENQUERY instead.

There should be no need to copy data to a temp table; just replace #t with the name of your table/view and adjust the column names accordingly.

Consumable test data:

CREATE TABLE #t
(
    ID int NOT NULL
    ,SomeDate datetime NOT NULL
    ,Flag char(1) NULL
  ...

• This reply was modified 1 year, 4 months ago by  Ken McKelvey.

ZIP files are binary files so will not save correctly as a string. Binary can be encoded as a string although the size will obviously be increased. One way to...

Please ignore this. I have just noticed that some of the production servers still have a GDR dated January and some have a GDR dated July.

I think Windows Update must...

One qustion: whats the purpose of

THEN DATEADD(minute, DATEDIFF(minute, '2020', T.StartDateTime), '2020')
ELSE DATEADD(minute, DATEDIFF(minute, '2020', T.EndDateTime), '2020')

instead of

THEN T.StartDateTime
ELSE T.EndDateTime

Looks like it produces the...

Try something like:

WITH InOuts
AS
(
    SELECT T.GroupingId, X.InOut
        ,CASE
         ...

• This reply was modified 1 year, 4 months ago by  Ken McKelvey.
• This reply was modified 1 year, 4 months ago by  Ken McKelvey.
• This reply was modified 1 year, 4 months ago by  Ken McKelvey.