SSWUG.ORG Articles

Are You Supporting Mobile SQL Server Applications? (7/25/2008)

New SQL Server Show Posted Special: SQL Server 2008 Features: Chris Shaw takes a look at some of the new features of SQL Server - and how they work. This is a special airing of his session from the June Virtual Conference. [ Watch the Show Now ] Featured Article(s) Oracle 2-Day...(more)

Application- (and Data Use) Aware Data Management (7/24/2008)

Application-Aware Data Management I don't know how I missed this article from InfoStor a bit ago, but it had me thinking... It sort of answers the call about the whole "how do I split up my databases for recovery, for performance, for reporting... and should I?" It doesn't really ...(more)

Spatial Data Types - Some Help Understanding Them (7/23/2008)

Featured Article(s) SQL Server 2005 Clustering Optimization Tips (Part 1) Here are some helpful tips to work with SQL Server 2005 clustering. EMC and Microsoft I don't know if you've seen it, but Microsoft and EMC are really working closely together in a number of areas. One is the bac...(more)

AJAX - Are You Doing Applications Work With It Yet? (7/22/2008)

Video How-To Available TSQL 103 - Part 3 of 3 of the TSQL Introduction Series from the Spring Virtual Conference. This is the final segment, reviewing tips and how TSQL works, essential query elements, etc. [ Watch the Show ] AJAX - Are You Doing Applications Work With It Yet...(more)

Web 2.0 - A Good Thing, Or Bad Thing for Projects? (7/21/2008)

Featured Article(s) Provide login access to all databases in an instance Automating login creations and and assigning appropriate rights - a script. Does "Web 2.0" Help, or Hurt, Your Projects? I know there are some good tools out there, but when it comes to building out proj...(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)

Getting Off on the Right Foot: Avoiding Common Master Data Management False Starts

(Ravi Shankar) Restricting master data management to a single master data type, registry style or to analytical usage will curb its usefulness in solving difficult business problems.

The architecture of a flexible .NET file processing system Part 4

(Zach Smith) Up to this point, the files have not been accessed in any way; they havent been moved, parsed, or loaded into the database. The reason for this is that moving, parsing, or loading files into the database are all examples of tasks that are best handled by highly specialized processes. In other words, these are task specific processes.

Another Gotcha! - Select Case Using a Range of Integers

(Ged Mead) I never cease to be amazed at how many ways you can fool yourself into thinking that your code will do one thing, but in fact it does something completely different. Sometimes the subtlety of the error is so fine that you can spend ages trying to work out the source of the problem and, to make life harder, there's no Exception message to give you a pointer and sometimes even using the debugging tools doesn't lead you straight to it.

ASP.NET MVC Tip #14 Create a Template Helper Method

(Stephen Walther) In this tip, you learn how to create and use templates in the MVC framework that you can use to display database data. I show you how to create a new MVC Helper method named the RenderTemplate() method.