SSWUG.ORG Articles

A Simple Introduction to XML (9/5/2008)

Featured Article(s) A Simple Introduction to XML This article is the first of a series of articles on XML. While the series is intended for the novice and beginner, the articles will be useful to the experienced too. They can revisit the roots of their understanding about xml and gain clarity of...(more)

SQL Server Database Snapshots, SQL Server and Access (9/4/2008)

Upcoming Webcast/Video Show SQL Server Database Snapshots: Are They Right for Me? In this webcast, sponsored by Quest Software, SQL Server expert Tom LaRock will discuss SQL Server database snapshots and how you can implement them in your environment. He will outline the advantages and limitatio...(more)

Tips for using views in SQL Server 2005 (9/3/2008)

Featured Article(s) Tips for using views in SQL Server 2005 Here are some helpful tips to work with SQL Server 2005 views. Webcast - Save Your Spot SQL Server Database Snapshots: Are They Right for Me? In this webcast, sponsored by Quest Software, SQL Server expert Tom LaRock will discuss S...(more)

MySQL 5.0.67 Installation on LinuxCentOS-5 (9/2/2008)

BI Conference - Later This Month Get Registered Here, or Learn More. Featured Article(s) MySQL 5.0.67 Installation on LinuxCentOS-5 This paper takes a look at installing MySQL 5 (5.0.67) on Linux (CentOS-5). No hassle, simple commands with expected results. Webcast - Register Now S...(more)

View all assigned access rights for a specific SQL Server user (8/29/2008)

Featured Article(s) View all assigned access rights for a specific user Is a script which generates the access rights for all databases roles, any server level roles and any securable. Office and SQL Server Before we get to a couple more comments, a question. I'd be interested (...(more)

Webcast: SQL Server 2005 Tuning Tools and Approaches (6/11/2008 @ 12:00)

We'll look into the tools and techniques you have available to you in SQL Server 2005 for investigating performance issues, understanding what your server is doing and how you can use this information to tune your system. From Performance Monitor to watching queries that are executing we'll show you some of the tools at your disposal for diagnosing server issues of performance and possible tuning targets. Sponsored by: Quest Software(www.quest.com)

Webcast: SQL Server Database Snapshots: Are They Right for Me? (9/9/2008 @ 12:00)

In this webcast, sponsored by Quest Software, SQL Server expert Tom LaRock will discuss SQL Server database snapshots and how you can implement them in your environment. He will outline the advantages and limitations of using these snapshots and investigate common use cases where they can successfully be deployed. Tom is a DBA manager with ING Investments and a member of Quests Association of SQL Server Experts. Sponsored by: Quest Software(www.quest.com) (This webcast was rescheduled form 08/26/2008)

SSIS: Creating Package Configurations

In our series of SSIS Posts, we discussed the use of Business Intelligence Development Studio in creation of SSIS Packages, various SSIS design panes, various control flow and data flow tasks. We also discussed moving the DTS packages over to a new environment and how SSIS provides us with the Configuration Files to achieve this. This post discusses the creation of Configuration Files and how they can be useful while migrating a package from one environment to another. Ex: From Development to Staging/QA. In this post we will be making use of one of the old packages, Importing data from a text file using a package which we created in one of the previous posts.

SqlCredit, Part 18: Exploring the Performance of SQL 2005s OUTPUT Clause

(Rob Garrison) This is part 18 of a series. If you have not read part 17, you can find it here. That article is a good introduction to SQL Server 2005s OUTPUT clause.

SQL Server 2008 New Features - Merge Statement

(Nidal Arabi) Microsoft SQL Server 2008 with its release included some new features that some of us (as developers) will find interesting and useful. In this article about the new features of SQL Server 2008, I will try to shed some light on the Merge Statement feature (a nifty addition) as attributed to the family of T-SQL.

SQL Server 2008 Overview

(Buck Woody) SQL Server has a long history, starting out in the days when the engine was licensed from Sybase. As time went by, everything was slowly re-written to the product it is today. You might be reading this article just as SQL Server is released, or by the time you read it SQL Server 2008 might have been out for years.