- Administering Storage, I/O, and Partitioning in Microsoft SQL Server 2012
- Sep 27, 2012
- This chapter focuses on the use and most effective configuration of storage components within a Database Engine instance of SQL Server 2012.
|
- Administering the SQL Server 2005 Database Engine
- Nov 2, 2007
- Learn to administer the Database Engine component and manage the SQL server properties and database properties.
|
- Alison's SQL Server 2000 Tips
- Aug 6, 2001
- Alison Balter provides tips on returning multiple records sets and executing the "first and last after trigger" in SQL Server 2000.
|
- Alison's SQL Server 2000 Tricks
- Aug 6, 2001
- Learn a few SQL Server 2000 tricks from expert Alison Balter.
|
- Alternatives to LAMP
- Jun 2, 2006
- The LAMP configuration (Linux, Apache, MySQL, and PHP) is familiar to the open source universe. But just because this combination of products is comfortable, that doesn't mean that it provides the best solution for your systems. David Chisnall suggests some alternatives that might make a better match for your needs.
|
- An Interview with Bert Scalzo and Dan Hotka on Toad for Oracle
- Aug 27, 2015
- Data expert Phyllis Helton talks to Bert Scalzo and Dan Hotka, co-authors of Toad for Oracle Unleashed, about some of their favorite features in Toad, their thoughts on GUI tools, and advice for people new to developing using Oracle and Toad.
|
- An Introduction to SQL
- Mar 15, 2002
- Structured Query Language (SQL) enables you to pose complex questions to a database. It also provides a means of modifying databases. Many databases support SQL, so you can apply this knowledge to MS SQL Server, DB2, Oracle, PostgreSQL, and countless other databases.
|
- An Oracle Programmatic and General Reference
- Dec 19, 2003
- Need to look up the Oracle operators, functions, format models, reserved words, and privileges? This handy set of charts, from the Oracle DBA SQL Quick Reference, will help you find what you need.
|
- An Overview of MySQL Query Browser's Features and Capabilities
- Sep 23, 2005
- This chapter discusses MySQL Query Browser, a client program that provides a graphical interface to the MySQL server for querying and analyzing data.
|
- Apache Hadoop YARN: A Brief History and Rationale
- Mar 24, 2014
- This chapter provides a historical account of why and how Apache Hadoop YARN came about.
|
- Appending an Access 2007 Form Using Email
- Jun 22, 2009
- Tom Bunzel explores the Access email form feature in detail, taking you through the process step by step and comparing it with other ways that also let you bring user data from external sources into an Access table.
|
- Application Performance Tuning
- Jul 12, 2002
- In this intro to their series on SQL Server database tuning, Baya Pavliashvili and Kevin Kline point out some of the larger-scale problems that can affect application performance.
|
- Applied Bioinformatics Computing: Data Mining
- Dec 6, 2002
- Data mining techniques are an automated means of reducing the complexity of data in large bioinformatics databases and of discovering meaningful and useful patterns and relationships in data. In the second article in his series on applied bioinformatics, author and technology expert Bryan Bergeron offers an overview of the methods, technologies, and challenges associated with data mining in bioinformatics.
|
- art_gore_outsourcing
- Jan 1, 2003
|
- Assigning Roles for Our Users in SQL Server 2000
- Oct 5, 2001
- In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne discusses and defines SQL Server 2000's 10 basic database roles, which allow for different levels of access to the database.
|
- Associating Data Dictionary Views with the Related X$ Tables
- Nov 6, 2000
- Once you are comfortable with the Oracle RDBMS as a DBA, you will find a lot of valuable information in x$ tables that won't be available anywhere else. Oracle expert Megh Thakkar shows how you can associate data dictionary tables with the related x$ ...
|
- Automatic Access: Using Wizards
- Mar 1, 2002
- The important concept in this sample chapter from Sams Teach Yourself Access 2002 in 21 Days is to understand that wizards can save you a lot of time and that you can study the generated database applications for ideas that you can use in your own database.
|
- Backing Up and Restoring in SQL Server
- Jan 25, 2002
- In its simplest form, the database backup and restore procedure for SQL Server 2000 is incredibly easy. In this excerpt from his book, Essential SQL Server 2000: An Administration Handbook, Buck Woody tells you why.
|
- Backup and Restore Technologies for Windows
- Aug 15, 2003
- Take a look at the evolution of backup applications for Windows. You will see where the applications have been, and what sort of features and requirements they have now.
|
- Backup Basics Part 1: Demystifying Server and Workstation Backup Methods
- Jun 16, 2006
- Understanding the options for backing up servers and workstations is important for any technician or system/server administrator. But for new IT staff, all the details about how backups work and how to configure them can be confusing. In this first article in a three-part series, Ryan Faas demystifies the various types of backups that can be performed on servers and workstations using most backup applications.
|