You're trying to concatenate a date with a varchar which doesn't end up well unless you specify the format of the date that you want.

Also you have too many quotes...

We upgraded from standard business-critical to premium business-critical a few months ago.  We had approached the 4tb storage limit and needed to upgrade to get more space.  We have a...

Could you have the database on in QA but not in an AG and log ship to it with the standby option so it can be read?  You can log...

Does the account also have delegation rights?

There are probably lots of ways of doing this but the following should work.  It counts how many of the columns exist in each table and if it's more than...

• This reply was modified 2 years, 3 months ago by  DNA_DBA.

I'd like to see:

• LastLoginTime in sys.server_principals
• ability in ssms to right-click on an object name in a query that will then select the object in the object explorer
• index...

The trigger will be fired 10 times as there are 10 'blob created' events.

How do you know when the set of files is ready?  Is there a particular file name...

I've had this multiple times before, where a server turns up with unidentified databases on it and nobody seems to have ever heard of.  Here's what I do:

• Check for...

The Availability Zone option protects you against an Azure data centre loss by keeping a second copy of the VM (and data) in another Azure data centre in the same...

Data Factory is a standalone tool for moving data from source to destination that can also transform data along the way (it does a lot more than that!)

The same Data...

I'll have a go at answering but I'm sure others will have more experience of this than me!

Synapse is integrated with Data Factory which is kind of like SSIS in...

• This reply was modified 2 years, 6 months ago by  DNA_DBA.

Do you get any error messages?   It's difficult to help without more information

The following shows what types of service can be moved between subscription and resource groups in Azure:

https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/move-support-resources

Managed instance can't be moved and neither can the databases directly.  Think you...

It doesn't load balance, it just directs the connection to the appropriate server.

Is the secondary set to allow connections?

You can disable the replication of DDL changes via the GUI, right-click on publication, click properties, select subscriber options and disable 'Replicate schema changes'

You can script out your replication, right-click...

• This reply was modified 3 years ago by  DNA_DBA.