Tag: server

Small Business Server and e-Commerce Capacity

Question: I’m a partner (one of six) in a small business and am trying to deploy our web site with an attendant web-based application (survey data collection and reporting). The system is being designed in Java and is using SQL Server as the back-end. We were thinking of launching this on a box running MS Small Business Server 2000 (as it would then also obviate a number of other small business software needs, such as email with Exchange server, internet security, etc.). Is this deployment strategy reasonable? Does SBS handle enough anonymous TCP/IP connections to do e-commerce where we don’t know how many people my be trying to connect to our database to buy stuff?

Any help you can provide will be greatly appreciated.

Auditing Your SQL Server Environment Part I

Over the last few years I have been a roving SQL Server DBA contractor and tended to work contacts in small and mid-size companies that involved organizing, documenting and then tuning/optimizing existing SQL Servers in those companies. I have noticed one very disturbing truth over the years; no one seems to document anything. In fact, I was usually thankful if I could find something or someone who knew the sa passwords on each SQL Server installation, let alone knew anything else about their setups.

How to implement generators in MSSQL server

One of the important properties of any client-server application is its serviceability and an intuitive user interface. Many widely used relational database management systems have a lot of opportunities to choose different user interface features. Intending to make a program decision easy and convenient, and, at the same time, to keep the referential integrity of the database, it is often necessary to know the values of the key fields of the processed tables before their real inserting.

An Introduction to Network Firewalls and Microsoft Internet Security and Acceleration Server

Everyone needs a firewall. If you run a web site, have a dial-up connection or control a corporate backbone you have to install a firewall. This will allow the control of what internal information from your network or computer is allowed to go out, and what information is allowed to come in. Taking advantage of a simple firewall installation can help you preserve your data and report all attempts of unauthorized access.

Back To Top