There are some good articles on this site related to event Auditing, including how to filter for specific types of operations and users. http://www.sqlservercentral.com/articles/Stairway+Series/130498/

You can also fall back to using...

Start with learning how to live up to your formal job description. Ask your immediate supervisor what's expected of you in terms of roles. You don't want to focus on...

When running sp_who2 or DMV queries from SSMS, rather than filtering on 'SA', perhaps excluding your own SPID is what you really want. It's entirely possible that another DBA (or...

When it comes to choice of database, it helps to understand that some platforms are much better suited for staging large amounts of data (ie: Hadoop or Cassandra), some databases...

This is a long shot, but assuming the user who executed the DELETE operation is still connection, and the last command they executed as the DELETE, then it should work....

https://mssqltalks.wordpress.com/2013/02/25/how-to-audit-login-to-my-sql-server-both-failed-and-successful/

Are the production staging tables to be entirely deleted (truncated), or will you delete only rows aged within a specific date range?

If you discover it to be a timing issue, and the job step can be repeated to completion, then consider going under Advanced properties of the step and setting it...

If MERGE isn't an option, then perhaps something like the following (pseudo-code of course). This way, if the row does happen to exist, then it's a single lookup.

UPDATE ... WHERE...

SQL formatting tools are very useful when you have a new coding standard applied to legacy databases and applications or when there are other developers writing code outside the core...

One useful new feature for SQL Server would be something like "declarative table level DML assertions". Basically this would be sort of like a trigger that intercepts a DML operation...

Gary Varga (11/15/2016)

---

Eric M Russell (11/15/2016)

---

...Have you ever updated every row of a table to the same value because of a poorly written query? I have. A temporal table would...

It is alarming to think that Spotify could (inadvertently or even willingly) fill the hard disk of 40 million users worldwide.

However, this can be mitigated by setting "Maximum Database Size"...

Surprise!

Too late, it's sitting in the 'Active Threads' queue, so everyone...