(Susan Harkins) If you have a magic wand or a special relationship with some data fairy, all of your data is in the same database on the same server. Most of us aren’t that lucky. Sometimes, the data we need is a non-database format or resides on a different server. SQL Server is flexible enough to
Other News
Nothing But NET! (Sample Chapter)
(Robert Vieira) In terms of where to locate a subject in my books, this subject has to be the hardest one to place I’ve ever had to deal with. At issue is how fundamental the addition of .NET assemblies is to SQL Server programming in the SQL Server 2005 era versus how much it is shared between the
DLinq (Linq to SQL) Performance (Part 4)
(Rico Mariani) Well it’s high time I gave you some numbers for the new stuff.
Cartesian product of dimensions
(Jag Singh) This is not a recommended approach; only explained here so that you can identify it when it presents itself and avoid it.
Mass Data Management
Don’t Miss the Latest SQL Server Show Posted Friday, the show is a "Best Of" with information about getting started with Reporting Services > Watch Here Featured Article(s) Populating Sparse or Missing Series Data Using Partitioned Outer Joins This article describes how to populate sparse or missing serial data with Oracle’s partitioned outer join. This tool is essential for correct […]
Integrating DataPower with WebSphere Message Broker using the Broker Explorer
(Peter Crocker and Dominic Storey) Learn how to use the new DataPower security wizard, which is now provided as part of WebSphere Message Broker Explorer, to configure a DataPower SOA appliance so that you can use it to decrypt messages on which WS-Security processing has been applied. This wizard g
Meet Jena, a Semantic Web Platform for Java
(Ian Dickinson) Java programmers who want to develop semantic web applications have a growing range of tools and libraries to choose from. One such tool, the Jena platform, is an open source toolkit for processing Resource Description Framework (RDF), Web Ontology Language (OWL), and other semantic
Smart Client: Composite UI Application Block
(Mark Strawmyer and Rachel Wireman) In this article you’ll look at another Smart Client technology. Specifically, you’ll explore the Composite UI Application Block (CAB) from the Microsoft Patterns and Practices group. It allows you to build complex Windows Forms-based solutions using proven techniq
An Interview With Ken Henderson About The Book SQL Server 2005 Practical Troubleshooting: The Database Engine
(Denis) I posted this on my SQL Server blog but decided to post it here also. I am a big fan of Ken Henderson’s books, I believe that every SQL Server developer should have a copy of his books. When I noticed on Amazon.com that the book SQL Server 2005 Practical Troubleshooting: The Database Eng
Calling a PL/SQL Function at the wrong time gets me into trouble – the dreaded ORA-0113 End of Comunication Channel with a hierarchical query
(Lucas Jellema) I have a query: an in line view, built from two simple queries unioned together, that forms the starting point for a hierarchical (connect by) query.