This article describes how to manually synchronize replication push subscriptions by using backup or restore. Sometimes, you cannot fully synchronize replication subscriptions by using the default method because of the following potential reasons: –You have large tables that you have to transf
Other News
Malicious Attack Protection for XML Web Services – Communication behind a firewall isn’t always safe
(Andrew Yang) There are many reasons why Web services are gaining traction, including ease-of-use, their loosely coupled nature, and effectiveness in application integration with the lowest cost and least effort required. Yet the use of Web services is not without challenges. Security continues to b
Automating Server Side Tracing in SQL Server
(Vyas Kondreddi) Experts from within and outside Microsoft have always said that running Profiler on a production environment is not a recommended practice, as it could degrade the performance of the server. Instead they suggest doing server side tracing via SQL Trace system stored procedures. But D
Manage SharePoint Lists
(Roger Jennings) Windows SharePoint Services (WSS) is Microsoft’s recent reincarnation of SharePoint Team Services (STS) as an industrial-strength, scalable portal for sharing documents, contacts, calendars, Web links, and other information. WSS lets teams and workgroups bypass IT bureaucracy and bu
Five XSLT Basics
(Michael Fitzgerald) I know what you’re up against. You’ve just inherited a new project at work that requires you to learn XSLT, but you don’t have a clue where to start. If that’s your problem, this article should give you a leg up over the wall. It will quickly cover five basics of XSLT found in t
Index covering and DB2 query performance
(Alexander Kuznetsov) When an index contains all the columns involved in a query, we usually say that an index covers a query. Whenever, this happens, the DB2 optimizer usually chooses to access only that index to satisfy a query, which is called index-only access or index covering. “Usually” does n
A Comparison of Oracle 9i with DB2 v8.1
(Alexander Chigrik) Often people in newsgroups ask for a comparison of Oracle and DB2. In this article, I compare Oracle 9i Database with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects and products limits.
Scaling DB2 UDB on Windows Server 2003
(Whei-Jen Chen, Drew Bradstock, David Ceron and Chris Fierros) This IBM Redbook is designed as an informative guide to scaling DB2 UDB V8.1 with Windows Server 2003. It is intended for database and system administrators who need both an introduction and detailed information on scaling DB2 UDB on Win
Oracle AppsWorld Conference
Oracle AppsWorld is a conference and exhibition completely dedicated to Oracle E-Business Suite strategies, business processes, and technical directions. It’s a forum that enables Oracle customers and industry leaders to meet with Oracle executives, developers, and other key customers and partners.
‘Tis the Season to Think of Yukon
(Brian Moran) In Yukon, the next major release of SQL Server, Microsoft is introducing several new technologies that will change the types of skills that traditional DBAs need. Although Yukon’s commercial release is still almost a year away, it’s time to start thinking about Yukon and preparing for