I've been wrestling with data in the cloud for a while. It doesn't help that the definition of cloud is so nebulous.

I'm not an infrastructure guy but I've been...

CORRECT. In the Microsoft course material

Did a bit more than glance and also read what little...

A lot of ideas that are painted black are due to mis-interpretations.

Take Hungarian notation. Simonyi suggested its use to signal intent but people mis-interpretted this to signify type. ...

I very rarely use GOTO, in fact I cannot remember when I last used it.

If I have a large stored proc with a complex transaction then on failure of any...

I'd turn this on its head. My customer is my boss. That attitude might upset a few line managers but it would help build bridges between IT departments...

CyberWomble (12/8/2011)

---

I have a couple of questions about this article:

1.) Are the plans cached by sp_prepexec stored in the same place as the plans cached when using Stored Procedures?

2.) Do...

I've seen something like this before with linked servers.

In that particular instance the code below alleviated the problem

EXEC master.dbo.sp_serveroption @server=N'YourServer', @optname=N'lazy schema validation', @optvalue=N'true'

Thanks for the star rating. If...

collins.jmj (12/6/2011)

---

The challenge is that the same file structure is used to store the mind maps - <some folder> \ <some mind map>. After creating a few dozen mind...

At this point I feel...

As a teenager I had a job delivering potatoes to fish and chip shops across the staffordshire plains. The boss had a book called a ready-reckoner to help calculate...

Joe, I should have remembered that. I think one of your books mentioned storing a calendar table rather than trying to workout calendar maths on the fly.

It is so...

Yes, and apparently each space shuttle launch expected at least 6000 components to fail but was still designed to work.

On my list of things not to think about is precisely...

Well October 14th 1962 was the start of he Cuban missile crisis so has Red-Gate been bought by the Russians?

Went to an astonishing presentation by Thomas Kejser at SQL Bits where he demonstrated that IDENTITY and in fact NEWSEQUENTIALID() is far slower that GUIDs on SSDs and this is...

The problem with policies and procedures is summed up by the Winston Churchill quote above.

I...