In keeping with the tenor of the times, I'm just throwing mine...

Every SQL database restore must start with a full backup restore.

After that, you can, if you want to, restore a differential backup (that was taken after the full backup...

Mike, I appreciate you wanting to soldier on, but it's not just about you. Certainly we wouldnt' want you to get sick, but what if you get sick and...

For varchar, LEN(Area) will give the trimmed length while DATALENGTH(Area) will give the actual length.

For nvarchar, LEN(Area) will give the trimmed length while DATALENGTH(Area) will give the actual length...

My employer has been discussing for what seems like years about putting databases under VCS.  One system that I support was developed by an outside contracting firm.  Their database...

and you don't have to listen to 2 departments with different radio stations

one of the ideas I looked at is reversing the string and checking the ascii value of the first character - please someone tell me that is a stupid idea

I think what you might not be understanding - we are advising that you restore it to somewhere else... zero downtime.

you cannot restore a single log to your live server

if...

Nita

if you take a full backup every Sunday and then log backups every hour on a 5 TB database then you are in trouble.

the only way I can see you...

as far as I can see (and I haven't used CDC since it came in around 2005) it relies on the transaction log and logs into a local table -...

have a read of the official Microsoft documentation

https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver15

may we ask the reason for downgrading ? - could it be something settled by a compatibility mode setting?

as far as I can see - a downgrade is a complete...

for these types of queries you might want to have a look up the GROUP BY ROLLUP command - it is not used too often, but  it saves you using...

is there a way to use some sort of ranking function to do this?

something like partition by datepart(hour, somefield)

then use that as a subquery.... i'm just throwing out ideas here

the easiest thing we've come across is

azure devops, git and Redgate source control

honestly - I can spin up a repository in 1 minute then let management studio do the heavy...