I think it really depends on your database needs, costs, skill set, functionality requirements. My whole career was dealing with on-premise, datacenters. We have all had to deal with the...

Yeah, got it working by creating a SQL Login and then adding:  execute as login = 'NewLogin' before the step runs.

A 'workaround' was to add: execute as login = 'SQLLoginAccount ' in all the SQL Jobs that calls EXEC msdb.dbo.sp_send_dbmail  in it.  That did the trick but not sure what...

A 'workaround' was to add: execute as login = 'SQLLoginAccount ' in all the SQL Jobs that calls EXEC msdb.dbo.sp_send_dbmail  in it.  That did the trick but not sure what...

Figured.  Thank you.

Last Physical Hardware environment has to be close to 6-7 years ago!  Do sometimes miss the 'old' days of installing OS and settting up and configuring the boxes. Currently running...

This was resolved. It was an open port issue and the order of it.  All good.

Just following backup on this.  I still don't have any resolutions on it.  Again, trying to setup Transactional Replication in SQL Managed Instance from DatabaseA to DatabaseB in the same...

SELECT

CASE

WHEN

FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1

THEN

'INSTALLED'

ELSE

'NOT INSTALLED'

END

Can just loop through the DBs

Thank you for your response and totally agree with it.  Always goes back to improving slow running queries and to decrease the amount of logical reads.  I haven't seen -5 ...

Hello, it can be an option.  The current process is to bring the XML into a SQL table first and then parse the XML into our data model with some...

We currently insert into a table the XML file into an XML column data type field.

Thank you.  I will check on the Business Critical tier.  Currently trying to resolve to resolve, "2021-11-16 16:15:35.08 Failed to connect to Azure Storage '' with OS error: 53.' with...

I am looking to replicate most or all of the tables from Database1 in SQL MI Instance 1 to Database2 in SQL MI Instance 1 (same instance).  We want to...

I end up removing all the SQL Views before creating the Extract .dacpac.  I found about 20 older DB Objects that wouldn't compile because of schema changes.  I was able...