- 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.
|