So, the logs in log shipping can be used as point in time recovery. Therefore, secondary log backups seem redundant, and yeah, they could lead to a truncation in the...

I get it. Dealing with NULL is a pain. However, it's a unique value and has unique functions. Follow Phil's advice. Use IS NULL and IS NOT NULL instead of...

For introductory stuff, I always asked these questions. Obviously, a few would need to be updated, it being 2022 & all. However, I'd still say these were pretty basic,...

The easy way is to look in the SQL Server error log. It'll tell you. You can also see it in the Windows event log. Pretty sure you automatically get...

I would not recommend pursuing replication. It's very old technology that gets almost no love from Microsoft at all. You honestly sound like a perfect candidate for Availability Groups. Yes,...

Not a Data Factory person, but I do a lot of work in Azure.

Strong recommendation, look for videos or blogs. There are exceedingly few books written on Azure because the...

Just to clarify...

Well, AI, believe it or not, Microsoft Azure is where I'd go to look. There's some amazing stuff going on there.

I'm absolutely NOT an AI expert of any kind. However,...

You want to look at date functions like EOMONTH. Here are some samples that are pretty much what you're looking for.

I'd suggest taking a look at Redgate Data Compare. You can run it on a scheduled basis to capture changes to a given data set. You can compare it...

I'm pretty sure this is what you want. First, create the Supplier table with a primary key, and then reference that in the constraints of the Product table. (it's...

The major players, AWS, Azure & Google, are all priced somewhat similarly. You're unlikely to find a major price difference on them. So, I'd focus more on ensuring that you're...

I'm not sure what you mean. You're saying you want to drop the table if it exists AND some additional criteria? DROP only uses IF EXISTS. There's not a way,...

Serial is an integer. So you would use that data type in any foreign keys.

No official term that I'm aware of. Old, outdated, orphaned, junk, garbage, <insert inappropriate words here>. You can call 'em just about anything I guess. I'd probably just refer to...