The trick to solving this problem is to make getting into your software EASY and getting out impossible. One cloud CRM tool we had bought into years back helped us...

CDC (change data capture) will track changes on a table, but it can be messy if you have a lot of data that changes, but how you describe it sounds...

Just a little FYI too - when hiring a consultant, it never hurts to check what the consultant is an expert in. If you hire a consultant to evaluate your...

If you are putting NOLOCK on an INSERT, UPDATE, or DELETE query, that's not going to do anything. SQL doesn't allow NOLOCK on data change operations as it...

My opinion - NOLOCK is not a solution to blocking or deadlocks. NOLOCK is a "band-aid" solution in most cases and in the rare cases it is "needed", there are...

My opinion (note I am NOT a licensing expert) - that falls under an "it depends" scenario. Microsoft probably doesn't care, but your government agency/license may be unhappy with their...

I could be mistaken, but I thought the whole point of backup with checksum meant that the backup would contain a checksum in it for validation of the backup. Basically,...

Possibly a silly question but are the plans exactly the same apart from the estimates? What I mean is are you getting the same seeks and scans across all systems,...

Not quite the same error you got, but same error number - https://dataginger.com/2012/10/07/msg-2555-level-16-state-1-line-1-error-dbcc-shrinkfile-with-emptyfile-option/

Their solution was to restart the SQL instance and try again. It was likely caused by a query...

That is not a lot to go on. Can you provide sample output and what you have tried? What you provided doesn't tell me enough to give you anything meaningful.

What...

I would recommend asking on a Python forum or a MySQL forum, not a Microsoft SQL Server forum, but that's just me.

But because I'm a sucker, I'll try to help...

You can do that from a stored procedure, but I am pretty sure you can't from a function.

And to be honest, I'm not even sure how you'd do that in...

Brian, just to let you know, I got it to work! The client had not been uploading the correct version of the rdl. I had manually changed one to...

One line makes me shudder:

There is no recipe that does not include some kind of starter (either Poolish or Sourdough starter).

So does Poolish (a recipe) ALSO have a starter? If...

Yeah, so your report builder is too new for that SSRS. Best bet is to change the project configuration to use an older SSRS, which is answer number 2 in...