Know Your Networks 30 Mar 2006 22:33 GMTThe sometimes-connected nature of mobile computers means that you need to build software that works smoothly as networks connect and disconnect. This article shows you how to build network-aware software using the Network Location Awareness APIs.
Source: DevX Interview with Dino Esposito, ASP.NET Expert 29 Mar 2006 05:00 GMTWhat does ASP.NET 2.0 have to offer? Should you upgrade your existing projects? Will AJAX change the way .NET developers create applications? And what's with ADO.NET 2.0? Expert ASP.NET developer and author Dino Esposito answers these questions, and many more, in this insightful, detailed interview.
Source: SitePoint Interview with Dino Esposito, ASP.NET Expert 29 Mar 2006 05:00 GMTWhat does ASP.NET 2.0 have to offer? Should you upgrade your existing projects? Will AJAX change the way .NET developers create applications? And what's with ADO.NET 2.0? Expert ASP.NET developer and author Dino Esposito answers these questions, and many more, in this insightful, detailed interview.
Source: SitePoint Displaying the Sizes of Your SQL Server's Database's Tables 29 Mar 2006 00:00 GMTIn my day-to-day work as a writer, trainer, and consultant, I usually wear the ASP.NET developer hat, focusing on designing
the middle-tier and front-end portions of ASP.NET applications with my exposure to the database usually being limited to data
modeling and writing queries/stored procedures to access the data. The typical DBA activities - creating indexes, doing consistency
checks, backing up the database, and so on - have always been someone else's responsibility. Over the past several months,
however, I've been taking a more active role in the DBA side of things for a decent sized database, one with over 200
tables, close to 500 stored procedures, and chewing through a few gigabytes of disk space.
With these new responsibilities, I've been building up my arsenal of utility pages and helper programs for this role. For
example, I have a program that periodically runs the SQL Profiler on the database for intervals of 10 minutes storing the
results into a trace file that is later loaded to an offline database and denormalized for parsing and reporting on various
database performance metrics. (Perhaps I'll write about this process in a future article.) Another utility that I use is
a web page that quickly shows a summary of the tables in the database - namely the number of rows in the table and the
size on disk the table and its indexes consume. The following shows the output when running this script against the
Northwind database.
| Name | Rows | Data Size | Index Size |
|---|
| Categories | 8 | 112 KB | 32 KB |
| CustomerCustomerDemo | 0 | 0 KB | 0 KB |
| CustomerDemographics | 0 | 0 KB | 0 KB |
| Customers | 91 | 24 KB | 80 KB |
| Employees | 9 | 232 KB | 48 KB |
| EmployeeTerritories | 49 | 8 KB | 24 KB |
| Order Details | 2,155 | 72 KB | 208 KB |
| Orders | 830 | 160 KB | 320 KB |
| Products | 77 | 8 KB | 96 KB |
| Region | 4 | 8 KB | 24 KB |
| Shippers | 3 | 8 KB | 16 KB |
| Suppliers | 29 | 24 KB | 48 KB |
| Territories | 53 | 8 KB | 24 KB |
The techniques I use work both in SQL Server 2000 and SQL Server 2005, and have been used in both ASP.NET 1.x and 2.0 pages.
In this article we'll look at two ways to grab this information from SQL Server and how to display it in a web page. Read
on to learn more!
Read More >
Source: 4GuysFromRolla Give Your .NET Apps the Face They Deserve with WPF 28 Mar 2006 19:18 GMTYou've probably heard about Avalon (now Windows Presentation Foundation, or WPF), and maybe seen screenshots or a demo, but now you can try it out yourself. Get started building next-generation Windows applications now.
Source: DevX