Changing them just means using different percentages to determine when to perform reorganize vs rebuild.  The problem isn't the percentage - the problem is when to choose a reorganize. ...

Too bad you couldn't get a bit further south to Texas - which has no state income tax 🙂

The real question you need to answer is, are you a...

Ola's stuff works on the 5/30 methodology for index maintenance.  The maintenance plan rebuild task uses the 5/30 methodology - the code the article links to (Adaptive Index Defrag)...

I don't have a test instance for Managed Instance to look at for you. Maybe open a ticket with support. I'd think you'd be able to see more data on...

Filestream just isn't supported on Azure SQL Database or Managed Instance. You just can't use it at all. I haven't tested this particular scenario with the Migration Service, but...

That's a pretty tough accusation....

Grant, I do have a question for you. In the past I've applied for jobs out of state. During the application process there was often a question that read...

Thanks for the support on the move. A couple of notes. First, I'm not changing jobs. I love Redgate and you'll have to pry this job from my dead cold...

Going backwards is hard. There are no shortcuts. The best way is going to be to script everything out and then build data migration processes using whatever tools you're most...

Quick note regarding any 3rd party solution:

I'm game to use any of them. Show me a restore to a point in time that meets our SLA, RTO & RPO. Now...

Months of log restores? Oh no. That will be a nightmare, regardless of the failover question. Speaking of, because the secondary has the same transaction id values and will be...

Rebuilding an index updates the statistics. After updating statistics, new execution plans get created. Sounds like the stats update may have lead to a different plan with poor performance. Since...

Instead of trying to trick out how extended events works, simply expose the data collected in a different location, a file system or something. What's important is not running Extended...

If you're capturing queries, usually either rpc_completed or sql_batch_completed, you'll be getting all queries. Then just filter by the appropriate action and values to limit the queries to a particular...

To do this you're going to need to use an Action in the events you capture. Which action really depends on your system setup. You can use username, session_principal_name, nt_user_name,...