- Key MDX Components: Working with Calculated Cells
- 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
- 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#
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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)
- 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
- 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
- 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
- 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.
|