(Vinod Kumar) In mids of loads of new features introduced in SQL Server 2005, this is one feature that interests the DBA’s the most. If you work with large number of servers and large number of databases you might want to have immense control the way you monitor and maintain SQL Server instances. In
Other News
Improve dynamic SQL performance with binds
(Scott Stephens) Don’t be too quick to dismiss dynamic SQL used in PL/SQL programs. Scott Stephens provides code samples that demonstrate how using binds can help boost dynamic SQL performance.
C# Generics: Collection Interfaces
(Jesse Liberty) The .NET Framework provides two sets of standard interfaces for enumerating and comparing collections: the traditional (nontype-safe) and the new generic type-safe collections. This book focuses only on the new, type-safe collection interfaces as these are far preferable.
Skin Your Web Apps Using MVC
(Miguel A. Castro) MVC, or Model-View-Controller, is a design architecture that promotes separation among parts of an application, with particular focus on the presentation tier. The concept of MVC is inherent in the ASP.NET architecture. I’ll show you how to take advantage of that to provide sk
MySQL SQL Syntax and Use (Sample Chapter)
(Paul DuBois) This chapter provides an overview of the naming conventions and other syntax necessary to work in MySQL. Going through this chapter will also help you to get started in SQL by teaching you various commands and shortcuts that will help the SQL beginner.
On Practical Elegance
(Micah Dubinko) Paul Hudak’s excellent book begins: “Programming, in its broadest sense, is problem solving.” Would that we all lived by such a sensible guideline. Thanks to human nature, the big picture easily drifts out into the mists, especially in certain kinds of discussions. Perhaps this is a
Multilevel Security and DB2 Row-Level Security Revealed
(Chris Rayns, Norbert Verbestel, Roland Grant, Matthew Yates, Patrick Kappeler, Mike Holmans and Jun Ogata) Multilevel security helps address government requirements for highly secure data. New security features in DB2 V8 and z/OS 1.5 software can enable customers to have a highly secure single repo
Oracle on the Web Part 1 – Exploring Oracle’s HTTP Server
(Steve Callan) Hidden away in the depths of your Oracle installation is a valuable resource you can use to get a jump-start on learning how to combine Oracle’s strength as a relational database management system and the power of the Internet. This resource is extremely easy to visit and requires
Oracle releases patches, but not for many known flaws
(Shawna McAlearney) Even as admins scrambled to patch numerous critical flaws in Oracle products today, some noted that fixes were unavailable for many other serious and well-known flaws — among them one in Oracle Forms detailed in a paper recently released. (R)
Webcast: Optimize performance and protect the data that runs your business with IBM DB2 Multiplatform Tools
This on demand webcast will focus on real-life performance and recovery challenges that many of you face in your day-to-day work as database administrators or managers. (R)