Home > Articles > Data > SQL Server

SQL Server

179 Items

Sort by Date | Title

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.

Page 1 2 3 4 5 Next >