(Matthew David) Unless you’ve been sleeping, you’ve noticed a change in the way we architect solutions. The foundation for the post-Web 2.0 world is to leverage services, such as SOAP and WSDL, to connect to clients. The client can be a web browser, server, or client solution—Apple’s iTunes being th
Author: SSWUG Research
One last storage comment
(Willie Favero) RELEASE (DEALLOCATE) changes a few of the rules when it comes to releasing storage. For example, even if you choose to use the DSNZPARM keyword CONTSTOR in attempt to take advantage of storage contraction, RELEASE(DEALLOCATE) negates the entire process. A commit does not trip CONTSTO
Installing a SQL Server 2005 instance
(Jeremy Kadlec) To most DBAs and developers, installing and configuring a new SQL Server is exciting because it brings on a whole new set of challenges and opportunities. The installation is just the first of many new learning opportunities with the latest version of SQL Server. In this guide we’ll
Generate Flash movies on the fly with PHP
(Jack D. Herrington) Rich Internet Applications is the new buzz-phrase for Web 2.0, and a key component of the substance behind Web 2.0 is Adobe Flash. Learn how to integrate Flash movies into your application and generate Flash movies dynamically using the Ming library.
Oracle RAC Administration – Part 11:The RAC DBA continued
(Tarry Singh) In this article, we will continue our discussion of Oracle RAC DBA essentials. We have already looked at Enterprise Linux and will continue to build our “Oracle RAC Appliance” on the Oracle Enterprise Linux layer.
Are you designing IO bound or CPU bound application ?
(Peter Zaitsev) This topic may look boring and obvious but it is extremely important for MySQL Performance Optimization. In fact I probably have to touch it in every second MySQL Consulting work or even more frequently.
A Quick Look at IIS 7
(John Peterson) If you’ve been curious about what to expect in the next version of IIS, there’s no need to wonder any more. Microsoft quietly slipped the latest version of their web server, IIS7, into the recent release of Windows Vista. This article will give you a quick look at the all new managem
SQL to View Notification Log
(Chris Eaton) About 16 months ago I posted a series of blog entries on monitoring your database with SQL Scripts (based on a presentation I gave at IDUG Europe in 2004). Here is the start of that string of entries (click next entry near the top to read the full series).
XML Country List File
(Mads Kristensen) Today, I had to bind a list of countries to a drop down list in ASP.NET 2.0. I wanted to use an XML file to store the countries. There are more than 200 so there was not way I was going to hard code them in the HTML.
Why I use explicit date math in SQL
(Xaprb) I sometimes see advice to do SQL date operations with the + and – operators on platforms where they are overloaded for date types. I try to avoid that, because it can give unexpected results. I prefer to explicitly use the built-in date/time functions. I’ll show you an example where the oper