Monthly Archives: September 2011

Decimal Data Types in SQL Server

I learned something new about decimal data types in SQL Server recently. If you do something like this: DECLARE @d DECIMAL(10,10) SET @d = 1.0   You get this: Msg 8115, Level 16, State 8, Line 2 Arithmetic overflow error … Continue reading

Posted in Blog | Tagged | Comments Off on Decimal Data Types in SQL Server

Free as in Beer

This editorial was originally published on Feb 7, 2006. It’s amazing to me that someone can take the words from another and publish them as their own. I guess that’s why sites such as essayrelief.com. And why other sites like … Continue reading

Posted in Editorial | Tagged | Comments Off on Free as in Beer

Map a Login – Basic Skill #3

This post is part of a series based on my presentation The Top Ten Skills You Need for SQL Server. This post is part of Skill #3 – Setup Security. I wrote about the basic security model for SQL Server, … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Map a Login – Basic Skill #3

Intertia

This editorial was originally published on August 22, 2006. My son asked me about physics the other day and what it meant. He’s been on a bit of a science kick, looking to understand and explain his world. I can … Continue reading

Posted in Editorial | Tagged | Comments Off on Intertia