Other News

Community

Mapping user and login security

(Baya Pavliashvili) If you use SQL Server authenticated logins to connect to databases, the following scenario should sound familiar: you backup the database on the production server, restore it on the development/test server and the application doesn’t work. What’s wrong? You immediately check

Community

Explore sequence diagrams

(Kirk Knoernschild) The purpose of a class diagram is to show the structural makeup of an application. An application’s structure is dictated by the dynamics of class collaborations. In UML, we commonly represent the dynamic aspects of class collaborations using a sequence diagram. Let’s now explore

Community

Telnet and REST Web Services?

(Bob DuCharme) “Telnet” usually refers to a terminal emulation program that uses the telnet protocol to talk to a server. It’s been most popular for gaining shell access to remote computers, especially over dial-up lines in the old days, but you can also use it to submit commands to a web server if

Community

MySQL Administrator

(Ian Gilfillan) On the 1st December, 2004, MySQL AB released a new version of MySQL Administrator (version 1.0.17). I had not previously used this tool, but with some time on my hands and the work crisis averted thanks to the installation of our new database server, I thought I would see how it shap

Community

Overview of Oracle Spatial

(Ravikanth V. Kothuri, Albert Godfrind and Euro Beinat) Oracle Spatial technology is spread across two tiers: the Database Server and the Application Server. Figure 2-1 depicts the various components that comprise Oracle’s spatial technology stack and indicates the distribution of the components ac