sorted by: recent | see :
popular
Content Tagged Server
SpringSource Application Platform + Bundle Repository
Viewpoint on Spring S2AP and OBR announcements from OSGi Alliance's senior architectLog Buffer #96: a Carnival of the Vanities for DBAs
This is the 96th edition of the weekly review of database blogs, Log Buffer.
Let’s start this one in SQL Server Land, with a question from Dennis Gobo — should SQL Server have the CREATE [OR REPLACE] PROCEDURE syntax? There are, he writes, advantages: “When scripting out a database you don?t have to generate if exists…..drop statements,” and disadvantages: “I can overwrite a proc without even knowing it.” Of course, the commenters have opinions of their own, and the piece becomes a straw poll for the desirability of that syntax as a feature.
Aaron Bertrand has one too: when was my database/table last accessed? Writes Aaron, “SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected overhead. And people continue to be reluctant or unable to constrain table access via stored procedures, which could otherwise perform simple logging.” He looks at 2008’s built-in auditing, and for those who can’t wait for that, illustrates a workaround for 2005.
Linchi Shea explores something else from 2008, Page Compression, focusing on how the number of processors affects the rebuilding a table with page compression.
Jamie Thomson, the SSIS Junkie writes that he has made a submission to Connect on the matter of absolute and relative paths in SSIS. “. . . I have always agreed that stipulating the use of absolute paths within SSIS was the right thing to do (and indeed I have championed it) however of late I have changed my mind. Support for relative paths would greatly simplify package deployment and package management . . . What do you think? Should SSIS support relative paths?” So far, it looks like a shoo-in.
Brian Knight also explains another little quirk, SSIS Case Sensitivity: “The case sensitivity can in some cases create behavior that is not expected and may give you bad results if you’re not careful. . . . One such example is with the Lookup Transform, where comparisons against the cache are case sensitive. If you do not expect this, you may have a miss in a match that is actually a hit.”
In the MySQL ’sphere this week, there is plenty of talk about the openness or otherwise of MySQL. (more…)
EJB 3.1 in GlassFish V3 TP2
In this blog, I will describe some of the EJB 3.1 features that are available in GlassFish V3.
For a full list of what is planned in EJB3.1 please refer to Ken's blog
Note: Before, you run any of the EJB 3.1 applications ensure that you follow the steps outlined in Installing EJB container in GlassFish V3Vertical and Horizontal Clustering with ColdFusion
Clustering in particular with ColdFusion and JRun can get fairly complicated pretty fast and I urge all who are going to embark on clustering to plan out how you want to cluster and why.
Another key issue is to make sure when we are creating a web application that it designed and engineered from day one with clustering in mind. I have helped so many clients who hit major problems when they start building clusters, largely because the application was too tightly coupled to the environment it is running in. Hard-coded directory paths would be a classic example.
In this blog posting I wanted to illustrate an interesting concept, well two in reality, Horizontal Clustering and Vertical Clustering. Let's look at a diagram....Be Cautious About Rolling Back To JVM 1.5
There have been several blog posts recently about class-loading issues apparently linked the use of the Sun-Java 1.6 (6.0) JVM. Mark Mandel has a detailed article on this here.
Before seeing this article we had been working on optimizing a ColdSpring-ModelGlue-Reactor application. We blogged our progress in this article.
We thought a reality check was a good idea and ran some load tests comparing this same application performance in Java 1.5 and 1.6. Once again we observed better performance in 1.6; here are the results.
These results are for a 50 Virtual User (vUser) Test for 1 hour with 8 second think time (delay between clicks) comparing Java 1 5 to 1.6.
Firstly Java 1.5
Total Number of Clicks: 13,345 (0 Errors)
Average Click Time of all URLs: 5,298 msHigh Availability - Clustering
I have added several blog postings here before on the theories of High-Availability (HA) and Clustering. In this series of blog postings I will be attempting to create dedicated postings for the following scenarios. Please keep in mind that there will be alternative ways to do these things and what I am showing here is drawn from my experiences from either creating clusters for clients or working on existing clusters
Here are the scenarios I will be posting on...
Setting up a two instance cluster from a fresh install of ColdFusion
Load testing a two instance cluster on Java 1.6 (6.0) using the Round Robin algorithm
Load testing a two instance cluster on Java 1.5 (6.0) using the Round Robin algorithmTroubleshoot POP3 Mail Server with Telnet
The other day I had a number of users complaining about not being able to fetch mail to their mail client, MS Outlook. As usual, I attempted to duplicate the error. The error message was reporting unable to connect to the mail server. At that point, I decided to telnet the Post Office Protocol or POP3 port, 110, via the command line interface. Sure enough, I had a problem.
Note: The “before and after” command line examples are only for illustration purposes.
# telnet server 110
Trying 192.1xx.xx.xxx...
telnet: Unable to connect to remote host: Connection refused
I started thinking there was a problem with the inetd.conf file. After reviewing the file, I noticed the pop3 service was commented out. The appropriate change was made and inetd was restarted. Problem resolved.
# telnet server 110
Trying 192.1xx.xx.xxx...
Connected to server.
Escape character is '^]'.
+OK connected to pop3 on 3429
By the way, you can check out other popular port services, too.
# telnet server 6667
# telnet server 25