- 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.
|
- Creating and Optimizing Views in SQL Server
- Dec 13, 2000
- In this chapter from Microsoft® Access Developer's Guide to SQL Server, learn how to define, create, and modify views, and how to perform index analysis and optimize performance in SQL Server.
|
- Creating Custom Functions in SQL Server 2000
- May 11, 2001
- In previous versions of SQL Server, functions were defined by system developers and couldn't be modified. Now in SQL Server 2000, developers can create custom functions that return any type of value. Learn here how to create and use these functions.
|
- 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.
|
- Deploying Merge Replication Subscribers in SQL Server
- Sep 10, 2009
- Hilary Cotter shows how to decouple your SQL Server snapshot generation from your snapshot application process for the best possible performance - all while letting you keep your sanity.
|
- Dimensional Databases: Building A Data Warehouse
- Sep 17, 2004
- Building a data warehouse involves several complicated steps and can take time if the population routines aren't designed carefully. But the effort is worth it. Baya Pavliashvili addresses some of the challenges involved in building and maintaining dimensional databases that serve as the foundation of a data warehouse.
|
- DTS and the Flow of Data Through the Enterprise
- Dec 12, 2000
- This chapter from Microsoft® SQL Server™ 2000 Data Transformation Services examines the flow of data through an organization, and presents DTS as a powerful and flexible tool for meeting such data transformation needs.
|
- DTS Tips and Tricks
- Mar 8, 2002
- In this third article of their three-part DTS series, Baya Pavliashvili and Dan Lampkin share the DTS tips that one can learn only through a hands-on experience with DTS packages and components.
|
- Effective Database Design: Choosing The Right Process
- Mar 4, 2005
- This chapter examines the process of project design, and discusses the various models of project life-cycle, with the intention of helping you to choose the right one for your database design project.
|
- Enhanced Connectivity from SQL to SharePoint to Office
- Jul 12, 2010
- Flexible dynamic data access is an impressive improvement to SharePoint 2010 that provides both read and write capabilities back to an external data source, like SQL, so that you can adjust data between Office, SharePoint and SQL. In this article we will show you how!
|
- Enhancing DTS Package Performance
- Oct 5, 2001
- Jim Samuelson and Brian Sullivan show you how to improve the performance of your DTS Packages.
|
- 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.
|
- Enterprise Data Management in SQL Server 2005
- Apr 7, 2006
- This chapter covers what’s new in enterprise database administration. It doesn’t just look at the product from a feature list, but groups the features according to some tasks common to database administration.
|
- Examples of SQL Server Implementations
- Sep 22, 2010
- This chapter provides examples of real-life database applications running in production environments at major organizations around the world.
|
- Filtering, Sorting, and Summarizing Data in Crystal Reports
- Sep 10, 2004
- The beauty of Crystal Reports is its ability to translate data from your database into useful information, but getting it to do that can take some work. This chapter will help you get started.
|
- Generating Atom Feed from SQL Data
- Mar 31, 2008
- Ivan Pepelnjak describes how you can create an Atom feed directly on the SQL Server with Transact SQL commands.
|
- Getting and Displaying Images from SQL Server with C#
- Jul 29, 2005
- Now that Jesse Smith has taught you how to store those system-taxing images in your SQL Server database, you need to know how to get them back out again when the user accesses a page. C# comes to the rescue with easy scripts for grab-and-display.
|
- Getting Started with MSDE and VB .NET
- May 17, 2002
- How can you build small multiuser applications inexpensively while preparing to scale up if your database needs increased performance? This article shows you how to use MSDE for these tasks.
|
- Identifying Bottlenecks and Performance-Tuning SQL Server
- Jun 3, 2005
- Using built-in performance counters, you can find out whether your SQL server is under stress or performing exceptionally.
|