SQL Server

179 Items

Sort by Date | Title

Setting Up Transactional Replication with SQL Server: Mar 26, 2004; Setup isn't the only piece of the replication puzzle; yet getting it wrong can cause many headaches. In this second episode of his replication series, Baya Pavliashvili teaches you how to set up replication through wizards and through scripts.

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.

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.

Using SQL Server's XML Support: Jan 16, 2004; SQL Server is an XML-enabled DBMS, which can read and write XML data, return data from databases in XML format, and read and update data stored in XML documents. In fact, SQL Server has eight different ways to use XML. Learn how each of them works, and how they interoperate.

Transforming Data with Microsoft SQL Server 2000 DTS: Nov 26, 2003; With the Data Transformation Services (DTS) in SQL Server 2000, you can import, export, and transform data from disparate sources into single or multiple destinations. This article shows you how to build your own DTS packages and the basics on how to use ActiveX code to transform data.

Understanding Microsoft SQL Server 2000 Analysis Services: Sep 5, 2003; Analyzing data stored in OLTP systems is time-consuming and can eat computer resources. OLAP technology can provide a speedier and more effective use of your data.

SQL Server 2000 and XML: Aug 8, 2003; Discover the many different ways SQL Server 2000 supports XML with a comprehensive look at both out-of-the-box support and the SQLXML 3.0 add-on.

Oracle Web Application Programming for PL/SQL Developers: Remote Server Access: Jun 20, 2003; Get the basics of remote server access as well as how you can benefit from this access today. You will experience workable examples that will bring you to an immediate and practical understanding of remote server access.

SQL Server: Advantages and Drawbacks of User-Defined Functions: May 16, 2003; Why are UDFs important? What can you do with UDFs that you can't do with stored procedures? Although UDFs are not functionally stronger than stored procedures, they do provide certain advantages. Baya Pavliashvili discusses the advantages and limitations that are associated with UDFs and shows you the coding tasks that qualify as good candidates for UDFs.

SQL Server User-Defined Functions (UDFs): May 2, 2003; When you can't find a built-in function that meets your needs, you can write your own. This fifth article continues Baya Pavliashvili's series on system-supplied functions by introducing you to various types of user-defined functions (UDFs). Learn about their syntax and situations in which each one is useful.

SQL Server Scripted Configuration: Part 4: Apr 18, 2003; In this article, Rob Hawthorne completes the series by showing you how to install an SP for SQL Server and gives you ways to modify the calling batch application to ensure that the whole process is completed from start to finish.

SQL Server String, Cursor, Security and Rowset Functions: Apr 18, 2003; Baya Pavliashvili continues his series on system-supplied functions by discussing the string, security, cursor, and rowset functions. Also discover some extra features, which are not mentioned in the SQL Server online documentation.

SQL Server Scripted Configuration: Part 3: Apr 11, 2003; So far in this series, you have seen how to install SQL Server silently by using a simple batch file and the .iss unattend file. Now Rob Hawthorne looks at how to make the installation and configuration of SQL Server flow into a single call-able batch file, providing a "wrapper" installation script to any other scripts you may need to execute when installing and configuring SQL Server.

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.

SQL Server Scripted Configuration: Part 2: Mar 28, 2003; By scripting the installation of SQL Server, administrators and SQL DBAs can ensure a consistent deployment of SQL Server, every time! No more cheat sheets or how-to documents and a world free of tombs of documentation. Sound too good to be true? Rob Hawthorne shows you how to make your life easier by using a small self-documenting batch file.

SQL Server Scripted Configuration: Part 1: Mar 21, 2003; The deployment and configuration of software can be a real nightmare to standardize; administrators have their own ideas of best practice, even with checklists (or cheat sheets). In this series of articles, Rob Hawthorne discusses the unattended installation of SQL Server and shows you how to write your own scripts to install SQL Server, ensuring a standard and consistent deployment every time!

SQL Server System-Related Functions: Mar 14, 2003; In this second article in his series on functions, Baya Pavliashvili examines built-in functions that have to do with getting information about SQL Server internals, configuration, global variables, and metadata for system and user databases.

Enhancing SQL Server Functionality with Functions: Feb 21, 2003; In this first article in a series on functions, Baya Pavliashvili introduces you to the various flavors of built-in functions available in SQL Server 2000, with a focus on aggregate functions.

What's New in SQL Server 2000 - Second Edition: Feb 14, 2003; Discover the enhancements and long-awaited features now available in SQL Server 2000, along with how it interacts with the .NET framework.