(Brad M. McGehee) Every once in a while, a truly unique SQL Server product pops up, one that you have never seen before, and at the same time, provides a clever solution to a common problem. For example, let’s say that you are a developer and you need to include a database (both schema and data)
Other News
Reminiscing
(Steve Jones) I’ve only met a couple people in my career who have been using SQL Server as long as I have. I was thinking about the past recently and started to reminisce about the places I’ve been with SQL Server. Actually I was watching Maryland win the 2002 NCAA men’s basketball title and started
MicroStrategy and IBM Deliver Joint Business Intelligence Solution
IBM and MicroStrategy, a leading provider of business intelligence software, today announced they are providing customers with a bundled data warehouse solution that will include the MicroStrategy Business Intelligence Platform with IBM’s DB2 Universal Database (UDB) Data Warehouse (DWE) Standard Ed
Easy XML Publishing into Your Enterprise Portal
(Sue Vickers and Peter Moskovits) Enterprise portals provide a single interface to aggregated and componentized information. They significantly reduce the navigational issues inherent with Web sites and make it easier to publish information from disparate sources. The basic building blocks of en
IBM Talks Data Management
(Ted Kemp) Dr. Pat Selinger is IBM’s data management guru. An IBM Fellow and the company’s VP of data management, architecture and technology, she was a member of Big Blue’s first relational database team and is credited with helping to pioneer that technology. In a conversation with Business In
An Approach to Extract RBAC Models from BPEL4WS Processes
(Jan Mendling, Mark Strembeck, Gerald Stermsek and Gustaf Neumann) The Business Process Execution Language for Web Services (BPEL) has become the defacto standard for Web Service composition. Yet, it does not address security aspects. This paper is concerned with access control for BPEL based proc
Performance Optimizations for the XML Data Type
(Shankar Pal, Vasili Zolotov and Leo Giakoumakis) Microsoft SQL Server 2005 provides extensive support for XML data processing. XML data can be stored natively in an XML data type column, which can be typed according to a collection of XML schemas, or left untyped. Fine-grained data manipulation is
Oracle Database 10g Does More, Demands Less
Oracle Database 10g, the foundation of Oracle Corp.’s long-awaited platform overhaul, emerged from eWEEK Labs’ tests with our Analyst’s Choice recommendation. Database 10g addresses the needs of organizations pressured to increase uptime while cutting database staff, and it will pique the interest o
Getting Started with Oracle Database 10g
(Robert Freeman) Welcome to Oracle Database 10g New Features! This chapter is the place to start in your effort to learn all about Oracle Database 10g. In this chapter, we will first look at the “Grid” and see what it is all about. Then we move on to explain how to upgrade to Oracle Database 10g. Th
Auto-Number and Cumulative sum in SQL Server Query results
(Muthusamy Anantha Kumar) SQL Server developers and database architects often find they have a need to sequence query results or generate a cumulative sum for a group of rows in a table. SQL Server does not have a Pseudo row-id similar to other RDBMS.