(Justin Whitney) XML is nothing new. But thanks to new programming techniques like Ajax, its uses have grown tremendously over the recent years. But strangely enough, databases have had few, if any, native XML features—until now.
Author: SSWUG Research
Five useful dynamic management objects in SQL Server 2005
(Tim Chapman) New to SQL Server 2005 are dynamic management objects, which are database views or functions that return state specific information for the given database instance at a given time. These objects allow the DBA or developer to monitor the database server in an efficient, controlled way.
Using XML pipelines part two: Pipelines and Web services
(William Brogden) As organizations look around for data that should be made available by Web services, publishing or data mining, inevitably they will find data in odd formats. Writing new specialized programs for converting each oddball format into something usable can be a real time consumer. Howe
Oracle’s Security Plans
(Lewis Cunningham) Information Week has an article out today, Oracle’s Security Blanket. The article talks about Oracle’s plans for security in the future, including some thoughts about security in Fusion.
Putting Open Source Development Under the Scope
(Jay Lyman) “In a large proprietary software development environment, engineers spend four to nine hours a week in meetings. … The result of all this is to pace the engineers to the plodding pace of management, so that they can stay in control of the project,” said Josh Berkus, core team member of
Accessing iSeries Data
(Suita Gupta) When you first begin to learn about DB2 for iSeries, figuring out how to access all the data you have can be intimidating. I’ll introduce some common ways of getting to DB2 for iSeries data and show you how to start developing applications to access data stored in a DB2 for iSeries dat
Console Input in .NET
(Jim Mischel) In the .NET Console interface, most input is done through the standard input handle, using the high-level input API function ReadConsole, which is called by Console.Read and Console.ReadLine. Two lower level methods, KeyAvailable and ReadKey let you poll the console for available input
A very simple example for creating a media gallery using VS 2005, C#, and SQL Server 2005
(code-frog) This example will show you how to create a very simple media gallery using Microsoft Visual Studio 2005, ASP.NET, and C# to pull images from Microsoft SQL Server 2005. In this example, I’m basically recomposing all the useless examples I found on the internet into something real and tang
ASP.NET Tip: Exporting Data to Excel
(Eric Smith) A common request of users is to be able to download data for use in Microsoft Excel. This is actually fairly easy to accomplish without a lot of extra work. I do most of my database work with DataTable objects, as I don’t need the overhead of a DataSet. I also have a Database wrapper cl
Create Simple Database From DataSet And XML File Visual Basic 2005
(Mike McIntyre) This article provides the steps necessary to create a simple database from a DataSet and an XML file. It will explain how to use a DataSet and an XML file to implement the database and how to perform CRUD (Create, Retrieve, Update, and Delete) operations on the data stored in the XML