- Adding a User to a Database
- 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
- Nov 2, 2007
- Learn to administer the Database Engine component and manage the SQL server properties and database properties.
|
- 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.
|
- art_gore_outsourcing
- Jan 1, 2003
|
- Backup Considerations
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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)
- 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
- 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
- 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
- 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#
- 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
- 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
- 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
- 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.
|