I work in a company with over 800 employees. we have well over 50 developers.  
Our company takes a slightly novel approach to apprentices.

In the UK we...

For me, it was the day after weeks of trying to make service broker, NoSQL and a petabyte sql server system deliver a system that exceeded everything our internal customers...

This reminds me of a conversation in a nightclub about 20 years ago
… a group of girls approached us and asked what we did for a living... unfortunately...

is it possible that the login used in your linked server is the owner of the database that you are seeing ?

start by looking here

https://blogs.msdn.microsoft.com/karthick_pk/2011/02/01/sql-agent-maxworkerthreads-and-agent-subsystem/

way back in sql 2000 there were registry settings for the max number of concurrent threads sql agent could run. these were broken down into subcategories... replication, job agent, maint...

you might have saved me a lot of time with this script! 🙂

I "inherited" 7500 databases - unfortunately one of the server monkeys built a server with a default collation...

this is a table that is used by many processes, dropping the indexes and constraints would affect customer usage.

we're standardising names as we go. but as I said, the script works fine if I just run CMD and copy the contents into the window.. the issue is "permission...

depending on what you want to achieve then you may want to add a hierarchyid column to your table and then use the .GetDescendant / .GetAncestor functions rather than using...

I think what a lot of people have missed here is that sometimes you won't be the only person to touch that code.

you may write exceptional code the first time...

as a DBA who specialises in helping test professionals I see unit tests as a valuable cost saving exercise for the business

if you look at the ISTQB data for...

the only issue I've found with this is that the object_id of the tables will change (same as if you drop proc rather than alter proc)

if you rely on object_id...