I use to work at a place that almost always promoted from within. The benefit is that you save about 6 months of time since the new team member...

Strange. All subscribers same version? Same collation?

It's been weird. Bug filed since I noticed I could see things in a summary, but not in the thread. First post appears missing in some

Here is a reply

30 Days for RTO. That's the kind of job I want. Not that I want to take 30 days, but the pressure of minutes is really hard.

Hopefully this helps. Try this code with some names

SELECT
       ContactName,
       SUBSTRING(ContactName, 1, CHARINDEX(' ', ContactName))...

Frederico has the best question. Do you need a loop? What's the problem and data? Can you post or mock this up?

As pietlinden noted, 15 rows might not matter, but...

I like using dates as well, though for me it's an easy way to decide what to delete later when it's been there too long.

Please don't cross post. I've replied in the other thread.

Closing this one.

Is it this one:

https://support.microsoft.com/en-us/topic/kb959420-ms09-004-vulnerabilities-in-microsoft-sql-server-could-allow-remote-code-execution-857310ae-0dce-b300-8cfd-15366d91fd32

Are you looking for the update for MS09-004, security update 960082? or 83?

I can reach out, but you might log a case with MS SUpport and...

AOG is great, because having all read-only queries routed to one or more secondary nodes will take the load off the primary where the ETL load takes place. However,...

I think this article is a prompt to review a lot of things we have learned as "received wisdom".

...

Related to HA is the discussion on what is meant by...

I agree that the level of HA should be guided by RTO, RPO and the SLAs agreed with the business. There will often be databases that do not need...

racopa, apologies, as I'm not very fluent in Spanish. If Google translated this appropriately, you're wondering how to capture a last name like "Paolino" rather than "Angel Paolino"?

Tracking names in...

I would love consistency. What I mostly aim for is to be consistent moving forward and refactor if possible. And where possible, tools to help enforce, or at least remind,...