(Vance McCarthy) MySQL cemented its position as one of the core hubs for enterprise-driving Open Source activity at this week’s MySQL Users Conference in Santa Clara. A wide array of commercial and Open Source software providers lined up to add their capabilities to MySQL’s 2005 push to deliver
Other News
Oracle Designer 9i to 10g Upgrade
(Lewis R Cunningham) I upgraded our Oracle Designer repository from 9i to 10g. It looks like the little things that annoyed me in 9i will continue to do so in 10g, at least in the short term. I don’t see any dramatic changes and my problem child ERD still can’t be transformed to tables. I have a UK/
Memory Utilization of SSIS
(Larry Chesnut) Not too long ago, I was in LA doing a Yukon Ascend delivery for Hilton Hotels, and I had a student in my class who asked about the memory utilization of SSIS, the replacement for the old DTS. The student asked about two items in particular; one, can the service and the packages that
Threat Modelling For SQL Servers
(E.Bertino, D.Bruschi, S.Franzoni, I.Nai-Fovino and S.Valtolina) In this paper we present the results from an analysis focusing on security threats that can arise against an SQL server when included in Web application environments. The approach used is based on the STRIDE classification methodol
Heterogeneous data gets the WebSphere treatment
(Jack Vaughan) WebSphere has been a remarkable market success story for IBM. Not too long ago, Big Blue was being urged to break up into separate companies. Although it spun off some of its properties, IBM remained as one entity, and began working to connect the vast number of its offerings. WebSphe
Processing XML Showplans Using SQLCLR in SQL Server 2005
(Arun Marathe and Boris Baryshnikov) Build an application to extract a query’s estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-
Generics in .NET: Type Safety, Performance, and Generality
(Mark Strawmyer) Welcome to this installment of the .NET Nuts & Bolts column. To fulfill some requests I’ve received, this article expands on the use of lists and collections in Microsoft .NET. Its focal point is generics, which is a new addition in the version 2.0 release of the Microsoft .NET Fram
IBM DB2 Data Access Application Blocks for .NET
Are you involved in the design and implementation of data access code for .NET applications? Have you felt like you are writing the same data access code over and over again? Or perhaps you are new to .NET and you want easy but yet secure and efficient data access code to access DB2; if so, then the
Creating databases in SQL Server 2000
(Steven Warren) Creating databases in SQL Server 2000 can be an easy process if you understand the [key terminology]
Create Master Pages in ASP.NET 2.0
(Doug Thews) The implementation of master pages is a highly anticipated feature in ASP.NET 2.0. A master page is a template that you can use to define the overall look and feel of your ASP.NET Web applications. In previous versions of ASP.NET, you were forced to embed user controls in every page to