To stay competitive and compliant, organizations need to deliver information generated in business applications more quickly, improve internal workflow and ensure document security–all while reducing costs and providing superior products and services. (R)
Author: SSWUG Research
Enterprise Data Management with SQL (Sample Chapter)
(Eric L. Brown) In the beta history of the SQL Server 2005 release, significant emphasis has been put on the new features for developing applications. Let’s just say that Microsoft loves developers. But what happened to the features for those who get paged in the middle of the night when mission-cri
Follow the evolution of an SQL query and automate your database reporting
Creating an automated SQL query that will retrieve timely data and transmit that information to a person who can act upon it is a basic task for many SQL Server database administrators. However, the process for developing that automated query is not always as obvious as you might expect. This downlo
Deploying ASP.Net 2.0 Web site in a Production Server
(Moustafa Arafa) Deploying ASP.NET 2 web site is the first issue facing the developer after finishing to create a web site is how to deploy the web site to a remote/Production server.
Who Needs a Data Warehouse?
(Gabriel Fuchs) At a previous job, we realizeded that we needed a data warehouse. It was actually quite easy to make this decision – everyone else had one – so, therefore, we should obviously have one as well. In order to be better than everyone else, we, however, did not stop at a data warehouse. W
Dealing with Wildcard Characters in Oracle
(MS Sridhar) Developers generally tend to use characters such as % as a delimiter for storing data in an Oracle database. But because Oracle views the % character as a Wildcard character, it can’t use it as a delimiter effectively. Fortunately, Oracle provides a way out for such a problem—the ESCAPE
A tutorial on Call Control XML and voice browser call control
(Peter V. Mikhalenko) In the last article about SCXML we talked about state machine notations and noted that many concepts were taken from Call Control XML (CCXML) language. The first draft of CCXML specification appeared in the early 2002, and still remains in a working draft status. However, lack
XSD Schemas for VB Developers – Why Schemas?
(Yasser Shohoud) As you develop distributed Web applications, you will need a way to represent your structured data and send it from one tier to the other possibly over the Web. XML is an excellent choice for representing structured data. For example, you’ll find yourself sending XML data between th
Protecting a MySQL user/password in a PHP script
(Greg Beaver) UPDATE 2: Thanks to Chris Shiflett, who provided a link to a real answer in his comment. Clearly, the way to do this within the environment where you have one host and lots of ~users is to use .htaccess. Each user would define in their own /home/user/public_html/.htaccess two environme
Building an XSL Transform Tool
(Michael K. Campbell) A while back I got tired of looking for a simple solution to performing ‘on the fly’ XSL Transformations. I didn’t want some memory-hog tool to completely isolate me from the details of the transform through layers of abstraction—just a light-weight tool that would act as a sim