Oh OK then.

All the best to all,

Gaz - from rainy England, home of GMT 😉

PS Personally...

Two points are key from my perspective; timezone and magic values.

Timezone should be UTC. A perfect example of why this should be was in a paper/article/book I read. They suggested...

Thanks kevin77.

I was wondering if anyone had done more of the solution in SQL Server and thought that was the way to go? And if so, why?

kevin77 (7/8/2012)

---

Yet another password security breach in which the company did not use a salt value when hashing the password:

http://www.pcworld.com/article/258941/password_protection_101_lessons_from_the_eharmony_data_breach.html#tk.nl_dnx_t_crawl

I wish I had the drive and resources to contact every...

William Soranno (6/28/2012)

---

I have the self contained version of KeyPass installed on my flash drive I carry with me. That way I can run the program from the flash drive...

I am just wondering why you aren't string's Replace or even Substring?

If you know the text or have the variable surely something like the following will do:

FullPath2 = a.FullPath.Substring("Q:".Length);

As you...

chrisn-585491 (4/5/2012)

---

Steve,

I could be cynical, but the number of source/version control editiorials and articles on SQLServerCentral and SimpleTalk has increased greatly since RedGate started making SQL Source Control. The fact...

If nothing else, this can be used to encouraged the least disciplined to be a better team player. In my experience it really helps to stop those developers who change...

Closed...

I voted too. BTW when Exchange Server was introduced as the first Microsoft server application to utilise PowerShell it introduced the PowerShell preview window in MMC. This was because the...

yazalpizar_ (3/28/2012)

---

One can learn to program and be a hell of good programmer without ever stuying computer science or anythig related to it....BUT be sure that this person will study...

I have seen recent graduates (last 10 years) with a distinct lack of understanding of programming fundamentals. These people were writing software!!!

There is a reason that I was taught different...

Can't you just change

exec ('use '+@db)

to

exec ('use ['+@db+']')

?

phegedusich (3/14/2012)

---

So we shouldn't expect another outage for, oh, three years or so. Sounds good to me.

Redundant failover architecture should include the...

This reminds me off when I was a passenger in a car recently. The driver was distracted by something the other side of the road for a moment and noticed...