By Baya Pavliashvili – SQL Server 2000 has a multitude of options that let you tweak its behavior to your advantage. Some of these options, however, might adversely affect your applications’ performance. Knowing more about configuration options can help you avoid such pitfalls.
Author: SSWUG Research
Abstracting Oracle Connectivity with PHP/OCI8
Dante Lorenso presents several functions designed to help run Oracle queries without the drudgery of repetition. Take these functions, roll them into a PHP class, and voila! … easy PHP/OCI8!
Access SQLXML Technology from .NET Apps
by Klaus Aschenbrenner – The SQLXML Managed Classes enable developers to access SQLXML technology from .NET applications. This article describes some of these classes and how to use them.
Entegra Sets a New Standard for SQL Server Auditing
by Brad M. McGehee – Data security is a hot topic. Virtually every computer-related journal has one or more articles devoted to this topic in every issue, IT shops have been scrambling to boost their data’s security and hiring security officers, and vendor’s have been patching older products and iss
Tip: Control white space in an XSLT style sheet
By Nicholas Chase – Because the style sheet and the source document in an XSLT transformation have different rules regarding white space stripping, it often seems as though the production of spaces and line breaks has no rhyme or reason in the process. This tip shows you how to control the productio
XML creator says royalty-based standards could work
By Eric B. Parizo – Hollander — who co-created XML, leads the World Wide Web Consortium (W3C)’s XML Schemas Working Group, and participates in its Web Services Architecture Working Group — is the chief technology officer at Contivo Inc., a Mountain View, Calif.-based company that looks to reduce i
Compressing XML Documents with SharpZipLib
XML documents tend to be quite verbose since their overall purpose is to describe data. As a result, documents can become quite large which presents a problem when they need to be exchanged with other entities. This sample application demonstrates how to use the open source SharpZipLib component to
Identifying performance issues using SQL Server Profiler
By Vyas Kondreddi – It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored p
SmallLibrary Sample: Incorporating Notification Services
By David Willson – Demonstrates how adding Microsoft SQL Server Notification Services as a feature can enhance an existing application. Gives an overview of an existing, simplified library management Web application, and the process of designing the notification service features for the library.
More Than a Little Help from My Friends
By Brian Moran – Online peer support is a great option and can meet your support needs much of the time, but it isn’t always the best option. Sometimes paying a small fee and taking advantage of Microsoft’s paid product-support can save the day–and your database.