by Tom Kaneshige – Oracle plans to announce later this week upgrades to its Oracle Financials software suite. Highlights include a new risk management module, business intelligence tools and two accounting portals. All of these enhancements are centered on providing real-time disclosure of financial
Author: SSWUG Research
Taking it to the movies..
By Mikael Bergkvist – The idea of XMLscript seem obscure to me. I dont see the point. If XML is used that way, it would represent scripts without adding anything useful. It does’nt seem to extend scripting with any new advantages that can be exploited in any practical way. The concept is intriguing
Web Application Security–The Next Evolution
by Yuval Ben-Itzhak – Web applications enable companies to conduct business with customers and partners, delivering highly valuable, and often confidential, information across enterprise barriers. However, the value of Internet communications cannot be realized until users have confidence that Inter
Diagnose Server Performance Problems with SQL Server’s SQL Profiler
by Drew Georgopulos – SQL Profiler is a great SQL Server tool that can help you reach your database optimization goals. This 10-Minute Solution presents a few preparatory steps to start using Profiler for monitoring performance problems. It discusses some techniques, tools, and commands that reveal
Apply an XSL Transformation from an XML Document to an XML Document by Using Visual Basic .NET
This article illustrates how to apply an Extensible Stylesheet Language (XSL) Transformation (XSLT) to an Extensible Markup Language (XML) document using the XslTransform class to create a new XML document. XSL is an XML-based language that is designed to transform one XML document into another XML
SQL Server 2000 XML Distilled
Book Review – XML, whether we like it or not, is a topic that DBAs and SQL developers must soon learn to master. While SQL Server 2000 has built-in XML-related functionality, it will be the next version of SQL Server that will really bring XML to the forefront for those involved in SQL Server.
How to Fix the Problem When ADO Truncates Milliseconds from SQL Server Datetime Columns
by Brian Lockwood – Learn how to return milliseconds from the SQL Server datetime data type using ADO and VB.
Introducing the SQL Server ‘MDX in Analysis Services’ Series
Hitch your wagon to the power of MDX in Analysis Services! Join Bill Pearson in the start of a new series ‘MDX in Analysis Services’. In this lesson, we will get up to speed with the fundamentals of MDX via Analysis Manager.
Remove Duplicates
by Shai Mungekar – Here’s a script to generate a script that will remove duplicate rows from all tables belonging to a user. Use with caution.
Index maintenance
By Baya Pavliashvili – Useful indexes can speed up your application’s performance dramatically. I’ve seen performance improvements of 10- to 1000-fold with appropriate indexes. Determining what indexes will help your application the most depends on your application type, architecture and other facto