I suspect Eirikur is looking at recovery as the culprit. Sounds right too. How big is the log?

It's a soup to nuts, everything is on the table, proposition to really get proper protection  from SQL Injection.

First, and most important, use the least-priviledge principal when setting up your...

Whoops! Weird.

For Redgate Compare, you don't have to have a primary key. You do have to have a column, or set of...

I'm not sure I understand the example that's giving you problems. Yeah, if the column names are different, you have to explicitly state them on an INSERT ... SELECT. That's...

One difference between the two is that the text field, where you're looking for table names, is different between the rpc_completed event and the sql_batch_completed event. In fact, you can't...

Nice work. I marked your second comment as the answer to the question. No need to delete your initial post. You answered it and shared that with others. All good.

Oh, I think they've done a much better job on that stuff lately. Most upgrades these days (talking SQL Server, not Windows, don't get me started on the OS) have...

When dealing with pre-release versions of SQL Server, I would strongly advise to do a full, and thorough, uninstall and not attempt to upgrade. You never know what bits of...

Measuring performance before and after the addition of the index and an examination of your execution plans (which are not a performance measure, merely a description of behavior) will tell...

Just saw this on a search for some information on Query Store. So, I know this is three years old. However...

I forgive you Mike.

Reboots, etc., do not directly affect the...

If we're talking IDE, it's mostly just ADS & SSMS. I also use VS Code when I'm writing Powershell for Azure. I'd definitely learn how to program Azure through Powershell....

There are any number of things to check, but I generally focus on wait statistics and query times. And honestly, mostly query times. Wait statistics tell you what things are...

I'd suggest adding a Continuous Integration step into your setup. Just deploy the code, without data, into a database, on commit of the code (or a push to a particular...

Stuff grows over time and we will absolutely, occasionally, make some poor choices. I would say external-internal-external-internal calls to the database are less than efficient and so, should be avoided....