NEWSLETTER ARCHIVES
Home  > Newsletter Archives
Enter Date (mm/dd/yyyy):


SQL Server WorldWide User's Group (SSWUG.ORG) Trouble reading this newsletter? Read it online here: http://www.sswug.org/nlarchive.asp
Home | My Account| Upgrade/Join 
SQL Server Worldwide Users Group - SSWUG.ORG  

New sqlSentry Standard Edition is Available at $395 per instance, that’s a 60% savings!
Includes visual scheduling with drag-and-drop, comprehensive notifications, and schedule performance monitoring now available for the small- to mid-sized business!
Download a free Trial Today!

 
Wednesday, August 16, 2006 Search:  
Search SSWUG.ORG:
 

Newsletter Via RSS

HOME

Get Started
Register / Join
Login
 
Site Tools
Email Page Link to Friend
Search
RSS/XML Feeds
Register for Free Newsletter
Newsletter Archives
 
Platforms
SQL Server
Oracle
DB2
MySQL
XML
 
Podcasts
Podcast Directory
Help With Podcasts
RSS Feeds
 
Webcasts
Internet TV
Upcoming
On-Demand Viewing
Downloadable
About Webcasts
 
Most Popular Searches
Developers
.Net Articles
DTS
replication
query
sql server express
Export
 
Tools
White Paper Library
Product Directory
Script Library
FAQ System
Forums
List Servers
 
Site Options
Employers: Post Jobs
Find a Job
Popular Articles
Discount Books
 
About SSWUG.ORG
Affiliate Program
About SSWUG
Write for SSWUG
Request Product Review
Advertise on SSWUG.ORG
Contact Us
 
Other Resources
Office Users Group
MS SQL City
 

Tip: Please be sure to add newsletter@sswug.org when configuring your email filters.


Vista Won't Support MSDE

Featured Article(s)
Using replication procedures to troubleshoot SQL Server problems
In this article, Alexander Chigrik explains how you can use the SQL Server replication procedures to troubleshoot some SQL Server problems.

Performance Monitoring and SQL Server Management
If you're faced with managing a SQL Server, MSDE or even a SQL Server Express installation, and wondering what types of tools are available for getting information on performance, information on what's happening with your SQL Server, you'll want to check out Teratrax. They have tools that give you Enterprise Manager-like access to MSDE, performance monitoring and more.  You can download a free trial, and you'll be able to see what types of information you can gather on your systems to keep things running in top shape. Take a look here - and get your free trial download as well.

Webcast Thursday - Register Now
Getting Started with Reporting Services
Tomorrow's webcast on Reporting Services will get you up to speed on how to get started, what to expect when you install and more.  Register now to save your place.  Here's the official information blurb:

Find out specifically how to get started with Reporting Services - we'll walk through setting up your first reports and how things work. At the end of the presentation, you'll know how to apply these techniques to your own reports.

> Thurs Aug 17 2006 12:00pm Noon Pacific
> Register Here

Vista Won't Support MSDE
I must have missed this somewhere.  It seems that MSDE won't be supported on Vista, only SQL Server and SQL Server Express.  The implications here are pretty substantial, especially given that many people don't even realize they're using MSDE for applications.  With its embedded database use, combined with applications that have been around for quite some time, I think the impact of this lack of support could be a big surprise for an awful lot of people. 

You can read more about the coming changes here at the Microsoft site.

The good news is that "unsupported" may not necessarily mean your applications will break under Vista.  The key though is to make sure you test and plan for this cutover.  I can imagine there will be unexpected upgrades from some users anxious to get busy with Vista - that, combined with applications on those and other systems that use MSDE that you may not be aware are using it, could make for some really tense times.  Save yourself some weekends and start inventorying and the planning now. 

Featured White Paper(s)
Securing XML Web Services: XML Firewalls and XML VPNs
Discusses XML and Web services-specific security challenges and presents the limitations of an SSL or sole XML Firewall solut... (read more)

Enterprise Disk Defragmentation: A Proactive Approach to Reducing Costs and Improving Productivity
Fragmentation is a normal by product of system use under all Windows® environments. It begins immediately and erodes system p... (read more)

Protecting Your Microsoft SQL Server
MS-SQL is used to power some of your most critical information applications. Complete protection of MS-SQL requires a high-av... (read more)

The Need for Better SQL Server Backups
This paper maps out a strategy for DBAs who are currently struggling with old techniques and tools to keep up with their grow... (read more)

See you online!

Stephen Wynkoop, Founder
Microsoft SQL Server MVP
swynk@sswug.org

