- 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.
|