So, I work for Redgate, so any & all biases up front.

Nope.

Not for what you want. I've evaluated some of the SaaS monitoring tools that will monitor SQL Server. Frankly,...

When I run the same query multiple times why does the CPU time fluctuate between 0 and 16ms in tracer, query cost and live data explorer? Also I have...

You can use Extended Events to capture errors. This can include, if needed, the T-SQL statement or Object_ID of the query involved.

I saw you posted this over on DBA.StackExchange. I like the one answer. There were also good comments. From the bytes received, it looks like each query returns different data?...

Emphasis has to be on the fact that while this is called Profiler, it's just a front-end for Extended Events.

Nice write up.

Yeah, not a clue. Most of the time, I get very good behavior out of Azure. Obviously not the same as something running locally, but very much the same as...

Thank you! I hope the same for you and yours.

Performance is likely to improve. However, one thing, instead of putting all the code into a single query inside a procedure, create a wrapper procedure for all the IF ......

That's an odd construct. NULLIF compares two values. If they're matching, it returns null. Otherwise, it returns the first value, in this case, @parameter. ISNULL checks the first...

I would argue that every table should have a clustered index unless serious testing suggests otherwise. SQL Server is optimized around storing and retreiving data from clustered indexes. Heaps just...

Not your router. Azure, by default, locks down your databases. You cannot connect to them without specifically allowing identified IP addresses. So, it's youre IP address that you need to...

Hey Rod. First guess, have you poked a hole in the firewall so your account can get to the Azure database? That's the most common issue. You should be able...

I'm with Ken. Temporal tables is probably the better solution. However, you also can look at setting up an UPDATE trigger as shown at the link. Be cautious and...

The...

Also, a Common Table Expression, CTE, is not a TABLE, but an EXPRESSION. That label causes so many problems for so many people. You're not defining a temporary storage space....