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....

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....

Setup isn t the only piece of the replication puzzle; yet getting it wrong can cause many headaches. In this second episode of his replication series Baya Pavliashvili teaches you how to set up replication through wizards and through scripts.n...

Replication involves much more than setup just as marriage involves much more than a honeymoon. And there aren t many sources of information for replication implementation and troubleshooting. In this first in a series on replication Baya Pavliashvili fills in some of the gaps for you by detailing replication types and giving you a general overview....

SQL Server is an XML-enabled DBMS which can read and write XML data return data from databases in XML format and read and update data stored in XML documents. In fact SQL Server has eight different ways to use XML. Learn how each of them works and how they interoperate.nn...

This second part of the Profiler Traces article by Rahul Sharma deals with how to automate the process of tracing in SQL Server 2000 either within the application or via a scheduled task. The support for server-side traces is much more powerful in SQL Server 2000 and is implemented using system stored procedures rather than extended stored procedures...

SQL Server Profiler is a great debugging tool but there is often a requirement to either automate or have the tracing capabilities in the application itself rather than using the GUI. This two-part article discusses those issues and provides an automation means for both SQL Server 7.0 and SQL Server 2000 SP3a . First up Rahul Sharma discusses SQL...

Join author Bill Pearson in exploring ways to optimize performance in MDX queries. This article focuses on the types of intervention within which you can increase efficiency in MDX execution as well as surrounding considerations for improving overall query performance....

Explore the drillthrough capabilities that debut in Microsoft SQL Server 2000 Analysis Services. Join Bill Pearson in a hands-on tutorial that examines drillthrough from both user and design perspectives and discover how to see what lies beneath the OLAP cube s summary totals....

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....

Authentication auditing is an essential part of protecting your Windows computers from intrusion. The big problem in Windows auditing is trying to understand what s going on without drowning in a flood of irrelevant or useless information. If you let it do so Windows will bury you in event notifications. Figuring out what s going on from those notifications...

Network monitors who needs them Learn how to use the Windows Management Interface WMI to monitor hardware and services....

Recovery Console is designed for the expert rescue that s sometimes needed with an XP system but this oft-overlooked Windows utility can also take you places that XP normally doesn t prompt you to go....

Worried about password authentication security on your Microsoft Windows network With Windows Server 2003 and Windows XP you can get smart cards working for you faster than ever before....

This sample chapter examines the classes and associations that hold the elements of most interest to users of WMI....