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

November 2007 Blog Posts

SQL Server 2005: Synonyms in T-SQL (analogous to Aliases in .Net)

If you're a .Net developer aliases should be very familiar to you. if they're not here is a reminder:using MyAlias = This.Is.My.Full.Namespace.MyClass; MyAlias m = new MyAlias(); // MyAlias is of course of type MyClass   Well it seems SQL Server 2005 added a similar functionality to T-SQL. It's called Synonyms. You can use them in all CRUD operations as well as in sub-selects and dynamic SQL What's interesting is that synonyms are evaluated at run time and the binding between the synonym and an object is by name only. This means that you can drop the object referenced by the synonym at any time, but...

posted @ Monday, November 26, 2007 9:37 PM | Feedback (8) | Filed Under [ SQL Server ]

Free SQL Server tools that might make your life a little easier

Update: New Stuff from the latest update will be in RED. This list will grow as I find new tools. So if you know of some not on this list do post them in the comments.   SQL Server Management Studio Add-in's SSMS Tools Pack - an add-in with lots of IDE options (Query Execution history, regions, debug sections, CRUD stored procedures creation, new query templates, running custom scripts from Object explorer's context menu) for SQL Server Management Studio and SQL Server Management Studio Express Data Scripter - generates insert statements for a table Create Database Snapshot - simple GUI...

posted @ Tuesday, November 20, 2007 6:31 PM | Feedback (89) | Filed Under [ SQL Server ]

SQL Server 2005 evil DBA prank

Today I feel a bit evil minded so I thought I'd share this little prank-friendly function. If you put this into a .Net Assembly you import to SQL Server as a function or a stored procedure you can wreck some real havoc :)   private static void SQLPrank() { Random r1 = new Random(DateTime.Now.Millisecond); int lowerBound = r1.Next(1000, 2000); int upperBound = r1.Next(3000, 4000); int randomNumber = r1.Next(1000, 4000); /* 1000 2000 ...

posted @ Thursday, November 15, 2007 10:05 PM | Feedback (5) | Filed Under [ .Net SQL Server ]

Map SQL Server Profiler EventClass ID to its name in a saved trace table

If you've ever worked with SQL Server profiler then you're familiar with the EventClass column in the trace. It tells you what event is being monitored for each row. When you save this trace to a table you can see that the EventClass no longer has a description but an ID. So how do you map this to a description? If you know where to look it's amazingly simple but if you don't here's a hint: sys.trace_events   Here's a script to help you out: SELECT TE.name, T.* FROM dbo.Trace T -- table that contains...

posted @ Friday, November 09, 2007 9:00 PM | Feedback (4) | Filed Under [ SQL Server ]

A chance to win one of fifty ApexSQL Developer Studios

  We're having a contest over at SqlTeam.com. Go take a look it might be worth your while. All you have to do is have a post in the forums. The more posts you have the better the chance you have of winning. What can you win? Well the title says it all. See what that is on the ApexSQL Developer studio page. It's a whole lot of goodies!   Read contest details here.

posted @ Thursday, November 01, 2007 3:33 PM | Feedback (1) | Filed Under [ SQL Server Misc ]

Powered by:
Powered By Subtext Powered By ASP.NET