<?xml version="1.0" encoding="utf-8"?>

<rss version="2.0">
<channel>

	<title>SSWUG.ORG Author Content</title> 

	<link>http://www.sswug.org</link>
	<copyright>(c) 2008, SSWUG.ORG</copyright>
	<description>SQL Server, Oracle, DB2, XML and other database administration and development articles, help and discussions</description> 
	<image>
		<title>SSWUG.ORG</title>
		<url>http://www.sswug.org/link/sswug-100x30.gif</url>
		<link>http://www.sswug.org</link>
	</image>
	<ttl>5</ttl>
    <generator>BITS Subscriber and Content Management System</generator> 
<item>
<title><![CDATA[Tools: Dundas Reporting Services Dashboard Bundle]]></title>
<link>http://www.sswug.org/see/39165</link>
<description><![CDATA[Crisp, clear visual representation of information in your reports is key to presenting an effective tool for your end-users.  This article takes a look at the Dundas Reporting Services Tool Bundle - and what it can bring to your own Reporting Services work. ]]></description>
</item>
<item>
<title><![CDATA[Pivoting Data With Oracle 11g's Pivot Operator]]></title>
<link>http://www.sswug.org/see/37100</link>
<description><![CDATA[One of the new Oracle 11g features is the Pivot and Unpivot operators used to summarize rows into summarized pivot tables.  This article describes how to use this feature in your Select statements.]]></description>
</item>
<item>
<title><![CDATA[New Features in ADO.NET (Part II)]]></title>
<link>http://www.sswug.org/see/36755</link>
<description><![CDATA[ADO.NET has introduced many cool features to improve the scalability and performance of data centric applications. With features like provider independent factory models, support for XQuery handling with xml data type and asynchronous processing techniques, the amount of LOC, code complexity and maintenance has been greatly reduced thus helping the developers to be more productive. In this series of articles, we will explore the new features added to ADO.NET.]]></description>
</item>
<item>
<title><![CDATA[Handling Concurrency issues in ADO.NET  (Part II)]]></title>
<link>http://www.sswug.org/see/36476</link>
<description><![CDATA[This is the second and the concluding part in this series where we will discuss the types of concurrency and the best practices in choosing and working with them.]]></description>
</item>
<item>
<title><![CDATA[Handling Concurrency issues in ADO.NET (Part I)]]></title>
<link>http://www.sswug.org/see/36475</link>
<description><![CDATA[Concurrency conflicts can be handled seamlessly with ADO.NET. In this series of articles on Concurrency, we will take a look at what data concurrency is and it can be handled efficiently in ADO.NET. We will discuss, the types of Concurrency in ADO.NET, Optimistic concurrency, Pessimistic concurrency and the best practices in choosing between Optimistic and Pessimistic Concurrency in our applications.]]></description>
</item>
<item>
<title><![CDATA[Dynamic TSQL pivoting procedure]]></title>
<link>http://www.sswug.org/see/36469</link>
<description><![CDATA[The following TSQL Stored procedure simplified the usage of the PIVOT operator presented in SQL SERVER 2005. it accepts parameters for the pivoted column, the aggregate function, the group column and the group column values range
It constructs the PIVOT statement and executes it dynamically using EXEC function]]></description>
</item>
<item>
<title><![CDATA[Understanding the SDLC Phases of a Software Project [Part I]]]></title>
<link>http://www.sswug.org/see/35415</link>
<description><![CDATA[Software Development follows various structured models and methodologies similar to any other engineering discipline. Each of these models provides its own set of methodologies to design and develop a software application. The choice of any such models entirely depends on the nature of the software project in hand and the best suited model that can provide better and faster results. This is a series of articles that would discuss the various SDLC phases and takes its readers away from these standard defined models and discusses the key phases of generic software development life cycle (SDLC) that are commonly practiced by the software firms across the globe.]]></description>
</item>
<item>
<title><![CDATA[Moving to DB2 9: Considerations and Migration]]></title>
<link>http://www.sswug.org/see/34826</link>
<description><![CDATA[Since the general availability of the IBM DB2 9 product and its evolutionary pureXML support among a host of other features, clients have been aggressively looking at what it takes to get their DB2 Universal Database Version 8 for Linux, UNIX, and Windows (DB2 UDB Version 8) data servers to the DB2 9 version. In this two-part series, I want to take you through a number of important points to consider when migrating a DB2 UDB Version 8 to a DB2 9 data server.]]></description>
</item>
<item>
<title><![CDATA[New Features in ASP.NET 2.0]]></title>
<link>http://www.sswug.org/see/33880</link>
<description><![CDATA[ASP.NET 2.0 provides an extensible framework that actually is a huge leap over its earlier counterpart and provides a whole lot of new and exciting features that are targeted at increasing the robustness, scalability and security of web applications and promote reduction of code redundancy. This article presents the newly added features of ASP.NET 2.0, commonly known as ASP.NET Whidbey. We would be using the terms ASP.NET Whidbey and ASP.NET 2.0 interchangeably.]]></description>
</item>
<item>
<title><![CDATA[Should you go to a conference?]]></title>
<link>http://www.sswug.org/see/33399</link>
<description><![CDATA[There are conferences this year in Orlando, Denver, and Las Vegas and I am sure I have missed a couple. So I will review why you should go to a conference. ]]></description>
</item>
<item>
<title><![CDATA[Find Selectivity Ratio for each column in a table SP]]></title>
<link>http://www.sswug.org/see/32997</link>
<description><![CDATA[The following procedure gets a table name and a schema name and produces a result set with each column name and its selectivity ratio meaning the ratios between the column's distinct values and the total number of rows in the table]]></description>
</item>
<item>
<title><![CDATA[Review: /n Software's SSIS Tasks Tool Set]]></title>
<link>http://www.sswug.org/see/32304</link>
<description><![CDATA[/n Software has released their SSIS Tasks tool set that gives you tasks for integration into SSIS to automate email, FTP, credit card transactions and more.  We take a look at the tasks and see how well they work, how well they integrate into the SSIS environment. ]]></description>
</item>
<item>
<title><![CDATA[Implementing Linked Servers on Microsoft SQL Server 2005 for Accessing Data on Remote Oracle Servers]]></title>
<link>http://www.sswug.org/see/31012</link>
<description><![CDATA[(Rocco Mastrangelo) This article describes how to use either the Microsoft SQL Server Management Studio or Transact-SQL to create a linked server on Microsoft SQL Server 2005 for use in accessing data residing on a remote Oracle server. Methods of testing and querying the linked server are also presented. The prerequisite installation of the Oracle client software, necessary for both methods, is also described.

]]></description>
</item>
<item>
<title><![CDATA[Writing Generic Stored Procedure routines in C# and SQl 2005]]></title>
<link>http://www.sswug.org/see/30654</link>
<description><![CDATA[This article will help us to understand how we could write a generic stored Procedure routine in C# using new SQl 2005 catalog views]]></description>
</item>
<item>
<title><![CDATA[Useful Undocumented SQL Server 2005 Database Engine Stored Procedures]]></title>
<link>http://www.sswug.org/see/30660</link>
<description><![CDATA[In this article, Alexander Chigrik looks at ten undocumented SQL Server database engine stored procedures that shipped with SQL Server 2005.]]></description>
</item>
<item>
<title><![CDATA[My 3rd Party Tools]]></title>
<link>http://www.sswug.org/see/30371</link>
<description><![CDATA[(Chris Shaw) The point of this article is to highlight what tools that I use with databases and systems I work with daily.  I will also mention a tool or two that look like the have a lot of promise, but I have not had a chance to test them completely.]]></description>
</item>
<item>
<title><![CDATA[SSWUG.ORG Sessions at the SQL Server Connections Conference]]></title>
<link>http://www.sswug.org/see/30404</link>
<description><![CDATA[(Stephen Wynkoop) Here's a run-down of the sessions that will be presented by SSWUG at the upcoming SQL Server Connections show in Las Vegas.  Register today to reserve your spot!]]></description>
</item>
<item>
<title><![CDATA[Understanding the MODEL database]]></title>
<link>http://www.sswug.org/see/30280</link>
<description><![CDATA[(Stephen Wynkoop) You may have noticed that there are several databases "included" with a general SQL Server installation.  Model is one of these.  What's it used for?  This article takes a look at this database and how you can put it to use to help standardize your installations.  ]]></description>
</item>
<item>
<title><![CDATA[Primary Keys and Identity - One and The Same?]]></title>
<link>http://www.sswug.org/see/30085</link>
<description><![CDATA[(James Welch) A brief guide to the benefits and downsides of using Identity in SQL; when to use them and the role they play alongside Primary and ordinary keys.]]></description>
</item>
<item>
<title><![CDATA[Creating a Non-Sequential Order Number System based on Microsoft SQL Server]]></title>
<link>http://www.sswug.org/see/29837</link>
<description><![CDATA[(Noah Subrin) Some e-commerce systems employ a sequential order numbering scheme. In some scenarios this design is not desirable. . I worked for an e-commerce company that did not want its order volume available to competitors, and used a system that generated sequential order numbers. A competitor could place an order first thing in the morning and another order at the end of the day. By subtracting the first order number from the last order number, one could derive a close estimate of the actual orders generated. I was tasked with creating a non-sequential ordering system.]]></description>
</item>
<item>
<title><![CDATA[Mistakes Developers Should Avoid With Databases]]></title>
<link>http://www.sswug.org/see/29762</link>
<description><![CDATA[Studying all the aspects of the database is not needed and they will only learn the absolure necessary to integrate a database in an application. This is the main reasons developers are still making the same database mistakes.]]></description>
</item>
<item>
<title><![CDATA[Review: TechED 2006]]></title>
<link>http://www.sswug.org/see/29236</link>
<description><![CDATA[(Stephen Wynkoop) TechED 2006 in Boston was a barrage of announcements, messaging and demos.  In this article, I'll take a look at some of the announcements and technologies that relate to the database world and let you know what's up.]]></description>
</item>
<item>
<title><![CDATA[Creating thumbnails from binary content]]></title>
<link>http://www.sswug.org/see/28227</link>
<description><![CDATA[(Vadivel Mohanakrishnan) This article would explain the way to create thumbnail images from the binary data which is stored in SQL Server. ]]></description>
</item>
<item>
<title><![CDATA[Understanding the INTERSECT and EXCEPT Operator in SQL SERVER 2005]]></title>
<link>http://www.sswug.org/see/27392</link>
<description><![CDATA[(Deepankar Bandopadhya) In this short article we shall understand the two new operators provided in SQL SERVER 2005 - Except and Intersect.]]></description>
</item>
<item>
<title><![CDATA[Find whether a column is identity or not ...]]></title>
<link>http://www.sswug.org/see/26136</link>
<description><![CDATA[(Vadivel Mohanakrishnan) In one of the newgroup somebody was asking the way to find whether a column is identity or not. This article explains or answers that with working code snippets.]]></description>
</item>
<item>
<title><![CDATA[Returning comma separated record for each employee .... ]]></title>
<link>http://www.sswug.org/see/26294</link>
<description><![CDATA[(Vadivel Mohanakrishnan) In this article I would explain the way to return comma separated details from a table. As usual complete source code has been attached.]]></description>
</item>
<item>
<title><![CDATA[Steve Ballmer - SQL Server 2005 Launch Keynote]]></title>
<link>http://www.sswug.org/see/26188</link>
<description><![CDATA[(Stephen Wynkoop) Steve Ballmer came out to introduce SQL Server 2005, Visual Studio 2005 and BizTalk Server 2006 - really a combination of services and servers that are the core of the overall Business Intelligence solution set from Microsoft.  'The environment is bigger than the sum of its parts,' Ballmer said.  In fact, the major theme has clearly become Business Intelligence as the release of these products has neared. ]]></description>
</item>
<item>
<title><![CDATA[Clear the suspect database mode revised t-sql sp]]></title>
<link>http://www.sswug.org/see/25328</link>
<description><![CDATA[(Eli Leiba) From (BOL) Microsoft? SQL Server 2000 returns the error 1105 and sets the status column of sysdatabases to suspect if SQL Server is unable to complete recovery on a database because the disk drive no longer has any free space. The following procedure is my customization from BOL for the example given to fix this problem.]]></description>
</item>
<item>
<title><![CDATA[Change Management & Schema Evolution in DB2 for z/OS V8 - Part 3]]></title>
<link>http://www.sswug.org/see/25646</link>
<description><![CDATA[(Craig Mullins) In part 3 of our on-going DB2 change management coverage we examine the impact of additional types of database changes.]]></description>
</item>
<item>
<title><![CDATA[Change Management & Schema Evolution in DB2 for z/OS V8 - Part 2]]></title>
<link>http://www.sswug.org/see/25645</link>
<description><![CDATA[(Craig Mullins) Part 2 of our multi-part examination of DB2 database change management issues.]]></description>
</item>
    

</channel>
</rss>
