Home > Articles > Data > SQL


RSS Feed Subscribe to this topic  RSS details

83 Items

Sort by Date | Title

Adding a User to a Database
By Richard Waymire
Nov 6, 2000
Everything you do in SQL Server is authenticated, including creation of the databases and files. Understanding SQL Server security is critical to the successful operation of your SQL Server.
Administering the SQL Server 2005 Database Engine
By Alec Minty, Chris Amaris, Ross Mistry, Rand Morimoto
Nov 2, 2007
Learn to administer the Database Engine component and manage the SQL server properties and database properties.
An Introduction to SQL
By Ewald Geschwinde, Hans-Juergen Schoenig
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.
By Matthew David
Jan 1, 2003
Backup Considerations
By Richard Waymire
Nov 6, 2000
Perhaps the most important but least glamorous aspect of supporting a relational database is backup and recovery. No matter how much work you do to make your database secure and your data available, data protection is the most critical aspect of your ...
Basic SQL Coding for DB2 Universal Database for OS/390
By Susan Lawson
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.
Building a Visual FoxPro Application for SQL Server
By Les Pinter
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.
Creating a Database in SQL Server 2000
By Rick Sawtell
Nov 6, 2000
When you create a new database, you are really just making a copy of the model database. Remember that everything in the model database, including any database options that you may have set, will show up in any new databases you create. After you create ...
Date, Math and Text Functions in SQL Server 2000
By Baya Dewald
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.
Enhanced Connectivity from SQL to SharePoint to Office
By J. Peter Bruzzese
Jul 12, 2010
Flexible dynamic data access is an impressive improvement to SharePoint 2010 that provides both read and write capabilities back to an external data source, like SQL, so that you can adjust data between Office, SharePoint and SQL. In this article we will show you how!
Generating Atom Feed from SQL Data
By Ivan Pepelnjak
Mar 31, 2008
Ivan Pepelnjak describes how you can create an Atom feed directly on the SQL Server with Transact SQL commands.
Getting Started with MySQL and SQL
By Paul Dubois
Apr 1, 2005
Perfect for SQL novices, this chapter provides an introduction to the MySQL relational database management system (RDBMS), and to the Structured Query Language (SQL) that MySQL understands.
InformIT Visual Tutorial 3: Structured Query Language (SQL)
By Nick V. Flor, Nancy Flor
Jul 6, 2001
A database lets you safely store and retrieve data from your Web site's users. To get to that data, you use Structured Query Language (SQL).
Inside SQL Server 2005 Management and Administration Tools
By Dima Sonkin, Thierry D’Hers, Kami LeMonds, Michael Raheem
Dec 22, 2006
SQL Server Management Studio is a rich and comprehensive tool that enables many management and administration scenarios. This sample chapter provides some tips and tricks for using the tool, straight from the Microsoft team that created it.
Introduction to Database Replication
By Baya Dewald
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.
Joining Tables in SQL Queries
By Ron Plew, Ryan Stephens
Oct 25, 2002
This lesson teaches the reader how to join multiple tables in a single query in order to optimize the use of the data stored in the database.
Loading Images into SQL Server with C#
By Jesse Smith
Jul 8, 2005
As your web site grows and images multiply, storing those images on the hosting server's hard drive can turn a zippy hare of a site into a pokey tortoise. (Yes, they get there eventually, but users are impatiently waiting for a "photo finish"!) Jesse Smith provides a set of simple C# scripts that you can use to pop your images into your SQL Server database, for faster image retrieval and better load balancing on your site.
Maintaining Transactional Replication
By Baya Dewald
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.
Managing Database Objects in SQL
By Arie D. Jones, Ron Plew, Ryan Stephens
Jul 1, 2008
This chapter discusses what database objects are, how they act, how they are stored, and how they relate to one another.
Managing SQL Database Objects
By Arie D. Jones, Ron D. Plew, Ryan Stephens
Jun 16, 2011
In this chapter you will learn about database objects: what they are, how they act, how they are stored, and how they relate to one another.

Page 1 2 3 4 5 Next >