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