I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, 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

October 2008 Blog Posts

Different ways how to escape an XML string in C#

XML encoding is necessary if you have to save XML text in an XML document. If you don't escape special chars the XML to insert will become a part of the original XML DOM and not a value of a node. Escaping the XML means basically replacing 5 chars with new values. These replacements are: < -> &lt; > -> &gt; " -> &quot; ' -> &apos; & -> &amp;   Here are 4 ways you can encode XML in C#: 1. string.Replace() 5 times This is ugly but it works....

posted @ Tuesday, October 21, 2008 10:43 AM | Feedback (15) |

Custom user configurable SQL Server Profiler events

SQL Server Profiler is a well known tool for tracing different activity that happens between your server and the clients connected to it. But very few people know that you can have custom events and trace them in the SQL Server Profiler. They can be found under User configurable event group: We can have up to 10 custom events. Firing these custom events is done by executing sp_trace_generateevent stored procedure which takes event id as the first input parameter. These event ID's span from 82 (UserConfigurable:0) to 91 (UserConfigurable:9) A simple code example to demonstrate this: USE AdventureWorks GO CREATE PROCEDURE spDoStuff ...

posted @ Thursday, October 16, 2008 10:59 AM | Feedback (2) | Filed Under [ SQL Server ]

SSMS Tools PACK 1.1 - now with SQL Server Management Studio 2008 support

With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express. I've added a new feature to Search through the Database data. There are times when you'd like to find some value but can't remember in which table it is. Also the SQL Query History Log Viewer has been remodeled. I'm open to suggestions on how to improve it further. You can also have the SSMS Tools Pack installed for both SSMS 2005 and SSMS 2008 on the same machine, however they don't share the same settings.   I would also like to...

posted @ Monday, October 06, 2008 10:59 AM | Feedback (8) | Filed Under [ .Net SQL Server SSMS Tools Pack ]

Powered by:
Powered By Subtext Powered By ASP.NET