New T-SQL Capabilities in SQL Server 2005 - Part 3 of 3 (setfocus.com)

submitted by SetFocus(510) 5 years, 1 month ago

In last month's article, I covered the new APPLY operator, Ranking functions, and the new TRY...CATCH capabilties in T-SQL 2005. This month I'll talk about two of the largest enhancements in the SQL 2005 language - Common Table Expressions (CTEs) and Recursive Queries. Both fo these are part of the SQL-99 standard. CTEs allow developers to more expressively identify a temporary result set (similar to a derived table or temporary view). Recursive Queries allow developers to more easily query hierarchies of data, by permitting developers (in a single SQL statement) to recursively query into a CTE that's also being populated). CTEs and Recursive queries can be a little difficult to initially grasp, so I'm going to show several code examples to demonstrate their value. read more...

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

tags: T-SQL kevin goff Server Database another

The Power of Anonymous Methods in C#(weblogs.asp.net)

submitted by antny(55) 5 years, 1 month ago

Anonymous methods are a new feature in C# 2.0 that allow you to hook an action directly to an event as opposed to having a separate event handler. For example, when a user clicks a button and you need to pop-up a MessageBox, you could handle it the standard way with a delegate and an event handler, or you could hook the action to perform directly to the Click event using an anonymous method as shown next read more...

add a comment |category: C# |Views: 34

tags: AnonymousMethods C#2.0 C# .net2.0 another

Slightly more dynamic ORDER BY in SQL Server 2005(john-sheehan.com)

submitted by rimsystems(6119) 5 years, 1 month ago

When CASE isn't enough and dynamic SQL isn't an option, here's a method for using dynamic ORDER BYs in SQL 2005. Supports multiple columns and sort directions. read more...

add a comment |category: Database |Views: 188

tags: SQLServer OrderBy 2005 Database SQL another

Cheat Sheet: ASP.NET Page Life Cycle & Common Events(john-sheehan.com)

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

We've all seen Leon Andrianarivony's excellent ASP.NET Page Life Cycle diagram. This one-page cheat sheet is the perfect compliment to that diagram, providing descriptions for each of the common stages and events. read more...

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

tags: ChetaSheet PageLifecycle ASP.NET CheatSheet another

Strategies for Structuring Unit Tests(laribee.com)

submitted by laribee(720) 5 years, 4 months ago

As you start to accumulate tests and move along in your TDD discipline, it becomes increasingly important to effectively organize large collections of tests. Here's an assortment of tactics for structuring your own test suites... read more...

add a comment |category: Unit Testing |Views: 36

tags: Testing DDD OO TDD UnitTesting another

Community Convergence XIX(blogs.msdn.com)

submitted by CharlieCalvert(7875) 5 years, 4 months ago

New videos by Ander's Hejlsberg and Wes Dyer, and new posts by Eric Lippert, Mike Hopcroft and Mads Torgersen. Lots of information about LINQ and Orcas. read more...

add a comment |category: C# |Views: 0

tags: C# another

Overview of ASP.NET AJAX 1.0 and Control Toolkit RTM(weblogs.asp.net)

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

ScottGu outlines what's changed in the RTM release, what to do before installing and future plans for ASP.NET AJAX. read more...

add a comment |category: AJAX |Views: 22

tags: ScottGu RTM toolkit Control Atlas another

Direct Download Link to ASP.NET AJAX 1.0 RTM(microsoft.com)

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

Here's the direct link to ASP.NET 2.0 AJAX Extensions 1.0 RTM download. read more...

add a comment |category: AJAX |Views: 88

tags: RTM download ASP.NET Atlas AJAX another

Scripting in C#(csscript.net)

submitted by jamesstaylor(100) 5 years, 4 months ago

CS-Script allows you to run C# files as scripts. You can either write straight C# or classless C# files. It also allows you to embed the scripting engine in your own application. It gives you shell integration on Windows so you right click on a .cs file and select "Run as Script". Anyway, very cool stuff, I've used it in a number of my applications. read more...

add a comment |category: C# |Views: 22

tags: Scripting C# another

IE Web Developer Toolbar Beta 3 Released(blogs.msdn.com)

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

New features: improved UI, style tracer, enhanced view source (with code coloring), and all your old favorites. Get it free from Microsoft. read more...

add a comment |category: IE |Views: 3

tags: Toolbar WebDevelopmerToolbar IE another

VS2005 C# Code Snippet Cheat Sheet(john-sheehan.com)

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

Here's all the built-in Visual Studio 2005 C# Code Snippets on one single page for easy printing and reference. read more...

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

tags: format CheatSheet Formatting csharp 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

A realtime currency exchange class in C#(madskristensen.dk)

submitted by madskristensen(8565) 5 years, 6 months ago

The European Central Bank (ECB) provides the currency exchange rates on a daily basis in XML format, so all there needs to be done, is to wrap the XML file into a generic dictionary for easy use. read more...

add a comment |category: C# |Views: 75

tags: Currency XML C# another

10 Great Free Tools for ASP.NET Developers(chrisfulstow.blogspot.com)

submitted by wibble(245) 5 years, 6 months ago

Ten of the most useful free tools for ASP.NET developers read more...

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

tags: free ASP.NET Tools another

ASP.NET Performance: Reducing Size of Web Page(20.targetprocess.com)

submitted by firefalcon(635) 5 years, 6 months ago

How to reduce size of generated HTML page read more...

2 comments |category: ASP.NET |Views: 72

tags: ASP.NET Performance another

How Deep are your Defenses?(sitepoint.com)

submitted by spikysimon(50) 5 years, 6 months ago

So, you have built your secured web application. You have enabled ASP.NET’s handy authentication and authorization features. But have you done enough? No, not at all. What happens if you forget to deploy the web.config controlling access to the application’s administrative folder? Or if an attacker gains access to the box by exploting your database and references your business logic layers? Or if an attacker finds a SQL injection and starts writing directly to the database? In many cases, the short answer is “bad things” oftentimes leading to unemployment. But it need not be so easy for an attacker. There are a number of tactics one can use to extend security beyond the web interface. Like a good army, you must practice defense in depth in order to protect the application. read more...

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

tags: SQL SitePoint Security ASP.NET another