(Marcin Policht) In articles of this series, we have been so far providing recommendations regarding security-related configuration settings of SQL Server 2000 from the point of view of a database administrator. We have presented a set of guidelines that apply to any generic installation of SQL Serv
Other News
Monitoring Oracle processes in Windows NT
(Ravinder Bhalla) It’s much easier to monitor CPU usage in a Unix environment for each individual Oracle process (i.e., PMON, SMON, DBWR) as compared to NT. In NT, there is only a single process (i.e., oracle.exe). In order to get the status of individual threads of Oracle processs in a Windows envi
FIX: You may receive a 547 error message when you try to update an instance and application databases of SQL Server 2000 Notification Services by using the NSControl Update command
When you use the NSControl Update command to try to update an instance of Microsoft SQL Server 2000 Notification Services and the application databases for an existing instance of Notification Services, the update operations may not be completed successfully.
Hosting .NET Within SQL Server 2005 Express
(Philip Miseldine) One of the biggest strengths of SQL Server is its powerful support for the definition of logic inside the database through stored procedures, user-functions, and triggers. This allows developers to create well-recognised and adaptable interfaces from their business logic layers to
Islands and Gaps in Sequential Numbers
(Alexander Kozak) SQL Server developers often use either the IDENTITY column or the MAX() function (for example, MAX(id) + 1) to create unique identifiers for a table. I personally like the identities. In my opinion, they’re convenient and flexible. One of the things that I don’t like about them, th
Lotus Workplace Web Content Management and Content Manager Working Together
(Wei-Dong Zhu) In this IBM Redbook, we explore how we can put both IBM Lotus Workplace Web Content Management (LWWCM) V2.0 Java Edition and IBM DB2 Content Manager (Content Manager) V8 products at work together. We provide overviews of LWWCM and Content Manager products, discuss why and when we m
Taking Abstraction One Step Further
(James Holmes) One of the hottest new concepts in programming today is aspect-oriented programming (AOP). Once used primarily in academia and research-and-development organizations, AOP today is making inroads into mainstream development. Using AOP is an evolutionary way of developing software that
.NET XML Best Practices: Choosing an XML API
(Aaron Skonnard) As someone who has spent the past several years learning and using the various XML APIs available throughout the industry, I can honestly say that the .NET implementations are the best I’ve seen in terms of productivity, efficiency, and extensibility.
Five things to unlearn about Oracle
(Bob Watkins) As I continue to teach Oracle 9i, I find more database administrators (DBAs) running current versions of the software but still living within the limitations of older versions. Here are five more things that it’s time to unlearn about the Oracle database.
Developing UML Diagrams from XMI in Oracle JDeveloper
(Deepak Vohra) Unified Modeling Language (UML), a specification created by The Object Management Group (OMG), is a visual modeling and design language that in recent years has evolved into the de facto standard for specifying and documenting complex, object-oriented software applications. UML mo