Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

Reporting Services Architecture in SQL Server 2005
By Michael Lisin
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
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.
In-Process Data Access in SQL Server 2005
By Bob Beauchemin, Dan Sullivan
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
By Jesse Smith
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
By Eric L. Brown
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
By Shyam Pather
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
By Buck Woody
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
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.
Tips and Tricks Within Microsoft Analysis Services
By Baya Dewald
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?
By Ravindra Okade
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
By Robert Beatty
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#
By Jesse Smith
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#
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.
Identifying Bottlenecks and Performance-Tuning SQL Server
By Jesse Smith
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
By David Hull
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
By Buck Woody
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
By Rebecca M. Riordan
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!
By Ravindra Okade
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
By William R. Vaughn, Peter Blackburn
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.

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