You can tell I haven't plagiarised this by the poor SQL:

Table:

CREATE TABLE [dbo].[Wealth](

[Spouse] [char](1) NULL,

[AssetType] [varchar](100) NULL,

[EstimatedValue] [money] NULL

) ON [PRIMARY]

Data:

INSERT INTO [Scratch].[dbo].[Wealth]([Spouse],[AssetType],[EstimatedValue])

VALUES('H','Vehicle',10000.00)

INSERT INTO [Scratch].[dbo].[Wealth]([Spouse],[AssetType],[EstimatedValue])

VALUES('H','Savings',3000.00)

INSERT INTO [Scratch].[dbo].[Wealth]([Spouse],[AssetType],[EstimatedValue])

VALUES('H','Misc.',1000.00)

INSERT INTO [Scratch].[dbo].[Wealth]([Spouse],[AssetType],[EstimatedValue])

VALUES('H','Misc.',10000.00)

INSERT INTO...

All the auditing solutions that I have seen in play stink of being a technical resolution. Until it becomes visible and a concern at a business level they will remain...

This does remind me of the assertion by the UK's current Minister of Education that all schools should attain the "good" status which is only achieved when their pupil performance...

We could all do...

David.Poole (12/4/2013)

---

...Music lost from the 80's and 90's? Playing devil's advocate is that necessarily a bad thing?!?!? If it was any good then it is probably still being...

Steve Jones - SSC Editor (12/3/2013)

---

Gary Varga (12/3/2013)

---

I have total faith that the digital photos will be convertible because the formats are widely known so, even if it will cost,...

This is where the cloud services can help. For example, if you have a music store then why not raise the level of abstraction and store a piece of music...

I worked at one place where there solution was to kick all the staff to an offsite car park so that managers could turn up late and find a space....

A lot of music has been lost too. In the 80s and early 90s¹ a lot of bands started out by releasing singles on vinyl either individually or through tiny...

Lynn Pettis (12/2/2013)

---

When I first started working with SQL Server I was also heavily involved with the hardware and OS (NT 4.0). I was the backup for our SysAdmin...

chrisn-585491 (12/2/2013)

---

Among our local OSS data guys, not one of them recommends or uses MongoDB. It's not that it's NoSQL, it's just not a mature solution for most problems it...

It is likely to be an unpopular opinion with some of the less trained in our industry but I believe that the overhead in utilising an experienced team¹ far outweighs...

Jeff Moden (11/29/2013)

---

Gary Varga (11/27/2013)

---

I am in shock.

With all that has been posted here I am either a SQL Server god (because the majority are rubbish - thanks for the...

Jeff Moden (11/29/2013)

---

The exception to that rule is that spelling errors are simply not forgivable and incorrect substitution of correctly spelled words (for example, you meant to use the word...

I am a developer and have never been a DBS. That I have known more about RDBMS than some DBAs does not say much about me (I am NOT claiming...