- Reporting Services Architecture in SQL Server 2005
- Jun 30, 2006
- SSRS is a comprehensive and extensible reporting platform, which includes an integrated set of processing components, programmatic interfaces, and tools. Processing components are the basis for the multilayered architecture of SSRS and interact with each other to retrieve data, process layout, render, and deliver a report to a target destination.
|
- 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.
|
- In-Process Data Access in SQL Server 2005
- Jun 16, 2006
- Whether you access data from the client, middle tier, or server, when you’re using SQL Server and the .NET Framework, you use the SqlClient data provider. Your data access code is similar regardless of its location, but the .NET Framework 2.0 version of SqlClient contains code to encapsulate differences when you’re programming inside SQL Server and optimize the in-server programming environment. This chapter introduces you to the idea of in-process data access.
|
- Using XQuery to Manage XML with SQL Server 2005
- May 12, 2006
- Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.
|
- 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.
|
- Creating a Simple SQL Server 2005 Notification Application: Stock Quotes
- Mar 31, 2006
- In this chapter, you'll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross the price targets they specify.
|
- SQL Server Query Design
- Mar 24, 2006
- The basics of programming against databases requires a firm understanding of the language used to create objects such as tables and views, read data, update data and remove data and objects. This series of tutorials covers the INSERT, UPDATE, DELETE, and SELECT statements.
|
- 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.
|
- 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).
|
- SQL Server 2005 DB Snapshot: Imperfect Yet Useful?
- Jan 20, 2006
- SQL Server 2005 offers a new tool, Database Snapshot, which helps protect against user errors. It's a great feature, in some ways. But Ravindra Okade cautions against relying on it as an all-purpose rescue device.
|
- SQL Server 2005 Setup and Deployment
- Oct 28, 2005
- SQL Server 2005 setup is designed to minimize installation failures and improve the overall setup experience. This chapter introduces the concepts related to SQL Server 2005 setup and deployment. Topics covered include which edition is right for you, the hardware and software requirements, and walks you through the upgrade process.
|
- 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.
|
- 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.
|
- 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.
|
- Oracle versus SQL Server in the Enterprise
- Mar 25, 2005
- Can Oracle kick SQL Server's behind? Oracle expert David Hull throws down the gauntlet to Microsoft devotees.
|
- SQL Server Kicks Oracle's Butt
- Mar 25, 2005
- Oracle enthusiasts love to bash SQL Server, and Buck Woody thinks it's high time that the debate is taken to a professional form. If it's to be an argument, he wants to involve the discipline of logic to see which is better: SQL Server or Oracle. Care to see who wins?
|
- 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.
|
- 31 SQL Server Tips That Can Save Your Butt
- Feb 18, 2005
- Want to get the most out of SQL Server 2000? We've collected more than two dozen tips and techniques that can make any DBA's life easier.
|
- SQL Server 2005: Two Little Known Features That Matter Big!
- Jan 28, 2005
- SQL Server 2005 brings a host of new features to the table. Ravindra Okade details a couple of nuggets that are not easy to find but can be very useful to every developer and DBA. Synonyms are very handy for managing database objects. And non-clustered index included columns, although a mouthful, is a unique feature that can drastically optimize queries.
|
- Installing and Configuring SQL Server Reporting Services
- Jan 21, 2005
- This chapter details the installation and configuration of SQL Server reporting services, providing advice on testing and options for this useful function.
|