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

April 2006 Blog Posts

Great DataSet visualizer

Visual studio's DataSet visualizer is ok but it's not that great :)) This one is excellent and if you do a lot of db development (which you do if you're reading blogs on SQLTeam :)) you need this. You can get it here.

posted @ Wednesday, April 12, 2006 10:56 AM | Feedback (1) | Filed Under [ .Net ]

Blittable - now that's a word!

As i saw this word being used with blittable and non-blittable datatype i couldn't help but laugh... who comes up with this stuff?? Blittable types are datatypes that don't require conversion when passed between managed and unmanaged code while non-blittable datatypes are represented differently in managed and unmanaged code. Complete explanation here

posted @ Sunday, April 09, 2006 6:45 PM | Feedback (5) | Filed Under [ Misc ]

WebDAV

I've posted an article about WebDAV protocol and my use of it for accessing MS Exchange store. WebDAV is based on HTTP 1.1 and is based on sending XML requests to find, set, remove and search for item properties. Microsoft recommends  that Exchange access from .Net is made with WebDAV. This MS article explains more.  It also works with Office documents... More here.  

posted @ Saturday, April 08, 2006 7:47 PM | Feedback (2) | Filed Under [ .Net ]

Converting TSQL/C#/VB Code to HTML

you paste the code you want to display on the page and it creates the color coded html. preety cool... http://www.manoli.net/csharpformat/ there's even a source of the app that does the convert that you can view.

posted @ Saturday, April 08, 2006 1:49 PM | Feedback (4) | Filed Under [ Misc ]

Extended SQL Server Ceiling and Floor functions

Maybe i'm reinventing hot water but no matter. It's fun for me :))) These 2 functions round the number up or down on the decimal position we specify. create function dbo.FloorEx(@num decimal(38, 33), @decimalPosition int)returns decimal(38, 33)as beginif  @decimalPosition < 0 set @decimalPosition = 0return floor(@num*power(10, @decimalPosition))/power(10, @decimalPosition)endgocreate function dbo.CeilingEx(@num decimal(38, 33), @decimalPosition int)returns decimal(38, 33)as beginif  @decimalPosition < 0 set @decimalPosition = 0return ceiling(@num*power(10, @decimalPosition))/power(10, @decimalPosition)endgo declareselect @num decimal(38, 33), @decimalPosition int @num = 10.123456, @decimalPosition = 3select dbo dbogo @num, .FloorEx(@num...

posted @ Wednesday, April 05, 2006 9:59 AM | Feedback (2) | Filed Under [ SQL Server ]

Managed / Unmanaged code helper page

If you do a lot of managed/unmanaged code interaction with COM objects then this is a page you must bookmark. http://www.pinvoke.net/

posted @ Tuesday, April 04, 2006 4:49 PM | Feedback (0) | Filed Under [ .Net Misc ]

Clustered Index seek and scan on selecting all data from a table

I stumbled on an interesting thing yesterday while playing... :)) Seems that getting all data from a table is faster if we add a "phantom" where part that forces a clustered index seek instead of a scan. More here.

posted @ Tuesday, April 04, 2006 2:45 PM | Feedback (2) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET