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 2008 Blog Posts

SQL Server 2005 Express Job Scheduling - Part 1

I've written an article here on SQL Team on how to schedule jobs in SQL Server 2005 Express Intro As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed due to the security policies of many hosting companies and thus presents a problem. Maybe we want to schedule daily backups, database...

posted @ Thursday, August 28, 2008 4:32 PM | Feedback (1) |

SQL Server 2005 temporary tables bug, feature or expected behavior?

In my opinion these 2 batches should behave the same but they don't. the first fails and the second runs ok. I've searched through Books Online for any clue but i haven't really found anything useful. Does anyone have any clue about this? Permissions and transaction isolation levels are not an issue here. -- just to make sure it doesn't already exist IF OBJECT_ID('tempdb..#tempTable') IS NOT NULL BEGIN SELECT 'DROP Temporary table' DROP TABLE #tempTable END IF OBJECT_ID('normalTable') IS NOT NULL BEGIN SELECT 'DROP Normal table' DROP TABLE...

posted @ Thursday, August 21, 2008 4:56 PM | Feedback (22) | Filed Under [ SQL Server ]

Software Development Cycle truism

For all enthusiasts out there this is how software development cycle works no matter what the project is:   Programmer produces code he believes is bug-free. Product is tested. 20 bugs are found. Programmer fixes 10 of the bugs and explains to the testing department that the other 10 aren't really bugs. Testing department finds that five of the fixes didn't work and discovers 15 new bugs. Repeat three times steps 3 and 4. Due to marketing pressure...

posted @ Tuesday, August 12, 2008 5:53 PM | Feedback (0) | Filed Under [ Misc ]

Powered by:
Powered By Subtext Powered By ASP.NET