Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Articles
Bug Bash: Let The CLR Find Bugs For You With Managed Debugging Assistants   31 Mar 2006 20:09 GMT
Managed Debugging Assistants make it easy to root out some very elusive bugs. Find out how the MDAs in the .NET Framework 2.0 can make your development life easier.
Source: MSDN
Know Your Networks   30 Mar 2006 22:33 GMT
The 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
.NET Rocks! - CSLA.NET 2.0 with Rocky Lhotka   30 Mar 2006 01:58 GMT
Rocky Lhotka discusses his CSLA.NET application framework version 2.0. New features, changes, and migration tips are covered.
Source: MSDN
Deconstructing the Visual Basic Upgrade Wizard   29 Mar 2006 18:25 GMT
Bill Sempf talks a look at the pros and cons of the Visual Basic Upgrade Wizard and shows it in action in a variety of different examples.
Source: MSDN
Interview with Dino Esposito, ASP.NET Expert   29 Mar 2006 05:00 GMT
What 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 GMT
What 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
A Crash Course on ASP.NET Control Development: Template Properties   29 Mar 2006 01:45 GMT
Dino Esposito continues his series on ASP.NET 2.0 controls development with this look at how to create template properties in a custom control.
Source: MSDN
Displaying the Sizes of Your SQL Server's Database's Tables   29 Mar 2006 00:00 GMT

In 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.

NameRowsData SizeIndex Size
Categories8112 KB32 KB
CustomerCustomerDemo00 KB0 KB
CustomerDemographics00 KB0 KB
Customers9124 KB80 KB
Employees9232 KB48 KB
EmployeeTerritories498 KB24 KB
Order Details2,15572 KB208 KB
Orders830160 KB320 KB
Products778 KB96 KB
Region48 KB24 KB
Shippers38 KB16 KB
Suppliers2924 KB48 KB
Territories538 KB24 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 GMT
You'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
Using Application Verifier Within Your Software Development Lifecycle   27 Mar 2006 22:57 GMT
Microsoft's Application Verifier (AppVerifier) is a runtime verification tool for unmanaged code that assists in finding subtle and difficult to identify programming errors, security issues and limited user account privilege problems.
Source: MSDN
1 2 3 4 5
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.