my only issue with 2 user authentication is when the "crap" goes sideways at 2am

it could be a new sql agent job or a new process from an app, but...

this normally occurs for one of 2 reasons (they are the bane of my life)

the execution plan is too big for management studio to handle (it's basically a big xml...

sorry - I clicked on the wrong button and reported the last entry - completely my bad. - I wanted to "quote"

I'd love to hear how you use...

root paths

I once failed a job interview where I was set a technical challenge to install sql and create a database (simple I know)

It was on a virtual machine with...

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

<li style="list-style-type: none;">

1. OPENQUERY is your friend. Linked servers and letting SQL Server figure out if, maybe, this...

Shoot... I'm just happy to be on someone's list. 😀 😀 😀

I meet Steve and Grant before they knew how to spell RedGate.  I don't remember exactly but it...

sounds like you want to right click on you r server and go for "poperties"

then go to database settings - these are the default locations, but any existing jobs might...

<li style="list-style-type: none;">

1. OPENQUERY is your friend. Linked servers and letting SQL Server figure out if, maybe, this time, it pushes predicates to the second server to...

watsap expires over Christmas. I've swapped to web apps for most things.

oh jeff, just for fun.. I already met steve, grant, kendra, itzig - i'm stalking you next 🙂 lol - that puts you just above brent ozar

steve put the blendology link in for me, (he's good like that)

also agree with ktflash, don't be afraid to put your solution in... i'm often wrong and never afraid to...

Sometimes it can be better to create a table variable (or temp table) and fetch your data into it, then use that in your join.. not always

I've started using sql...

For a 9-5 job, MI and BI skills will be stable roles - maybe power pivot etc, maybe R

But beware , these will pay a lot less

maybe move to a...

I got myself some smart door sensors because next year I'm getting a large AC unit and I am very serious about not running it when...

I really do think that you should look at Change data capture (CDC)

https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server?view=sql-server-ver15