I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 218, comments - 2281, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

August 2010 Blog Posts

When does SQL Server decimal NOT convert to .Net decimal?

Having the SSMS Tools Pack out in the wild enables me to get much “joy” from different bug reports people send me. And let me tell you, people send me back some seriously weird errors. But the most unexpected error message I’ve seen so far was the OverflowException when calling System.Data.SqlClient.SqlDataReader.GetDecimal(Int32 i). It turns out that SQL Server decimal data type is not mapped to the .Net decimal in it’s whole range. .Net decimal type only maps to SQL Server one in the decimal(29, X) range. That means that if you have a decimal column that has...

posted @ Tuesday, August 31, 2010 2:11 PM | Feedback (2) |

SSMS Tools Pack 1.9 is out!

This is a release that fixes all known bugs. If you encounter any new ones don’t hesitate to report them. :) The main feature list hasn’t changed. A few improvements have been made though: Save SQL Snippets to HTML and/or print them directly from SSMS. In Window Connection Coloring the server names can now be regular expressions giving you the ability to color multiple servers with the same color. Here’s a blog from David Levy (Blog|Twitter) about the new window connection coloring using regular expression and why is it really useful to him. Thanx for kind words Dave.   You can download the new version 1.9 here. Enjoy...

posted @ Tuesday, August 24, 2010 9:00 AM | Feedback (1) | Filed Under [ SQL Server SSMS Tools Pack ]

Powered by:
Powered By Subtext Powered By ASP.NET