(Dinesh Asanka) Security has become extremely important in today’s fiercely completive business environment. Industry standards require you to implement firm techniques to secure your data. In SQL Server 2005, security has improved for authentication, authorization, and encryption. Encryption is so
Author: SSWUG Research
Data Bound Applications with ADO.NET and Custom Objects
(John Papa) The Windows Forms binding controls are vastly improved descendents of the data binding controls of the past. They get you going quickly and handle the redundant tasks associated with setting up forms, and you can customize and extend their behavior significantly. Data can travel in a var
Part 1: Developing an object oriented database in less than 140 lines of C#
(Zach Smith) Our goal here is to create a simple object oriented database (OODB) in C# with less than 140 lines of code. Obviously this won’t be the easiest project; however C# and the .NET Framework provide many built in functions that we can take advantage of to help us reach our goal.
SQL Server 2005 Integration Services – Part 40 – Web Service Task
(Marcin Policht) In this installment of our series dedicated to SQL Server 2005 Integration Services, we will review a Web Service Control Flow task that exposes an infinite range of easily deployable features by leveraging capabilities present in the .NET Framework. We will explain the underlying p
AWE and 3GB: An Empirical Picture
(Linchi Shea) Haven’t we heard enough about AWE and 3GB? Yes, I bet you have, and I won’t bore you with regurgitating any second-hand information or rehashing Microsoft documentation or whitepapers. Instead, I’ll give you my test results to highlight how much buffer pool memory a 32-bit SQL Server 2
An Introduction to .NET for Beginners
(Tim Patrick) Welcome to .NET! I might as well have said, “Welcome to the Solar System,” because like the solar system, .NET is huge. And it’s complex. And it’s filled with black holes and other things that don’t always make sense. Yet it (.NET, not the universe) turns out to be a fantastic system i
ASP.NET Tip: Using the LoginView Control
(Eric Smith) ASP.NET 2.0 has added a number of controls to simplify developers’ lives when it comes to routine, repeated tasks that are common to web applications. This tip discusses the LoginView control, which works hand in hand with the other security features of ASP.NET.
FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher
When you synchronize a subscriber of a merge publication in SQL Server 2000, you may notice that the data in the subscriber differs from the data in the publisher. This problem occurs when lots of data and metadata must be transferred to the subscriber.
FNDCPASS ALLORACLE
(Bas Klaassen) FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other schema in the EBS database. FNDCPASS can also be used to change the password of an application user (like sysadmin).
XML in 2006
(Elliotte Rusty Harold) 2006 was a steady and productive, if not especially exciting, year for XML. There weren’t any game-changing products or standards, just slow, incremental improvements to existing technology. Increasingly, XML faded into the infrastructure, usually meriting about as much conce