Home > Articles > Data > SQL

SQL

83 Items

Sort by Date | Title

T-SQL Enhancements in SQL Server 2005
Jul 30, 2004
SQL Server 2005 includes a plethora of new features and tools that can help developers more efficiently and effectively manage data. This article provides a preview of the new features and their use.
Using MySQL Client Programs
Jul 23, 2004
This chapter discusses general principles that are common to most MySQL client programs. It also describes how to use several specific types of clients. Sample questions with detailed answers are provided at the end of the chapter to help you prepare.
Managing Transaction Processing for SQL Database Integrity
Jul 9, 2004
In this lesson, Ben Forta explains SQL transactions, how the COMMIT and ROLLBACK statements can be used to manage data, and the use of savepoints.
Building a Visual FoxPro Application for SQL Server
Jul 2, 2004
Learn how to build a data access layer to communicate with either DBFs or SQL Server. Even cooler, you'll do it with no code to change when you move from DBFs to SQL tables, and an upsizing wizard to migrate the data for you. Find out how to use a data access layer in FoxPro, which gives you the ability to use DBFs, SQL Server, a WebConnection XML server, or XML Web services.
Sorting Retrieved Data from SQL Databases
Jun 18, 2004
In this lesson, taken from Sams Teach Yourself SQL in 10 Minutes, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.
Overcoming High-Latency Database Access with Java Stored Procedures
May 13, 2004
Java Stored Procedures: a way to put slow Java code in your otherwise fast database or a quick solution for certain database performance problems? They can be both, as it turns out. Tim Stevens takes a look at a situation in which the adoption of Java Stored Procedures quickly and effectively solved some serious performance issues in a database-driven system, all without a complete rewrite of existing database code.
Maintaining Transactional Replication
Apr 30, 2004
Contrary to popular belief, replication is not maintenance-free. As your application and business rules change, so do publications. Baya Pavliashvili dissects the terms and techniques necessary for maintaining transactional replication and gives you sage advice on fine-tuning your replication performance.
Relationships Should NOT Be Natural!
Apr 30, 2004
Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.
Monitoring and Troubleshooting Transactional Replication
Apr 23, 2004
So you set up replication and it works for a week. Then one fine day your pager goes off. Now what? Where do you look for clues? How do you troubleshoot? How can you tell if your replicated system performs well? Read on to find out the answers from Baya Pavliashvili.
Setting Up Transactional Replication with SQL Server
Mar 26, 2004
Setup isn't the only piece of the replication puzzle; yet getting it wrong can cause many headaches. In this second episode of his replication series, Baya Pavliashvili teaches you how to set up replication through wizards and through scripts.
Microsoft Yukon: Worth the Wait?
Mar 19, 2004
Despite the well-known shipping delays, some beta testers are actually quite avid about Microsoft's upcoming SQL Server 2003, code-named Yukon. Tech journalist Jacqueline Emigh interviewed PhotoWorks' Don Watters, one DBA who thinks that Yukon will be worth the wait. Watters is a strong believer in Yukon's native XML integration and redesigned DTS. However, Microsoft still has work ahead in terms of database security, usability, and a variety of other areas, the beta tester admits.
Introduction to Database Replication
Mar 5, 2004
Replication involves much more than setup, just as marriage involves much more than a honeymoon. And there aren't many sources of information for replication implementation and troubleshooting. In this first in a series on replication, Baya Pavliashvili fills in some of the gaps for you by detailing replication types and giving you a general overview.
Basic SQL Coding for DB2 Universal Database for OS/390
Jun 27, 2003
Take a look at the four primary statements of DML: Select, Update, Insert, and Delete. You will learn the function each of these can play in your efforts to master DB2. You will also look at various aspects of SQL, a necessary language to understand though the comprehension level will vary depending on the user's activity.
SQL Essentials
May 30, 2003
This sample chapter will get your feet wet in the basic functions of SQL. David Gallardo goes through the primary features of the database language, including comprehensive working examples.
SQL Server: Advantages and Drawbacks of User-Defined Functions
May 16, 2003
Why are UDFs important? What can you do with UDFs that you can't do with stored procedures? Although UDFs are not functionally stronger than stored procedures, they do provide certain advantages. Baya Pavliashvili discusses the advantages and limitations that are associated with UDFs and shows you the coding tasks that qualify as good candidates for UDFs.
SQL Server User-Defined Functions (UDFs)
May 2, 2003
When you can't find a built-in function that meets your needs, you can write your own. This fifth article continues Baya Pavliashvili's series on system-supplied functions by introducing you to various types of user-defined functions (UDFs). Learn about their syntax and situations in which each one is useful.
SQL Server String, Cursor, Security and Rowset Functions
Apr 18, 2003
Baya Pavliashvili continues his series on system-supplied functions by discussing the string, security, cursor, and rowset functions. Also discover some extra features, which are not mentioned in the SQL Server online documentation.
SQL and Data
Apr 11, 2003
Working through an interactive workbook, get to know SQL by exploring the basics of data storage, schema diagrams, data normalization rules, and table relationships.
Date, Math and Text Functions in SQL Server 2000
Apr 4, 2003
In this third article in his series on functions, Baya Pavliashvili continues to explore various types of built-in functions, including the most frequently used math, text, date, and time functions.
The Database Normalization Process
By Ryan Stephens
Jan 24, 2003
Find out what normalization is and how your database can benefit from it (or suffer from it). Learn the advantages, disadvantages, and some techniques and guidelines to doing it yourself.

<< < Prev Page 1 2 3 4 5 Next >