- 31 SQL Server Tips That Can Save Your Butt
- Feb 18, 2005
- Want to get the most out of SQL Server 2000? We've collected more than two dozen tips and techniques that can make any DBA's life easier.
|
- Accessing SQL 2000 via HTTP
- Oct 26, 2001
- This sample chapter from XML and SQL Server discusses how the open-endedness of client/server architecture provides for enhanced extensibility. The HTTP protocol is examined for various ways to execute SQL statements against SQL Server.
|
- 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 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.
|
- 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.
|
- 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.
|
- 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 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 ...
|
- Benefits of Using SQL Server Stored Procedures with Visual Basic and Web Applications
- Aug 6, 2001
- Alison Balter highlights the benefits of using SQL Server stored procedures with Visual Basic and Web Applications stored procedures.
|
- 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.
|
- Case Study: eNom Moves to 2003 Clusters without Yukon
- Jan 30, 2004
- Internet domain services provider eNom has won a new and somewhat surprising differentiation on the database side. What are the pros and cons of running SQL Server 2000 in conjunction with Windows 2003 Cluster Server? Tech journalist Jacqueline Emigh talked with some folks at eNom to find out.
|
- Case Study: Realtime Trader Seeks 64-Bit Realtime Database
- May 7, 2004
- Learn how one company is using the next version of SQL Server. Rebecca Lewis of Townsend Analytics is a pivotal behind-the-scenes figure in an environment of fast-paced online trading. The IT systems director seeks a database that can keep completely up to speed. Lewis hopes that the 64-bit edition of SQL Server 2005, formerly codenamed Yukon, will prove itself able to do this job. So far, however, SQL 2005 isn't available for beta testing in 64-bit mode.
|
- Cloud Computing Reference Architecture: Data Ingress and Storage Access
- Oct 24, 2012
- Buck Woody, Senior Technical Specialist on Windows Azure at Microsoft, describes how to create a centralized, off-premises (cloud-based) data store that provides flexibility, security, consistency, and guards against vendor lock-in.
|
- 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 ...
|
- Creating a Simple SQL Server 2005 Notification Application: Stock Quotes
- Mar 31, 2006
- In this chapter, you'll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross the price targets they specify.
|
- Creating a SQL Server Database
- Nov 25, 2015
- This lesson from T-SQL in One Hour a Day, Sams Teach Yourself covers how to create a SQL Server database, how to set database options, how to work with the Transaction Log, and how to attach to an existing database.
|