May 24, 2019
Hot Topics:

More articles by Mike Gunderloy

In Praise of the Lowly Comment

See how to make comments in your code more useful & effective for you and your fellow developers.

Getting Started with SQL Server Service Broker

Learn how the Service Broker provides the “plumbing” to let you pass messages between applications, using SQL Server as the transport mechanism.

The Project Postmortem: An Essential Tool for the Savvy Developer

Software postmortems, performed consistently, are a key part of bringing a development organization from chaos to smooth, repeatable functioning.

Getting Started with SQL Server Integration Services

Check out SSIS, the SQL Server 2005 replacement for the older Data Transformation Services. You might find SSIS to be a great solution for automating SQL Server.

Pervasive Tooling

Here is advice on what tooling should be truly pervasive in the current development universe.

A First Look at SQL Server Everywhere

SQL Server Everywhere you will have an extremely lightweight (under 2MB disk footprint), easy-to-redistribute, free database from Microsoft with a syntax that's a subset of full SQL Server Transact-SQL.

Risk Management and QA for the Lone Wolf

If you can keep the quality of your code high and the other risks to the project under control, you have a much better chance of delivering working software than the average developer using a random, chaotic process.

Basics of Statistics in SQL Server 2005

If you're having a problem with particular queries, there are a few things you can do with the information that the server collects about the distribution of data in columns and indexes.

Audio Feedback the Easy Way

Adding audio feedback to a .NET 2.0 application is easy using the System.Media namespace.

Using Synonyms in SQL Server 2005

It's nice to have little amenities in your development tools. They make for easier development and can save you a little time. Synonyms is one of those tools.

Dynamic Template Columns in the ASP.NET 2.0 GridView Control

The ASP.NET GridView is smart about automatically generating columns - but sometimes not smart enough. Mike Gunderloy shows you how to take matters into your own hands by building columns dynamically at runtime.

Tuning Up SQL Server 2005 Databases

Creating efficient databases isn't easy. See how to use the Database Engine Tuning Advisor, an easy way to increase the performance of your SQL Server databases.

What Else Can You Do With Version Control?

You're probably already storing your source code in a version control system. But if that's all you're doing, you're missing out. Discover five other uses for this critical piece of your infrastructure.

Working Smarter With ASP.NET 2.0

ASP.NET is such a huge and flexible development system that every team finds their own way of working with it. Gunderloy shares some of the mainstream and unique ways he has used the technology to deliver customer's requirements.

Quick Debugger Visualizers in Visual Studio 2005

Debugger visualizers allow you to provide a custom user interface for the display of particular classes of data when your program is in debug mode. While there are some complex use cases for this, you can actually derive considerable benefit from very simple debugger visualizers - ones that take ten minutes or less to build.

Ten of the Biggest Mistakes Developers Make With Databases

You are probably still pumping data in and out of a database, just as we all did a decade or more ago. That makes it all the more surprising that mistakes are still being made that date back to the good old days of Windows 95 and before.

Drilling Into SQL Server Management Studio

With Microsoft's SQL Server 2005 you can say goodbye to Enterprise Manager and Query Analyzer. Fortunately, you can also say hello to the SQL Server Management Studio.

URL Mapping in ASP.NET 2.0

Explore how to implement URL mapping in an ASP.NET 2.0 site. See the limitations of this technique as well as alternatives to get around those limitations.

The Code's the Thing

Here are details on the finalists and winner of the .NET Tool or Add-In of the Year.

Configuring Your ASP.NET 2.0 Site

If you did any work in ASP.NET 1.0, you're intimately familiar with grubbing around in the web.config file. The file is still there in 2.0, but now there are new tools to help you avoid the drudgery. In this article, you'll see how upgrading to ASP.NET 2.0 can take some of the pain out of maintaining an ASP.NET Web site.

XML Queries and Indexing in SQL Server 2005

