SQLProNews - Articles For SQL Users

Free Newsletters

Part of the iEntry Network
over 4 million subscribers

SQLpronews

FlashNewz

NetworkNewz

Send me relevant info on products and services.

Newsletter Archive: 2003

Build A Servlet-based Application That Executes SQL Statements Against A Database

This tutorial shows how to use a Java servlet, a JavaServer Page (JSP), and a static Java class to create an application that can be used to interactively execute any standard SQL statement against a database that's running on a server. You can use an application like this one to work with a database as you're developing an application. In this article, this application will be referred to as the SQL Gateway application.

http://www.sqlpronews.com/2003/1121.html

11.21.03

How to Search for Date and Time Values

Suppose you’re writing a query to find all the invoices that were written on January 6, 2003. You know from the control totals that 122 invoices were written that day. But when you run this query:

http://www.sqlpronews.com/2003/1031.html

10.31.03

SQL Server Upgrade Recommendations and Best Practices

As the DBA in your organization, you are central to the success of the SQL Server environment. In the case of a system upgrade, you need to act as a ‘driver’ for an upgrade project to ensure success based on your technical expertise and role in the organization. Over this multi-part series, these articles will outline proven and recommended best practices for the upgrade process.

http://www.sqlpronews.com/2003/1010.html

10.10.03

Comparing Database Structures in MSSQL Server

Many firms, developing client-server applications, have a lot of the databases, from developers DB to testers DB. Keeping DB in actual state can be automated easily only if there is centralized access to all of them and there are no developments on any of them. The last influences a lot of the DB structure because there is a possibility to break it while developing.

http://www.sqlpronews.com/2003/0917.html

09.17.03

Learn About SQL Server Disaster Recovery

Disaster recovery is a topic on the minds of many DBAs. Learn some of the basics about SQL Server disaster recovery from a leading expert in the area, Greg Robidoux of Edgewood Solutions. Greg is currently the Vice Chair for the PASS DBA Special Interest Group (SIG). In addition, he recently gave two presentations at the PASS Summit in Seattle on Change Management and Project Management for DBAs.

http://www.sqlpronews.com/2003/0910.html

08.05.03

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. Transact-SQL provides you with a set of table-level locking hints that you can use with SELECT, INSERT, UPDATE, and DELETE statements to tell SQL Server how you want it to lock the table by overriding any other system-wide or transactional isolation level.

http://www.sqlpronews.com/2003/0821.html

08.21.03

Auditing Your SQL Server Environment Part II - Reviewing Your Role Membership

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.

http://www.sqlpronews.com/2003/0728.html

07.28.03

Regular Expressions In T-SQL

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.

http://www.sqlpronews.com/2003/0707.html

07.07.03

SQL Server Startup Parameters

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.

http://www.sqlpronews.com/2003/0703.html

07.03.03

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.

http://www.sqlpronews.com/2003/0604.html

06.04.03

The Power of Partitioning

Misconceptions about partitioning abound. Experts from the Toronto Lab set the record straight about this useful feature.

http://www.sqlpronews.com/2003/0501.html

05.01.03

xp_regex: Regular Expressions in SQL Server 2000

xp_regex is an Extended Stored Procedure for SQL Server 2000 written in Managed C++ that lets you use Regular Expressions from T-SQL. In case you’re skeptical about the performance when mixing non-.NET code (in this case SQL Server) and .NET code in the same process, I can tell you that I wrote a completely non-.NET version using the Boost Regex++ Regular Expression library and the speed was actually slightly slower. Plus, the .NET Regular Expression library is pretty much a complete implementation of Perl 5.6's (the de factostandard).

http://www.sqlpronews.com/2003/0419.html 04.19.03

Submit Article | Advertising Information | About Us | Contact