webproguy
07-31-2003, 11:46 PM
Welcome to WebProWorld's forum for discussion of database issues.
Here are some articles from our WebProNews database that may be of interest:
SQL Errors 101
http://www.webpronews.com/wpn-20-20030519SQLErrors101.html
Many programmers hit a brick wall in their SQL queries, slowing development to a crawl and causing an over abundance of hair loss and coffee consumption. If you have been staring at the screen with a blank look and a pounding heart, wondering what you...
Understanding MySQL Privileges in Linux
http://www.webpronews.com/wpn-20-20020313UnderstandingMySQLPrivilegesinLinux.html
MySQL has become increasingly popular in the last year because of its ease of use and price. Setting up a MySQL Server on a Windows machine is so easy you may not even realize it is there. Installing MySQL on a Linux machine isn't quite as easy, but...
The Data Access Dilemma
http://www.webpronews.com/wpn-27-20030409TheDataAccessDilemma.html
Whether it is an Internet or Intranet, a web catalog or an e-commerce site with shopping cart, somewhere these applications are accessing a data...
Hooking Up To A Database Using Servlets
http://www.webpronews.com/wpn-20-20020307HookingUpToADatabaseUsingServlets.html
In the first part of this article, I did not present any installation procedures and I felt that I left you in the cold. Therefore, I will do it here. Please keep in mind that the program presented here in not very difficult and if you cannot connect to...
An Introduction to PHP and MySQL
http://www.webpronews.com/wpn-20-20020308AnIntroductiontoPHPandMySQL.html
Setting up your own Windows e-commerce site may seem like a daunting task at first. There is quite a bit to know, though with a basic understanding of the underpinnings and a few good tools, be on your way in no time at...
Search Engines vs. Database-Driven Websites - Optimizing PHPhttp://www.webpronews.com/wpn-4-20030521SearchEnginesvsDatabaseDrivenWebsitesOptim izingPHP.html
Dear Jim I have a question regarding a e commerce site using PHP extensions vs. html. That is, I have seen at this SEO site that there might be an issue with search engines being able to crawl this kind of a site, since these are javascript sites I...
SQL Server Startup Parameters
http://webpronews.com/wpn-20-20030630SQLServerStartupParameters.html
Every now and then we all have to reread something we may already know because frankly if you are like me, you can't keep everything in your head. I tend to go back over tips and tricks and even database concepts when I have time so I will maybe remember enough about it so when a problem arises I at least know where to go look and find the answer. It is with, that I want to write about my latest re-education attempt.
Oracle vs. SQL Server: An Issue of Complexity
http://www.webpronews.com/wpn-20-20010709OraclevsSQLServerAnIssueofComplexity.html
Software is only as complicated as its developers make it. It seems like a very profound sentence but it is so true and it is relevant to all commercial software that I know of. Let's take a test case of a certain piece of software most of us have...
Lee Gould Answers MS SQL Server, Sybase, and Oracle Questions
http://www.webpronews.com/wpn-38-20030509LeeGouldAnswersMSSQLServerSybaseandOracleQ uestions.html
Database Programming With Java + JDBC: Part 1/4
http://www.webpronews.com/wpn-37-20021101DatabaseProgrammingWithJavaJDBCPart14.html
SQL Server 2000 Active Directory Integrationhttp://www.webpronews.com/wpn-20-20030408SQLServer2000ActiveDirectoryIntegration.ht ml
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. The purpose of this article is to present their...
Small Business Server and e-Commerce Capacity
http://webpronews.com/wpn-20-20030630SmallBusinessServerandeCommerceCapacity.ht ml
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.
Connecting to a Database in a Visual C++ Application
http://www.webpronews.com/wpn-20-20011115ConnectingtoaDatabaseinaVisualCApplication .html
With the ease of working with a database in web based programming languages such as PHP and ASP, database connections in Visual C++ are often overlooked. But C++ offers the versatility and sheer power that web based languages can't always muster up, and...
Auditing Your SQL Server Environment Part I
http://webpronews.com/wpn-20-20030616AuditingYourSQLServerEnvironmentPartI.html
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.
Auditing Your SQL Server Environment Part II - Reviewing your Role Membership
http://webpronews.com/wpn-20-20030728AuditingYourSQLServerEnvironmentPartIIRevi ewingyourRoleMembership.html
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.
Inputting A Text File Into SQL Server Using T-SQL
http://webpronews.com/wpn-20-20030715InputtingATextFileIntoSQLServerUsingTSQL.h tml
Question: Is it possible to input a text file into SQL Server using T-SQL?
Regular Expressions in T-SQL
http://webpronews.com/wpn-20-20030705RegularExpressionsinTSQL.html
I recently had the problem of trying to search for a regular expression in a database field. There is no version of SQL Server that supports regular expressions natively, but I discovered a way to add all sorts of regular expression goodness to your T-SQL applications. In order to use regular expressions easily, we can use a User Defined Function to help us out and abstract the work for us.
How to implement generators in MSSQL server
http://webpronews.com/wpn-20-20030602HowtoimplementgeneratorsinMSSQLserver.html
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.
For more articles just click here:
http://www.webprowire.com/exec/searchi?r=30&q=database&p=&h=&w=&X=383&sc=&mx=65&sd=&sm=&sy=&ed=&em=&ey=
Thanks!
Here are some articles from our WebProNews database that may be of interest:
SQL Errors 101
http://www.webpronews.com/wpn-20-20030519SQLErrors101.html
Many programmers hit a brick wall in their SQL queries, slowing development to a crawl and causing an over abundance of hair loss and coffee consumption. If you have been staring at the screen with a blank look and a pounding heart, wondering what you...
Understanding MySQL Privileges in Linux
http://www.webpronews.com/wpn-20-20020313UnderstandingMySQLPrivilegesinLinux.html
MySQL has become increasingly popular in the last year because of its ease of use and price. Setting up a MySQL Server on a Windows machine is so easy you may not even realize it is there. Installing MySQL on a Linux machine isn't quite as easy, but...
The Data Access Dilemma
http://www.webpronews.com/wpn-27-20030409TheDataAccessDilemma.html
Whether it is an Internet or Intranet, a web catalog or an e-commerce site with shopping cart, somewhere these applications are accessing a data...
Hooking Up To A Database Using Servlets
http://www.webpronews.com/wpn-20-20020307HookingUpToADatabaseUsingServlets.html
In the first part of this article, I did not present any installation procedures and I felt that I left you in the cold. Therefore, I will do it here. Please keep in mind that the program presented here in not very difficult and if you cannot connect to...
An Introduction to PHP and MySQL
http://www.webpronews.com/wpn-20-20020308AnIntroductiontoPHPandMySQL.html
Setting up your own Windows e-commerce site may seem like a daunting task at first. There is quite a bit to know, though with a basic understanding of the underpinnings and a few good tools, be on your way in no time at...
Search Engines vs. Database-Driven Websites - Optimizing PHPhttp://www.webpronews.com/wpn-4-20030521SearchEnginesvsDatabaseDrivenWebsitesOptim izingPHP.html
Dear Jim I have a question regarding a e commerce site using PHP extensions vs. html. That is, I have seen at this SEO site that there might be an issue with search engines being able to crawl this kind of a site, since these are javascript sites I...
SQL Server Startup Parameters
http://webpronews.com/wpn-20-20030630SQLServerStartupParameters.html
Every now and then we all have to reread something we may already know because frankly if you are like me, you can't keep everything in your head. I tend to go back over tips and tricks and even database concepts when I have time so I will maybe remember enough about it so when a problem arises I at least know where to go look and find the answer. It is with, that I want to write about my latest re-education attempt.
Oracle vs. SQL Server: An Issue of Complexity
http://www.webpronews.com/wpn-20-20010709OraclevsSQLServerAnIssueofComplexity.html
Software is only as complicated as its developers make it. It seems like a very profound sentence but it is so true and it is relevant to all commercial software that I know of. Let's take a test case of a certain piece of software most of us have...
Lee Gould Answers MS SQL Server, Sybase, and Oracle Questions
http://www.webpronews.com/wpn-38-20030509LeeGouldAnswersMSSQLServerSybaseandOracleQ uestions.html
Database Programming With Java + JDBC: Part 1/4
http://www.webpronews.com/wpn-37-20021101DatabaseProgrammingWithJavaJDBCPart14.html
SQL Server 2000 Active Directory Integrationhttp://www.webpronews.com/wpn-20-20030408SQLServer2000ActiveDirectoryIntegration.ht ml
SQL Server 2000 was designed to operate as an integral part of the Windows 2000 domain environment. Unfortunately, the new features that best exemplify this integration are rarely taken advantage of. The purpose of this article is to present their...
Small Business Server and e-Commerce Capacity
http://webpronews.com/wpn-20-20030630SmallBusinessServerandeCommerceCapacity.ht ml
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.
Connecting to a Database in a Visual C++ Application
http://www.webpronews.com/wpn-20-20011115ConnectingtoaDatabaseinaVisualCApplication .html
With the ease of working with a database in web based programming languages such as PHP and ASP, database connections in Visual C++ are often overlooked. But C++ offers the versatility and sheer power that web based languages can't always muster up, and...
Auditing Your SQL Server Environment Part I
http://webpronews.com/wpn-20-20030616AuditingYourSQLServerEnvironmentPartI.html
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.
Auditing Your SQL Server Environment Part II - Reviewing your Role Membership
http://webpronews.com/wpn-20-20030728AuditingYourSQLServerEnvironmentPartIIRevi ewingyourRoleMembership.html
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.
Inputting A Text File Into SQL Server Using T-SQL
http://webpronews.com/wpn-20-20030715InputtingATextFileIntoSQLServerUsingTSQL.h tml
Question: Is it possible to input a text file into SQL Server using T-SQL?
Regular Expressions in T-SQL
http://webpronews.com/wpn-20-20030705RegularExpressionsinTSQL.html
I recently had the problem of trying to search for a regular expression in a database field. There is no version of SQL Server that supports regular expressions natively, but I discovered a way to add all sorts of regular expression goodness to your T-SQL applications. In order to use regular expressions easily, we can use a User Defined Function to help us out and abstract the work for us.
How to implement generators in MSSQL server
http://webpronews.com/wpn-20-20030602HowtoimplementgeneratorsinMSSQLserver.html
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.
For more articles just click here:
http://www.webprowire.com/exec/searchi?r=30&q=database&p=&h=&w=&X=383&sc=&mx=65&sd=&sm=&sy=&ed=&em=&ey=
Thanks!