We're still on 2008 here 😉

Are you looking for a particular part of code? There is no good way to do this other than what you've noted. SQL Server doesn't index or track code in...

You are asking for a PIVOT here. This might help: http://www.sqlservercentral.com/articles/T-SQL/63681/

Permissions. The CLR objects have permissions like others, so check those.

I'd be sure you have the correct source code, and if not, start tracking that down in case you need...

Yes, it's a common issue, and no, there's no way to test everything. Really though, most functions/calls/methods/application items are called the same way.

It's really about testing the items that...

This might help: https://www.simple-talk.com/blogs/2009/08/03/stolen-pages-ad-hoc-queries-and-the-sins-of-dynamic-sql-in-the-application/

Stolen pages being high (whatever that is for your system) is a sign of memory pressure. Lots of ad hoc queries, things that require SQL Server to...

powershell?[int] $a = [System.Management.Automation.Language.NullString]::Value

$a -eq $null

from https://www.codykonior.com/2013/10/17/checking-for-null-in-powershell/

ER tools: Erwin, and ER/Studio.

I doubt there is anything that complex written. There are variables for your environment, and most people don't do upgrades across three versions and document this. They usually do one.

You...

Survivor: http://www.amazon.com/gp/product/B00UDCI7RI/ref=dp-kindle-redirect?ie=UTF8&btkr=1

Love to see it. Focus down on your problem, not generally how other systems might work. IF you can mock your situation, and process for solving, that's a great...

ian.miller 9263 (4/28/2016)

---

Hi Steve. Interesting concept. However, I really don't think it would be possible to remove ALL traces of the data unless you were to do something...

Eric M Russell (4/29/2016)

---

The following will build a dictionary table containing SSN and SHA2_512 hash for every possible social security number (~ 1 billion rows). I hacked this together in...

Iwas Bornready (4/28/2016)

---

David.Poole (4/28/2016)

---

The ability to remove an individual's records is a legal requirement in the UK. It is intended for data that is inaccurate or false.

We also have the...

I think there are plenty of people that use TDD well. I think it makes sense, but it's hard as a discipline. I suspect many people think David was too...