For the first time, SQL Server 2005 offers a native XML data type. See how you can store and query XML documents as part of a SQL Server table, and how to use XML indexes to make queries against these columns more efficient.

Everything You Know About UI Design Is Wrong

Microsoft Windows Vista is shipping next year, and with it the rules of user interface design are changing in a multitude of ways, large and small. If you don't want your applications to look clunky and dated, it's time to start thinking about the changes that you'll need to make to fit into this new world.

Getting Started with Continuous Integration

Get up and running quickly with CruiseControl.NET so that your .NET projects "build themselves" whenever something changes in the source code.

Binding to XML Data in ASP.NET 2.0

ASP.NET 1.0 featured easy binding of user interface controls to ADO.NET data sources. ASP.NET 2.0 extends this concept to make it easy to bind XML files directly to the user interface. See how in this demonstration.

Native XML Web Services in SQL Server 2005

Discover how easy it will be to expose SQL Server 2005 data as a Web Service to any SOAP 1.2 client.

Image Maps in ASP.NET 2.0

You've probably heard a lot about the big changes in ASP.NET 2.0, but Microsoft didn't neglect the small things either. See how the new Image Map control makes it easy to design functional graphical interfaces for your Web pages without writing HTML or excessive code.

XML-based Code Generation with CodeSmith

Discover how templates can contain as much programming logic as you need, this opens up possibilities for transforming XML in ways that would be difficult or impossible using conventional XML tools.

Introduction to SQL Server Report Builder

SQL Server 2005 is the first version to include end user reporting capabilities. See how the new Report Builder makes it easy for analysts to generate reports while avoiding the performance pitfalls of completely ad hoc reporting.

What's new in SQL Server 2005

What's New in SQL Server 2005? The new version of SQL Server has been in development for five years now. That's given Microsoft time to build in a lot of new features. Mike Gunderloy highlights the most significant enhancements to help you judge whether you should start evaluating a potential upgrade.

Tableau: A New Way to Look at Business Data

It's easy to collect an immense amount of business data these days, but then what? Tableau offers a new answer to that question by using visual analysis to help spot patterns in data through interactive graphics.

Understanding SQL Server Licensing

There's one step in deploying an application that uses SQL Server that sometimes gets neglected until the last moment: buying the licenses! Review the confusing array of editions and licensing options now, before you have to write that multi-thousand dollar check.

Managing the "Surface Area" of SQL Server 2005

Learn about the new security feature Microsoft is focusing on with SQL Server 2005.

SQL Profiler Tips and Tricks

SQL Profiler is a vital tool for diagnosing SQL Server issues of all types. When you're trying to figure out what the heck is going on, especially with a heavily-loaded server, a well-chosen trace can help you pick out just the key events that you need to diagnose a problem.

Firefox's Moment in the Spotlight

Developer.com's readers named Firefox as the Development Utility of the Year.

The .NET Ecosystem is a Wonderful Place

See which product won and how this year's nominees bring out three important trends in .NET development (or, indeed, in development in general).

Introduction to SQL Profiler

Looking for a troubleshooting tool to view the actual SQL that's being sent during code executions? SQL Profiler is a great tool for peering under the hood of your SQL Server installation. Learn how to use it and you're sure to save debugging time in the future.

Using Mind Maps as a Software Design Tool

Between the idea for a new application and the actual coding, you need to flesh out the features and requirements that you're aiming for. For times when full-blown requirements management tools are overkill, try a mind map instead.

User Choice, Customization, and Confusion

When to allow and when to avoid making it possible for users to customize your applications.

Frictionless Testing with TestDriven.NET

Discover how to make unit testing and test-driven development easier with TestDriven.NET.

Understanding SQL Server Full-Text Indexing

Discover how to work with SQL Server to perform sophisticated searches using word roots, proximity, and fuzzy matches.

Limiting Upload Sizes with ASP.NET

