Luis Cazares (6/23/2016)

---

trboyden (6/23/2016)

---

dhaveedh (6/23/2016)

---

None of your links present any information to support your assertion that 2002-02-28 00.00.00.000 is not a valid date. The ISDATE function even confirms it...

Jeff Moden (6/20/2016)

I gave the article 5 stars because the author published the steps that he took during troubleshooting a problem he'd not seen before and pointed out why the...

Luis Cazares (6/20/2016)

---

Mad Myche (6/20/2016)

---

Luis Cazares (6/20/2016)

---

The code mentioned here isn't the problem. The problem comes from the database design. Dates shouldn't be stored as strings or integers. We also...

Luis Cazares (6/20/2016)

---

The code mentioned here isn't the problem. The problem comes from the database design. Dates shouldn't be stored as strings or integers. We also need to know if...

In regards to PCI Compliance, the auditors have the required standards to test and then anything as they deem. This was because if some new vulnerability comes out they dont...

I would think that is where views come in. Yes you could call the view directly but the synonym allows you to...

I've used this before for parsing IP Addresses as suggested.

Re-reading the article today made me realize that I can use it in more ways, and what took me a few...

When I shrink CSS files down I replace all...

I'll be honest and admit that I did not read the 17 pages of comments over the last 6 years.

I will tell you that I agree with you 100%. I...

The first thing I thought of was Sql Kinection

PASS 2011

SQL Server Kinection – Come to the SQL Server Clinic and sign up to control a SQL Server environment via an...

Ponderance...

The definition of noon basically comes down to when the sun is highest overhead. Due to the distance between the sun and the earth, it takes 8+ minutes for us...

When should I mention that some people have been talking about implementing Double-DST

GSquared

---

Daylight Savings time was first proposed as a joke. Then it was lobbied for by a bug collector who wanted more daylight hours after getting home from work so...

paul.knibbs (7/19/2012)

---

Really? I'm surprised there were so many eco-nuts around in 1916,...

The correct answer is to store in UTC. Databases store data, and it's the job of whomever is getting the data to present in the correct format.

As for timezones and...