Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

SureSync Part 3: Setting Up Your First SureSync Relation (Mirroring)
Feb 8, 2002
In this third and final article on SureSync, expert Rob Hawthorne wraps up the discussion by detailing the setup of a Relation.
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.
My Baby Done Wrote Me a Letter (Using SQL Mail)
Jan 25, 2002
Use SQL Mail to send query results to a user or group of users, return queries sent to a SQL Server via e-mail, and even control a SQL Server through e-mail messages.
Normalizing Name Data in SQL Server
Jan 25, 2002
This article by Baya Pavliashvili demonstrates a real-world solution that lets you split names into first names, middle names, last names, and suffixes. You can apply this solution to your own name dilemmas.
SQL Profiler
Jan 25, 2002
In this excerpt from his book Essential SQL Server 2000: An Administration Handbook, Buck Woody gives a quick overview of the SQL Profiler tool, which is used to monitor SQL Server, all the way down to the individual SQL statements.
SQL Server Replication
Jan 25, 2002
How can you copy data from one place to another? In this excerpt from his book, Essential SQL Server 2000: An Administration Handbook, Buck Woody tells you how you can use replication with SQL Server.
String Manipulations with SQL Server 2000
Jan 25, 2002
There is a clear need for manipulating string data. This article by Baya Pavliashvili introduces you to the many string functions available in SQL Server, and gives you an example of how you can apply these functions in your code.
What’s Going On? Using SQL Server Web Wizard to Display Maintenance Results
Jan 25, 2002
Is there a way to check the status of maintenance plans from afar? The answer is yes; you can use the Web Assistant Wizard, a helpful SQL Server feature.
XML Support in Transact-SQL
Jan 18, 2002
Want to know more about XML? Read this article by Baya Pavliashvili for a brief overview of XML components and an introduction to Transact-SQL XML extensions.
Steps Involved in Building a Data Warehouse
Jan 11, 2002
The goal of a data warehouse is to provide your company with an easy and quick look at its historical data. This article by Baya Pavliashvili gives you an overview of what a data warehouse is and what it takes to build one.
Populating a Data Warehouse with SQL Server 2000
Nov 9, 2001
In this article, Baya Pavliashvili provides a tutorial for populating data warehouses. The article includes a number of tips for choosing the storage model, indexing fact and dimension tables, and much more.
SQL Server: Determining Whether a Date is a Business Day
Nov 9, 2001
Baya Pavliashvili demonstrates some of the built-in date-related functions and settings available in SQL Server through a user-defined function that helps you determine whether a given date falls on a business day.
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.
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.
Creating a User Interface for a Custom DTS Task
Oct 5, 2001
Marcelino Santos shows you how to add a user interface when creating a custom DTS task.
Creating an Index on Our Person Table to Increase Query Performance
Oct 5, 2001
In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne tells you how to create an index on a Person table and how to use SQL Server 2000's execution plan.
Enhancing DTS Package Performance
Oct 5, 2001
Jim Samuelson and Brian Sullivan show you how to improve the performance of your DTS Packages.
Performing General Administration Tasks in SQL Server 2000
Oct 5, 2001
Many database administration tasks can be done automatically with SQL Server 2000. In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne discusses the administrative tasks that can be automated by setting up ...
Using Online Resources to Explore SQL Server 2000
Oct 5, 2001
In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne discusses Books Online, which ships with SQL Server 2000. It is very comprehensive, and can help you with almost everything you need to know about the different ...
Using SQL Profiler to Find Errors
Oct 5, 2001
In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne tells you how SQL Profiler, as a problem-solving tool, can show you exactly what has been sent to the SQL Server by a client application.

<< < Prev Page 5 6 7 8 9 Next >