Just to reply to both Jeff Moden and Seketon567 - I do agree that Fox was ONE of the places reporting on it, but I heard about it elsewhere. A...

Weird question but did you upgrade from a previous version of SQL (2017 or older) to 2019? If so, your maintenance plan MAY be in a previous version format that...

one thing you could try is to change @json table variable to a permanent table. That way you can read the response from the WEB API call.

Now, that being said,...

Have you checked the official docs:

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16

From there you can see what User Scans is showing you - Number of scans by user queries that did not use 'seek' predicate. So...

I would start by not following the news from Fox, but that's just a personal bias against Fox News. I would check tech news sites like the register (for example)...

The other thing that helps is once you do the presentation at least once, you get a feel for what parts engaged the audience and what parts were boring and...

The way things are set up in my environment, IT doesn't let me auto-generate my SPN's. I can't even make the SPN's. I need to put in a support request...

Have you tried googling the error? There are a lot of pages on google with similar errors such as this one:

https://dba.stackexchange.com/questions/188833/sql-linked-server-returning-error-suddenly-upon-query

In that scenario, the problem was a faulty NIC.

I recommend...

I may be mistaken but I am pretty sure that the error "The specified network name is no longer available" means that your computer lost access to the server for...

Just to add, data manipulation operations (INSERT, UPDATE, and DELETE) on a table need to modify most (all?) indexes on the table. So adding indexes to improve performance of deletes...

Apologies for the confusions caused . I am planning to set the execution timeout for all queries that I will be running in SSMS. My goal is to stop...

I think the problem is that you are trying to do something that doesn't make sense. The timeouts are configured on a session by session basis, not on an instance...

Sorry, been traveling, but to me, I'd say there are a few big things and then a whole lot of small ones.

Biggies

• 504s on posting (becoming too frequent)
• not...

I agree with you Steve. Presenting is terrifying and also fun. My first presentation I did was actually as a guest presenter at a university course where the professor had...

What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums.  Apparently even Steve has zero pull with them.

Two short...