(Marcin Policht) Throughout our series of articles dedicated to SQL Server 2005 Integration Services, we have been working mainly with packages using the Business Intelligence Development Studio interface (although more recently, we also discussed SSIS-related functionality available in SQL Server M
Author: SSWUG Research
Web Application Settings in ASP.NET 2.0
(Richard Dudley) Before .NET there were a number of ways a web application’s settings could be used. One of the most common methods was to declare all settings in one file and include that file on every page that needed the settings. This method had its drawbacks, as did the use of the application
User-Defined Functions: Powerful Alternatives to Views and Stored Procedures
(Jeffrey Juday) Views and stored procedures allow you to modularize and decouple your Transact-SQL (T-SQL) code well, but have you ever wanted to get more out of them? Like using a parameter-driven view or a stored procedure in a SELECT statement? Well, SQL Server has an often-overlooked alternative
Tool to configure and lock down SQL Server 2005 services
(Kevin Beaver) With SQL Server 2005, you can manually configure it to balance security and functionality. However, if you want to ensure you cover all of the security bases and only enable services you absolutely need (thus minimizing the attack "surface"), Microsoft has made it simple for you. I’m
Query Census Data with RDF
(Joshua Tauberer) Let’s say you’re curious to find out the population of the city you live in. Go to Google and ask it “population of philadelphia, pa.” Ha! We’re too smart for Google. It tries to answer the question but comes up with “Pennsylvania – Population: 12,281,054 ; 6th, 12/00.” That’s not
Q&A: Oracle President Charles Phillips
(Carolyn A. April) As it is with the other enterprise-software players, the SMB market is in Oracle’s sights. And like its rivals, Oracle is turning to the channel to increase the sales footprint needed to reach this segment of the market. The Redwood Shores, Calif., company recently began allowing
Comparative Management Cost Study of Oracle Database 10g Release 2 and Microsoft SQL Server 2005
This study compares the effort of managing Oracle Database 10g Release 2 to the effort of accomplishing equivalent tasks in Microsoft SQL Server 2005. Edison Group has previously published a series of manageability studies comparing the major RDBMS products in terms of their aility to manage and adm
A Visual Studio Add-In That Converts C# Code To Visual Basic
(Scott Swigart) The “Paste as…” functionality in applications like Microsoft Word has become indispensable for me. I often copy something from the Web and want to paste it into a document without all of the HTML formatting. Paste as is the tool for the job.
An Assessment of the Oracle Password Hashing Algorithm
(Joshua Wright and Carlos Cid) In this paper the authors examine the mechanism used in Oracle databases for protecting users’ passwords. We review the algorithm used for generating password hashes, and show that the current mechanism presents a number of weaknesses, making it straightforward for an
Interactivity in XAML – Hold the Script, Please
(Joe Marini) One of the most common features of any modern application, whether web-based or client-based, is the use of interactive user interface elements. These include buttons that highlight when focused or clicked, images that change when the mouse is rolled over them, text boxes that change co