SQL Server 2000 replication is the easiest so far to setup and work with. However there are some areas that you can get yourself into trouble with if you are not careful. New author Chris Rock brings us a few lessons learned in getting replication working with a remote office.
2005-08-22
9,746 reads
In this article, we are continuing coverage of Foreach Loop container functionality, by discussing different types of loop enumerators. So far, we have presented methods for working with files in a folder as well as records in a recordset (using Foreach File and Foreach ADO enumerators, respectively). Our next enumerator is based on the SQL Server Management Objects technology (hence it is referred to as the SMO enumerator), which is the SQL Server 2005, .NET-based management framework providing replacement for COM-based DMO (Distributed Management Objects) that served an equivalent role in earlier versions of SQL Server.
2005-08-22
2,338 reads
Reporting Services exposes web methods via XML web services to facilitate cross platform reports management and delivery. It's a simple SOAP based API makes it very easy to add full functionality of reporting services in your application. It provides a set of rendering and viewing functions as well as complete set of management routines. Reporting services web service is the one stop shop for subscription, management, publishing, scheduling and rendering reports.
2005-08-19
2,418 reads
We've spent quite some time investigating career issues for SQL Server DBAs lately. I've received quite a few emails from friends on their adventures in interviewing and now Sean McCown shares an experience he had interviewing a few prospective DBAs.
2005-08-18
14,727 reads
If you run PowerChute 6.x on any of your servers, be very careful of patching and rebooting them. You might end up with more downtime and problems than you expected.
2005-08-18
4,350 reads
A look at Parameterized reports, stored procedures to retrieve data and the Report Viewer.
2005-08-18
2,424 reads
If you are near the Jacksonville, FL area on Saturday, August 27th, check out this code camp with our own Brian Knight. Get the chance to learn some great development from Brian and a few other experts.
2005-08-17
2,958 reads
Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.
2005-08-17
11,148 reads
It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.
2005-08-16
9,669 reads
Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.
2005-08-16
1,966 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
WhatsApp 083135766741 Tunjungan Plaza 6, Pakuwon Tower Jl. Embong Malang No.21-31 Level Lower Ground...
Whatsapp:083831618807 Jl. Laksda Adisucipto Km 6 Padukuhan, Janti, Caturtunggal, Kec. Depok, Kabupaten Sleman, Daerah...
Whatsapp:08216977726 Komp, BSD City, Ruko Barcelona, Blk. E9 No.30 RK No. 28, 29, Rw....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers