(Keith Brown) New to Windows Server 2003, Protocol Transition allows you to establish logon sessions with valid Kerberos credentials for an arbitrary domain user without knowing that user’s password. This chapter discusses this new tool and its implications for network security.
Other News
Speed and Simplify Data Movement
(Kimberly Floss) With databases approaching the double-digit terabyte range increasingly common these days, Oracle DBAs can spend a fair amount of time shuttling vast amounts of data as part of their daily operations. If we’re not trying to keep a complete physical backup current for disaster re
Digital Compliance
(Bernard Chester) Everyone’s familiar with the importance of record keeping on an individual level. We keep records for taxes, licenses, personal finance, and so on. Take that record-keeping task and multiply it to an enterprise (or even small business) scale, and you begin to understand the sco
Fuzzy Lookup and Fuzzy Grouping in Data Transformation Services for SQL Server 2005
(Surajit Chaudhuri, Kris Ganjam, Venky Ganti, Vivek Narasayya, and Theodore Vassilakis) This paper describes the Fuzzy Lookup transformation and Fuzzy Grouping transformation in Data Transformation Services (DTS) for SQL Server 2005. Fuzzy Grouping transformations are useful for improving data quali
Build SQL CLR Objects With .NET
(Doug Thews) One of the most anticipated features in SQL Server 2005 (code-named Yukon) and Visual Studio .NET 2005 (code-named Whidbey) is the capability to develop stored procedures, user-defined functions (UDFs), and user-defined data types in .NET 2.0. SQL Server 2005 now supports developing UDF
Web Services Security Interoperability Using WSE 2.0 and Systinet Server 5.0 for Java
(Simon Guest) This article shows Interoperability based on OASIS WS-Security 1.0 between Microsoft WSE 2.0 and Systinet Server for Java 5.0. The walkthroughs in this article will take you through all you need to know to configure the two environments for securely signing and encrypting SOAP requests
An efficient query for joins of four tables
(Jeremy Kadlec) Due to nature of the existing SQL Server 2000 database in my company, I have to use around four or more tables in my query to get the required results. Consider two tables for now: contracts and dealers. I have to join these two tables in mostly all reports. Indexes have been defined
SQL Server 2005 Security – Part 4
(Marcin Policht) In this article, we will conclude our coverage of security related changes in SQL Server 2005 Beta 2 (although we will continue discussion of improvements in other functionality areas throughout the reminder of this series). The topics we will focus on here are code and module signi
Write Oracle PL/SQL code like an expert – Free Code Helpers
(James F. Koopmann) Quest Software has a Knowledge Xpert called as set of over 1,000 PL/SQL functions, procedures and packages that are ready for you to view and implement into your system. This code base provides code modules that can help you in your day to day PL/SQL tasks, provide knowledgea
Tip: Batch processing XML with XSLT 2.0
(Jack Herrington) A common problem with XSLT is that it takes only a single XML file as input. You can use a cross-platform Java tool to create an XML directory listing, then use XSLT to process every file in the directory from that listing. This tip covers installation and use of such a tool, a