- 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.
|
- SQL Server 2005's Snapshot Isolation
- Dec 23, 2004
- SQL Server 2005 is just around the corner. Are you looking to justify the upgrade to your management? Here is a great feature to include: Snapshot Isolation. Read Ravindra Okade's discussion to see what Snapshot Isolation is all about and to learn how to implement it.
|
- 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.
|
- Using Application Blocks for Data Access
- Oct 22, 2004
- If code reuse is important to you then don't waste any time writing your own data access layer. Microsoft's Data Access Application Block provide handy wrappers that make it easy to move data in and out of the SQL Server provider using ADO.NET.
|
- Replicating Code Modules in SQL Server
- Oct 15, 2004
- Replicating table articles can help you maintain multiple databases in sync. But what about stored procedures, views, and user defined functions? Do you have to apply the same code changes on a multitude of servers you manage? Fortunately, there is a way to synchronize the schema of non-table articles; and replicating the execution of stored procedures can provide better performance than replicating individual commands when adding, modifying, or removing rows from tables. Read on to find out how!
|
- The Simplest SQL Notification Application: Stock Quotes
- Oct 8, 2004
- This chapter by Shyam Pather introduces you to the basics of SQL-NS and shows you how coding in this environment works.
|
- Working with Analysis Services Cubes in SQL Server
- Oct 1, 2004
- Data warehousing is not for the faint of heart; it takes much diligence and dedication to learn the various tools of the trade. In this article, Baya Pavliashvili details some features available with Microsoft Analysis Services, whose Analysis Manager allows you to create and modify cubes to suit your end users' needs.
|
- 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.
|
- 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.
|
- SQL Server Log Shipping
- Aug 20, 2004
- Baya Pavliashvili gets you started with log shipping (ensuring failover capability, not moving lumber) by discussing its advantages and drawbacks, and then shows you how to set up log shipping and how to fail your database over to the standby server.
|
- SQL 2005 Beta: .NET Strengths, Web Weaknesses
- Aug 13, 2004
- Businesses are testing Microsoft's SQL Server 2005 as a way of meeting diverse needs. Jacqueline Emigh interviewed Long & Foster's Lance Morimoto to get his take on how promising the beta looks for the real estate firm where he works.
|
- SQL Building Blocks and Server Settings
- Aug 6, 2004
- This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.
|
- T-SQL Enhancements in SQL Server 2005
- Jul 30, 2004
- SQL Server 2005 includes a plethora of new features and tools that can help developers more efficiently and effectively manage data. This article provides a preview of the new features and their use.
|
- 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.
|
- Building a Visual FoxPro Application for SQL Server
- Jul 2, 2004
- Learn how to build a data access layer to communicate with either DBFs or SQL Server. Even cooler, you'll do it with no code to change when you move from DBFs to SQL tables, and an upsizing wizard to migrate the data for you. Find out how to use a data access layer in FoxPro, which gives you the ability to use DBFs, SQL Server, a WebConnection XML server, or XML Web services.
|
- Sorting Retrieved Data from SQL Databases
- Jun 18, 2004
- In this lesson, taken from Sams Teach Yourself SQL in 10 Minutes, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.
|
- Case Study: Realtime Trader Seeks 64-Bit Realtime Database
- May 7, 2004
- Learn how one company is using the next version of SQL Server. Rebecca Lewis of Townsend Analytics is a pivotal behind-the-scenes figure in an environment of fast-paced online trading. The IT systems director seeks a database that can keep completely up to speed. Lewis hopes that the 64-bit edition of SQL Server 2005, formerly codenamed Yukon, will prove itself able to do this job. So far, however, SQL 2005 isn't available for beta testing in 64-bit mode.
|
- 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.
|
- Relationships Should NOT Be Natural!
- Apr 30, 2004
- Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.
|
- 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.
|