Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

SQL Server: Tuning Database Design
Jul 26, 2002
Build tables, plunk in your data, you're done, right? Wrong. A poorly structured database can be a huge drain on your resources. Learn how to fix the problems.
Statement Permissions
Nov 6, 2000
Statement permissions allow a database user, database role, or Windows user or group to perform various tasks such as creating databases, creating objects, or backing up the database. Statement permissions allow a user to run a particular command (or ...
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.
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.
SureSync Part 2: Installing and Configuring SureSync to Run As a Service
Feb 8, 2002
Do you want SureSync to run as a service? In this second of a three-part series, Rob Hawthorne discusses its installation and configuration.
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.
Swift Development: Nobody Knows the Tuples I've Seen
Jun 23, 2015
In the Swift programming language, tuples play specialized roles that lend power and flexibility to your development. Erica Sadun, bestselling author of The Gourmet iOS Developer's Cookbook: Even More Recipes for Better iOS App Development, explores tuples in depth.
Synchronization with Microsoft SQL Server Analysis Services
Feb 21, 2012
Database administration expert Baya Dewald shows how built-in synchronization works and how it compares to other approaches for distributing the querying load across multiple hosts.
The Battle of the RDBMSs: SQL Server 2000 Versus Oracle 9i (Part 1)
Jun 21, 2002
Database expert Rob Hawthorne explores the Oracle Corporation and Oracle RDBMSs, peeping into the beginnings of both the company and the very popular Oracle database. See how the RDBMS sprang from the CIA!
The Battle of the RDBMSs: SQL Server 2000 Versus Oracle 9i (Part 2)
Jun 28, 2002

Database expert Rob Hawthorne explores the beginnings of both Microsoft and the SQL Server database as part of his series comparing SQL Server with Oracle 9i.

The DTS Object Model
Mar 1, 2002
This second article in the three-part DTS series by Baya Pavliashvili and Dan Lampkin introduces you to the main objects and properties of the DTS object model.
The Evolution of SQL Server
Dec 6, 2002
Review some of the new features of SQL Server 2000, and see how it continues to set the standard for performance, ease-of-use, and out-of-the-box functionality.
The Evolution of SQL Server
Feb 15, 2001
Learn the history of SQL Server as well as what's new in Version 2000.
The Simplest SQL Notification Application: Stock Quotes
Oct 8, 2004
This chapter by Shyam Pather introduces you to the basics of SQL-NS and shows you how coding in this environment works.
Tips and Tricks Within Microsoft Analysis Services
Feb 24, 2006
Database administration expert Baya Pavliashvili shows you how to make your MSAS dimensions and cubes more powerful by using Microsoft Analysis Services (MSAS).
Transact-SQL Improvements with SQL Server 2008, Part 1
Sep 27, 2011
Baya Dewald discusses some of the most exciting of the new and changed functionality for working with variables, managing date and time values, and row constructors in Transact-SQL .
Transact-SQL Improvements with SQL Server 2008, Part 2
Oct 4, 2011
Baya Dewald concludes this two-part series on Transact-SQL by discussing functions for grouping and table-valued parameters for passing multiple data rows to a stored procedure.
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.
T-SQL Enhancements in SQL Server 2005
Jul 30, 2004
SQL Server 2005 includes a plethora of new features and tools that can help developers more efficiently and effectively manage data. This article provides a preview of the new features and their use.
Tuning MDX: Improving Performance with Caches
Nov 22, 2002
Join author Bill Pearson in exploring ways to optimize performance in MDX queries. This article focuses on the types of intervention within which you can increase efficiency in MDX execution, as well as surrounding considerations for improving overall query performance.

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