(Patrick.Alex) I have created an Excel Export component using XSL and XML which can produce very well formatted Excel files. This doesn’t require any Excel library to create Excel files without charts and macros, but if you want charts or macros in the Excel, then you have to have Excel installed on
Author: SSWUG Research
Minimize the size of tempdb in SQL Server
(Arthur Fuller) SQL Server automatically creates a database called tempdb for use as a workspace. When you specifically create a temporary table within a stored procedure, for example (CREATE TABLE #MyTemp), the SQL engine creates it in tempdb regardless of which database you are actually using. In
Integrate GPS adapters using WebSphere RFID solutions
(Rebecca Chen and Rick Wu) In the first of this two-part series, you’ll learn how to implement a GPS adapter on an IBM RFID edge controller using the WebSphere Studio Device Developer RFID Device Development Kit, and how to verify it on the IBM RFID middleware toolkit using a GPS simulator.
Oracle world view: SOA morphs into enterprise mashups
(Rich Seeley) Mashups are the killer apps for SOA, according to keynote speakers at Oracle OpenWorld conference. (R)
On Triggers, Stored Procedures, and Call Stacks
(Jeremy Cole) If you’re a frequent reader, you might have noticed that I’m on a roll contributing MySQL patches by now… there are many more to come. This is part of the reason that I founded Proven Scaling — to be able to spend my time solving interesting problems and making MySQL better. So what ab
Advanced XSL transformation mediation of arrays in WebSphere ESB
(Nay Lin) WebSphere Enterprise Service Bus V6 (WebSphere ESB) provides common connectivity between service consumers and providers in a Service Oriented Architecture (SOA). WebSphere ESB mediation flow components perform mediations between consumer and provider services to virtualize service locatio
Generic DataGridView
(Yildirim Kocdag) DataGridView is a new control which is more flexible for coding than a simple datagrid. However, there are a lot of developers who are facing diffulties about DataGridView Calendar, Mask, ComboBox and also Validations. Actually, DataGridView does not support such as important prope
Web services support in WebSphere Message Broker V6
(Rob Henley) This article describes the enhanced Web services support in WebSphere Message Broker V6. A brief introduction to SOAP and WSDL is followed by an outline of the basic Web service scenarios and corresponding message flows. The article then discusses the significance of a message model, it
Open Tools for MySQL Administrators
(Baron Schwartz) MySQL provides some tools to monitor and troubleshoot a MySQL server, but they don’t always suit a MySQL developer or administrator’s common needs, or may not work in some scenarios, such as remote or over-the-web monitoring. Fortunately, the MySQL community has created a variety of
Microsoft’s Lineup of SQL Server Related Webcasts for November 2006
Eleven new webcasts are scheduled for November, covering such topics as Reporting Services Management and Security, Analysis Services and more.