Imagine this request: allow users to upload images to a SQL Server database. Oh, and limit the files to a certain size, to keep traffic and database sizes reasonable. Oh, and show a friendly error message if the file was too large. See how it's done.

Query Analyzer Tips and Tricks

You've probably used SQL Query Analyzer as a tool to execute ad hoc queries against Microsoft SQL Server. But there's much more than that in the Query Analyzer package.

Using the Table Data Type in SQL Server 2000

Having more tools at hand gives you a better chance of coming up with an optimum solution, and that's what this business is all about.

Data to Web in Five Minutes with Visual Web Developer 2005

See how you can quickly get your data to the web using part of the new wave of 'Express' products that Microsoft is introducing for the Visual Studio 2005 product cycle.

Document .NET Libraries with XML Comments

Distribute your .NET class libraries with professional-looking documentation for consumption by other developers by adding XML comments.

Using SQL Server 2000 Extended Properties

Have you ever thought of customizing the metadata associated with your data? You can do just that with SQL Server data by using extended properties.

Reading and Publishing Performance Counters in .NET

Performance is critical in today's business world. Take advantage of the easy to use performance counters available in .NET.

Using the SQLXML Managed Classes

Take a look at the bridges that SQLXML provides between SQL Server 2000 and the .NET Framework.

Rules for Effective Source Code Control

As a developer, you should already be using a source code control system. But are you using it as well as you could be? These four rules will help you get the most out of source code control.

Introduction to SQL Server 2000 Reporting Services

Microsoft has finally released their own Web-based reporting engine for SQL Server, after years of depending on third-party solutions for reporting. Learn what's included and how to fit it into your own SQL Server plans.

Basics of the Windows Installer Service

Take advantage of what the Windows Installer Service has to offer.

The New Face of DTS in SQL Server "Yukon"

Preview Microsoft's plans for Yukon's Data Transformation Services (DTS).

XML Data in SQL Server "Yukon"

Take a peek into the future... With the next version of SQL Server, code-named 'Yukon' (currently in beta), XML becomes a core part of SQL Server itself.

SQL Server "Yukon" and the CLR: Using Server Data

See into the future of Yukon... When you load CLR code into Yukon, the in-process managed provider lets you connect directly to the server that's hosting your code.

ABCs of CLR Functions in SQL Server "Yukon"

Excited about the .NET code coming to SQL Server? Discover how to call a Whidbey function from Yukon and see where this capability might come in handy.

Snooping Around

Windows applications can be complex, but because they use documented file formats and APIs, they're easy to explore. In this article, Mike Gunderloy presents quick looks at half a dozen tools that you can use to peer inside of any Windows program.

SharePoint and Web Services

Want a practical example of using Web Services? Learn how to unlock Windows SharePoint Services data by using the new SharePoint Web services interfaces.

SharePoint Document Workspaces for Developers

Jump into document workspaces and programmable collaboration with Microsoft SharePoint.

Choosing to Generate

To generate code... or not to generate code... that is the question! (At least for many developers!)

What Developers Need to Know About Windows SharePoint Services

You have probably heard of Microsoft SharePoint or Windows SharePoint Services but are not sure what advantage it will be to developers. Here is your chance to find out what it is and if it can help you.

From ADO to ADO.NET: A Gradual Approach

Have you found that the transition from ADO to ADO.NET was more involved than you originally expected? Mike Gunderloy guides you in how to remain productive while working your way up that learning curve.

Building Persistence into .NET Programs

Are you still a bit shakey on the mechanics of building persistent programs? Here you will work through a simple persistence example in C#, showing how you can leverage the power of the .NET Framework to store information safely and flexibly.

Properly Building Persistent Programs

Imagine that every time you turned the computer on, it reverted to its original settings. Not a very happy thought, is it? Yet, there are applications that ignore user preferences and go back to defaults all the time. Learn about persistence: what it is, when you should use it, and some of the practical techniques for implementing it in your applications.

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date