Listen In:
Internet Audio/Podcasts
How do you measure AND report on the value of IT? It's important that you be able to show your worth, the value of what you're doing for the company. How do you do this when the proof of success is... silence and things that just work? (8/4/2006)
Security information overload - how do we deal with the constant barrage of tips, updates, patches and regulations? (7/28/2006)
In this podcast we will learn about normalization, NULLs, Outer Joins, Grouping and more. Find out how you can apply these in your development work with SQL Server. Presented by Adam Machanic, SQL Server MVP. (7/27/2006)
 
Upcoming How-To Webcasts
(Register ASAP)
Get Started with Reporting Services and SQL Server 2000 (8/17/2006)
Tentative Technology Showcase (8/23/2006)
Understand Mail with SQL Server 2000 and SQL Server 2005 (8/30/2006)
 
On-Demand How-To Webcasts
Watch NOW
How to import and clean data using DTS (6/28/2006)
Enhancing Database Productivity in a Heterogeneous Environment (6/22/2006)
Using DTS with SQL Server 2000 (6/21/2006)


Featured/New Products For Your Review
The following products are in the Product Directory, and may help in your use of your database engine. Take a look when you get a minute.

SQLDBcontrol - Source control & code management for SQL Server
Teratrax - Teratrax Performance Monitor
XLCubed - Reporting & Analytics for SQL Server’s Analysis Services
emFAST - Enterprise Fax Server Solution


Find out about these and other products in the Product Directory.



Today's Articles
Note: 'Guest' articles below will be available for seven days to registered guests.

SQL Server Topics
 
 
Full-Member Articles
 
Using replication procedures to troubleshoot SQL Server problems [Summary]
 
SQL Server 2005 Integration Services - Performance - Part 30 [Summary]
 
The bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors in SQL Server 2000 [Summary]
 
How do I… Install SQL Server 2005 Express Edition and SQL Server Management Studio Express? [Summary]
 
New Guest/Free Articles [?]
 
Space that a table uses is not completely released after you use a DELETE statement to delete data from the table in SQL Server
 
Error message when you use the Volume Shadow Copy Service (VSS) to back up SQL Server 2000 database files or SQL Server 2000 Desktop Engine (MSDE) database files
 
Closing the Loop: Improving Corporate Performance with MIS DecisionWare and Microsoft SQL Server


Developer Topics
 
 
Full-Member Articles
 
.NET random number generators and distributions [Summary]
 
ASP.NET Tip: Control the Layout of Your Input Forms [Summary]
 
Visual Studio 2005 Web Application Projects and Web Deployment Projects [Summary]
 
Tuning .NET, part one: Performance monitors appear  [Summary]
 
New Guest/Free Articles [?]
 
Building a Better ASP.NET 1.1 BasePage Framework
 
Top 10 Annotations and Remarks about the Wonderful and Powerful New Features in ASP.NET 2.0
 
Securing Databases with Cryptography (Sample Chapter)


Oracle Topics
 
 
Full-Member Articles
 
Oracle Refreshes PeopleSoft CRM Software [Summary]
 
Installing Oracle Application Server 10g Release 3 on Linux x86 [Summary]
 
Using a PL/SQL Table in SQL [Summary]
 
New Guest/Free Articles [?]
 
Oracle 10g Release 2 Grid Control Installation On Red Hat Enterprise Linux and CentOS
 
Red Hat Enterprise Linux 3 and Centos 3 Installation
 
Best Practices for Printer Management in the Oracle E-Business Suite


XML Topics
 
 
Full-Member Articles
 
Creating an Ajax Search Widget [Summary]
 
Using XTags to Add XSLT Transformations to Your JSP Web Applications [Summary]
 
The Java XML Validation API [Summary]
 
New Guest/Free Articles [?]
 
BPEL: Web Services orchestration, hands-on with ActiveBPEL
 
AJAX: Making the HTML User Experience Almost As Pleasant as Flash
 
SQL Formatter Web Service


DB2 Topics
 
 
Full-Member Articles
 
Restartable RECOVER command [Summary]
 
Installation viewlets: IBM DB2 Content Manager V8.3 installation examples [Summary]
 
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 data [Summary]
 
New Guest/Free Articles [?]
 
DB2 UDB for z/OS: Design Guidelines for High Performance and Availability
 
Cut storage consumption in half with DB2 Viper Compression
 
How to use compression in DB2 Viper

 
SSWUG.ORG Sponsors, Special Offers
  Thank you to our sponsors!
  • BoogieTools, Inc. - Automated Email Bounce Handling Software
  • Idera - Tools for SQL Server Professionals
  • Polyserve - The best Consolidation Solution for SQL Server
  • sqlSentry - Optimizing SQL Server Performance
Special Member Offers
See the special member offers page for more information
Pay them a visit and let them know you heard about them on SSWUG.ORG!

 

Help Needed!
  Some of your fellow members need some help - and we'll be sure to include your questions here as well. We'll see that you get answers!

