(Scott Guthrie) Over the last few weeks I’ve been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ
Other News
Cache Up to the Caching Application Block in Enterprise Library 3.0
(Thiru Thangarathinam) Any application you write may require some sort of caching to meet the performance requirements of the business. Until the release of Enterprise Library, developers were forced to roll out their own caching implementations; however, developers now finally have a standard out-o
Why restore a full SQL database vs. a failed filegroup?
(Serdar Yegulalp) Both SQL Server 2000 and SQL Server 2005 allow you to restore whole databases and to selectively restore individual files or filegroups. This is useful if one particular file or filegroup has failed and you want to restore it without going through the hassle of restoring the entire
Database Storage with SQL Server – Part I
(Vinod Kumar) Database storage is one of the primary failure point in the database environment. Hence, making the storage architecture consistent and at the same time giving it maximum redundancy must be embedded within the design itself. When I call redundancy, I don’t specifically say implementing
IDUG User View: Locking Up DB2 Performance
(David Beulke) Supporting multiple systems and dealing with application developers and managers who often don’t have a clue makes the DBA’s job a challenge. Fortunately, DB2 9 for z/OS offers a new optimistic locking feature that can improve system performance-and perhaps the DBA’s (and application
Webcast Today: SQL Server Consolidation
Featured Article(s) Understanding the SDLC Phases of a Software Project [Part I] Software Development follows various structured models and methodologies similar to any other engineering discipline. Each of these models provides its own set of methodologies to design and develop a software application. The choice of any such models entirely depends on the nature of the software project in hand […]
SQL Server Consolidation, Fantasy Football and ISCSI SANs
Featured Article(s) Script Demo: DM like Views representing sp_spaceused data A "DM View"-like view is described which returns sp_spaceused statistics for the tables of the database the view is created in. …includes both an SS2K compatible version, and an enhanced SS2K5 version Did You Watch the Latest SQL Server Show Yet? Posted Friday – Watch it Here. (Show is open […]
XML Serialization Sorrows
(Tom Goff) One of the features of our flagship product allows the user to save the results from a T-SQL script (run against one or more SQL Server databases) to a file. These results are stored in XML and can be re-opened and viewed by the user. One problem we have run into is that the XML standard
Microsoft’s XAML recasts UI development
(Ed Tittel) At Microsoft, a quiet revolution in how developers build user interfaces (UIs) has been underway since 2004. (R)
A little DB2 9 for the System Programmers out there
(Willie Favero) If you’re a z/OS person (or still refer to yourself as an MVS System Programmer) I can almost guess what goes through your mind every time you find out that there is a new version of DB2 available to install. You think “new version means new EARLY code means another IPL of my system”