Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

Key MDX Components: Working with Calculated Cells
By William E. Pearson
Nov 8, 2002
Dive into calculated cells with Bill Pearson, and explore one of the most powerful new features of MSSQL Server 2000 Analysis Services. Get hands-on instruction in making exception highlighting work for your projects in a detailed practical lesson that gets you up to speed in no time.
Linked Servers: Configuration and Application
By Sean Geiger
Jun 1, 2001
Database expert Sean Geiger explains how to use linked servers to share data between multiple data sources.
Loading Images into SQL Server with C#
By Jesse Smith
Jul 8, 2005
As your web site grows and images multiply, storing those images on the hosting server's hard drive can turn a zippy hare of a site into a pokey tortoise. (Yes, they get there eventually, but users are impatiently waiting for a "photo finish"!) Jesse Smith provides a set of simple C# scripts that you can use to pop your images into your SQL Server database, for faster image retrieval and better load balancing on your site.
Maintaining Transactional Replication
By Baya Dewald
Apr 30, 2004
Contrary to popular belief, replication is not maintenance-free. As your application and business rules change, so do publications. Baya Pavliashvili dissects the terms and techniques necessary for maintaining transactional replication and gives you sage advice on fine-tuning your replication performance.
Maintaining Transactional Replication with SQL Server 2005
By Baya Dewald
Aug 18, 2006
Baya Pavliashvili demonstrates the steps necessary to maintain a typical SQL Server 2005 publication, and explains how new options for delivering data changes can help you tailor a replication solution to your application's needs.
Making Virtual Spies—Creating Spy Net in SQL Server 2000
By Rob Hawthorne
Jan 10, 2001
In this sample chapter from SQL Server 2000 Database Development From Scratch, learn how to create the SQL Spy Net application database and application tables, discuss important database concepts such as normalization and integrity, and draw an entity ...
Making Your SQL Server Apps Highly Available: First, Do The Assessment
By Paul Bertucci
Nov 18, 2004
Want your SQL Server apps to stand up to industrial use? In this sample book chapter, you'll learn a rather formal approach to assessing and choosing a high availability solution. As you'll learn, the key to success is doing as complete a job as you can on the assessment and using some of your best folks to do it. They will interpret the technology and the business needs with the most accuracy.
Managing Transaction Processing for SQL Database Integrity
By Ben Forta
Jul 9, 2004
In this lesson, Ben Forta explains SQL transactions, how the COMMIT and ROLLBACK statements can be used to manage data, and the use of savepoints.
Microsoft SQL Server 2000 Reporting Services
By William R. Vaughn, Peter Blackburn
Jan 7, 2005
This chapter gives you a brief tour of Reporting Services and enough detail to get you started toward a better understanding of the technology, giving you more control over Microsoft SQL Server 2000.
Microsoft SQL Server Analysis Services: Introduction to OLAP and Its Role in Business Intelligence
By Alexander Berger, Irina Gorbach, Edward Melomed
May 28, 2009
This chapter explains how SQL Server Analysis Services uses the Multidimensional Data Model to define and process data as well as interact with other data storing systems.
Migrating from Data Transformation Services to Integration Services in SQL Server
By Kirk Haselden
Sep 22, 2006
The question on most SQL Server Data Transformation Services (DTS) users' minds is how Integration Services (IS) will affect their current packages. The answer is both simple and complex. Kirk Haselden explains the available resources for performing migrations from DTS to IS and some of the problems you might encounter.
Monitoring and Troubleshooting Replication Using SQL Server 2005
By Baya Dewald
Sep 1, 2006
Replication Monitor is a fine monitoring and troubleshooting tool included with SQL Server 2005. In this hands-on article, Baya Pavliashvili discusses ways in which the replication monitoring tools have improved significantly with SQL Server 2005, as compared with previous releases.
Monitoring and Troubleshooting Transactional Replication
By Baya Dewald
Apr 23, 2004
So you set up replication and it works for a week. Then one fine day your pager goes off. Now what? Where do you look for clues? How do you troubleshoot? How can you tell if your replicated system performs well? Read on to find out the answers from Baya Pavliashvili.
Monitoring and Tuning Analysis Services with SQL Profiler, Part 1
By Baya Dewald
Aug 23, 2011
Database administration expert Baya Dewald explores the possibilities of using the SQL Profiler framework to find common performance problems in your SQL Server Analysis Services (SSAS) cubes.
Monitoring and Tuning Analysis Services with SQL Profiler, Part 2
By Baya Dewald
Aug 30, 2011
Baya Dewald concludes his series on monitoring and tuning SQL Server analysis services with a discussion of how to use SQL Profiler to analyze and adjust your MDX queries and your database's processing with the goal of streamlining everything for best performance.
Monitoring and Tuning SQL Server with Profiler
By Baya Dewald
Mar 3, 2006
Database administration expert Baya Pavliashvili introduces several tools in SQL Server you can use to monitor and tune application performance, most importantly Profiler.
My Baby Done Wrote Me a Letter (Using SQL Mail)
By Buck Woody
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 a Data Model in SQL Server 2005 and 2008
By Eric Johnson, Joshua Jones
Jul 7, 2008
This chapter gives you the tools necessary to identify the current state of your data, set your goals, and normalize (and denormalize) your data as needed.
Normalizing Name Data in SQL Server
By Baya Dewald
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.
Notification Services and the Service Broker in SQL Server 2005
By Buck Woody
Jun 23, 2006
In this chapter, you will examine a targeted approach for data distribution. Using Notification Services, you can trigger specific datagrams to users based on conditions in your database, from notifying someone that a stock price has changed to alerting that a machine has just gone offline.

<< < Prev Page 2 3 4 5 6 Next >