Forum: SQL Server: SQL Server 2005Forum: SQL Server: ReplicationForum: SQL Server: AdministrationForum: SQL Server: Version 7 (and prior)Forum: SQL Server: Development When you post questions to the boards, they're included here in the newsletter. In addition, the message board system can email you when answers to your questions have been posted. Ask away!

 
Summaries

Using replication procedures to troubleshoot SQL Server problems
 In this article, Alexander Chigrik explains how you can use the SQL Server replication procedures to troubleshoot some SQL Se... [more]
[Click Here to Read More...] [TOP]

SQL Server 2005 Integration Services - Performance - Part 30
 (Marcin Policht) Throughout our coverage of SQL Server 2005 Integration Services, we have been primarily concerned with newly... [more]
[Click Here to Read More...] [TOP]

The bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors in SQL Server 2000
 When you use the bcp utility to copy data between an instance of Microsoft SQL Server 2000 and a data file in a user-specifie... [more]
[Click Here to Read More...] [TOP]

How do I… Install SQL Server 2005 Express Edition and SQL Server Management Studio Express?
 (Scott Lowe) With the release of SQL Server 2005 Express Edition and the SQL Server Management Studio Express, Microsoft has ... [more]
[Click Here to Read More...] [TOP]

.NET random number generators and distributions
 (Stefan Troschütz) The idea for this article was already born 2004 when I was working on my bachelor thesis which included th... [more]
[Click Here to Read More...] [TOP]

ASP.NET Tip: Control the Layout of Your Input Forms
 (Eric Smith) Although many of your input forms will have a fixed number of fields, in some cases you'll need to vary the numb... [more]
[Click Here to Read More...] [TOP]

Visual Studio 2005 Web Application Projects and Web Deployment Projects
 (Rick Strahl) In May, Microsoft released version 1.0 of Web Application Projects, a much needed add-in for Visual Studio 2005... [more]
[Click Here to Read More...] [TOP]

Tuning .NET, part one: Performance monitors appear
 (Colleen Frye) As server-side .NET development becomes more prevalent, Application Performance Management tools are becoming ... [more]
[Click Here to Read More...] [TOP]

Oracle Refreshes PeopleSoft CRM Software
 (Rick Whiting) Looking to keep its acquired PeopleSoft customers within the Oracle fold, Oracle is shipping PeopleSoft Enterp... [more]
[Click Here to Read More...] [TOP]

Installing Oracle Application Server 10g Release 3 on Linux x86
 (John Smiley) The guide provides a walkthrough of installing Oracle Application Server 10g Release 3 on commodity hardware fo... [more]
[Click Here to Read More...] [TOP]

Using a PL/SQL Table in SQL
 (Lewis R Cunningham) A friend of mine called a few days ago with a question. He wanted to populate a PL/SQL table and use it ... [more]
[Click Here to Read More...] [TOP]

Creating an Ajax Search Widget
 (Jeremy McPeak) The most widely used function of the Web is searching. It's not even an option; if you want to find any infor... [more]
[Click Here to Read More...] [TOP]

Using XTags to Add XSLT Transformations to Your JSP Web Applications
 (Deepak Vohra) Today's applications often use XML technology to represent and transfer structured data. You can display the d... [more]
[Click Here to Read More...] [TOP]

The Java XML Validation API
 (Elliotte Rusty Harold) Validation is a powerful tool. It enables you to quickly check that input is roughly in the form you ... [more]
[Click Here to Read More...] [TOP]

Restartable RECOVER command
 (Chris Eaton) In DB2 v8 there was a new command delivered called the RECOVER command. This command combines the restore and r... [more]
[Click Here to Read More...] [TOP]

Installation viewlets: IBM DB2 Content Manager V8.3 installation examples
 (Michael Ahern) These downloadable files are screen captures of IBM DB2 Content Manager version 8.3 installations presented a... [more]
[Click Here to Read More...] [TOP]

DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 data
 (Roman Melnyk) This tutorial introduces you to Structured Query Language (SQL) and helps to give you a good understanding of ... [more]
[Click Here to Read More...] [TOP]


Guest Articles [Top]

The article listings denoted as GUEST are random archive articles. Those articles are always available to dues-paying members, but are also available to guest newsletter subscribers for a period of 7 days from the release of this newsletter. Each newsletter features a new set of archive articles for each of the topics.

It's our hope that when you see the quality and range of articles in the archives, you'll see what a great value your SSWUG dues-paying membership really is.

Click Here to Activate Membership Today - it only takes a minute.


[ SQL Server ] [ Oracle ] [ DB2 ] [ Open Source ] [ XML ] [ Developer ]
[ Join/Upgrade ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2006, Bits on the Wire, Inc.

Some names and products covered by SSWUG are the registered trademarks of their respective owners.


The SQL Server Worldwide User's Group
8987 E. Tanque Verde #309-269
Tucson, AZ 85749 USA