I don't have to implement data change capture very often, but when I do I put in right in the Proc making the update, either with the OUTPUT clause or...

Thanks for the response Steve.

I guess the one question I have when people talk about scale up/scale down, are they more like at seasonal changes or intraday changes?  If 90%...

The company I'm working for now is preparing to make a major jump to the cloud.  I'm struggling with their reasons for the move, which seem very abstract and shallow. ...

My favorite place I have worked was a small online retailer which had roughly 80 total employees and an IT department of 4.  On my last day I set up...

I've been a DBA 10 years at 4 different companies now and they all have purchased the extended support (usually via SA), effectively giving the product a 10 year shelf...

lol, funny one @jeff Moden

I just switched jobs a couple months ago.  I went from one of the big fortune 500 companies to a smaller manufacturer.  The move was 100% about culture.  I really...

Ran my test in 2008 R2:

Are you sure that's right?  In the page the answer links to, I see this:

As others have pointed out, this documentation also contradicts your answer:
https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/implementing-identity-in-a-memory-optimized-table?view=sql-server-2017

Thank you

With great power comes great responsibility.  While having a computer in our pockets is ultra-convenient, it's also quite addictive, to the point that many people use it to escape reality. ...

Coming from SQL Server, I got very frustrated by the Oracle community when trying to start administering one of those databases.  I couldn't understand why their community was so much...

I got my undergrad in math and have found about half of it very helpful in my professional career.  Discrete math is particularly helpful when working in SQL.  I am...