Avoid Mixing INNER and OUTER Joins in SQL(weblogs.sqlteam.com)

submitted by jimrice14(880) 4 years, 7 months ago

I had previously written about the danger of Criteria on Outer Joins, but recently another situation popped up that occasionally causes issues with OUTER JOINS that I thought I might address. The issue is when you have multiple tables joined in a single SELECT, and you mix OUTER and INNER JOINS together. The end result doesn't always seem to "work", and it can be tricky to understand exactly why and how to fix it without incurring additional unintended side effects. read more...

add a comment |category: Database |Views: 22

tags: Database another

Tag mapping in ASP.NET(blog.madskristensen.dk)

submitted by isuttle(1140) 4 years, 7 months ago

Basically, it’s a way to turn all instances of a type into another type at compile time. In human language it means that it can turn all e.g. System.Web.UI.WebControls.Textbox instances in the entire website into another control. read more...

1 comment |category: ASP.NET |Views: 18

tags: ASP.NET another

Layered Architecture, Dependency Injection, and Dependency Inversion(code-magazine.com)

submitted by simoneb(5450) 4 years, 7 months ago

Building loosely coupled application architectures requires more than just separating your application into different layers. In this article, I’ll take a project that was built using techniques that result in fragile, hard-to-test code and introduce some principles, techniques, and refactorings that will help you realize flexibility and testability in your applications. read more...

1 comment |category: Patterns |Views: 44

tags: JPBoodhoo Patterns another

43 Exceptionally Useful AJAX Applications(designvitality.com)

submitted by Kickworthy(300) 4 years, 7 months ago

Usability on websites is exploding right now. AJAX has enabled web developers everywhere to add functionality to their sites like never before. They’ve gathered 43 extremely useful AJAX applications for use on any website. read more...

1 comment |category: AJAX |Views: 12

tags: AJAX another

SQL Command Visualizer for Visual Studio 2005(codechimp.org)

submitted by codechimp(345) 4 years, 7 months ago

A visualizer for SQL Command objects. Displays a more useful representation of a SQL Command object when debugging. Show details of the command, it's connection and lists all parameters, their properties and current values. read more...

add a comment |category: Visual Studio |Views: 103

tags: VisualStudio another

More than 100 Web 2.0 Online Generators(ifxplus.com)

submitted by m.casati(600) 4 years, 7 months ago

Here the list of online generators specifically for web 2.0 design: enjoy it! read more...

add a comment |category: ASP.NET |Views: 45

tags: Generators Links iFXplus 2.0 Graphics another

Super easy SQL Server 2005 Database Schema change auditing(blogs.geekdojo.net)

submitted by jamesewelch(2275) 4 years, 7 months ago

Here's a very simple way to make use of xml type in SQL Server 2005: audit all the object/schema changes to the database with a simple database-level trigger. It's like a poor man's source control for schema changes. But also, it could come in very handy for forensic purposes when diagnosing post-rollout issues or accidental schema changes. Anyway, it's simple and handy for what it does. read more...

1 comment |category: Database |Views: 32

tags: trigger Audit XML Database SQLServer another

100% Reflective Class Diagram Creation Tool(codeproject.com)

submitted by jiltedcitizen(563) 5 years, 1 month ago

This article is about using reflection. For those of you that don't know what reflection is, it is the ability to obtain information about a Type of object without really knowing anything about the object type that is being dealt with. For example one could simply ask the current Type of object if it supports a certain method name, if it does, the method can be called. This may sound strange but it is a very powerful technique. Lets suppose that I simply want to look at what methods a class supports, well that is also easily achieved using reflection. .NET allows developers to leverage reflection in many ways. read more...

add a comment |category: CLR |Views: 30

tags: CodeProject Reflection another

Always implement the ToString() method(blog.slaven.net.au)

submitted by dalziel(6230) 5 years, 2 months ago

Implementing the ToString() method make debugging a whole lot easier read more...

add a comment |category: Tips & Tricks |Views: 1

tags: ToString Debugging C# another

.NET Format String Quick Reference/Cheat Sheet(john-sheehan.com)

submitted by rimsystems(6119) 5 years, 4 months ago

All standard and custom DateTime and number format strings (for use with String.Format(), .ToString(), etc) in one handy document. read more...

add a comment |category: Tips & Tricks |Views: 310

tags: string CheatSheet .Net Reference another

Remote Desktop On A Non-Standard Port(haacked.com)

submitted by Haacked(5105) 5 years, 7 months ago

How to setup and use Remote Desktop on a non-standard port. read more...

add a comment |category: Tips & Tricks |Views: 50

tags: RemoteDesktop Tip Haacked another

Top 30 Software Engineering Practices(spellcoder.com)

submitted by bashmohandes(3000) 5 years, 7 months ago

Here is a top 30 list of software engineering practices as a guideline for better software read more...

add a comment |category: Tips & Tricks |Views: 13

tags: Engineering software another

SQL 2005: Changing Schema for a group of objects(geekzilla.co.uk)

submitted by fatdaveh(1420) 5 years, 8 months ago

This script moves all of your stored procedures from one Schema to another. It wouldn't be hard to change it to move other object types. read more...

add a comment |category: Tips & Tricks |Views: 7

tags: SQLServer GeekZilla SQL 2005 another

Scott Hanselman's 2006 Ultimate Developer and Power Users Tool List for Windows(hanselman.com)

submitted by Haacked(5105) 5 years, 8 months ago

Scott Hanselman, that uber technologist, updates his must have list of power tools for developers. read more...

add a comment |category: Tips & Tricks |Views: 6

tags: TDD Pick Tools ScottHanselman another

Cool (and Free) Threading .NET 2.0 E-Book (coolthingoftheday.blogspot.com)

submitted by marcos(2779) 5 years, 9 months ago

"This is a very cool threading online reference and freely downloadable e-book (PDF). Using C# for its examples, in 76 pages it covers basic synchronization, locking, BackgroundWorker, async delegates and more." Via: http://coolthingoftheday.blogspot.com read more...

1 comment |category: Tips & Tricks |Views: 58

tags: eBook PDF another