(Bill Graziano) Some common and not so common connection strings for the .NET SqlConnection object. The article includes .NET sample code and some tricks to increase the supportability of your application.
Other News
Nondeterministic UPDATE
(Linchi Shea) Under the description for UPDATE in SQL Server 2000 and 2005 Books Online, you can find the following statement (thanks to SQL Server MVP Steve Kass for pointing me to this passage): The results of an UPDATE statement are undefined if the statement includes a FROM clause that is not
Configure aliases for SQL Server databases and servers
(Roman Rehak) Most SQL Server applications access objects in the same database, but once in a while you need to step outside the database to another database on the same server or on another SQL Server instance. In either scenario, you can utilize aliased names of database servers and objects in oth
Matt Nunn on SSWUGtv: Visual Studio 2008
New SQL Server Weekly Show Posted A wide-ranging interview with Microsoft’s Matt Nunn about Visual Studio 2008, what it does, what he likes about it, and so much more. Also, a bit about update stats, discussion list watch and a whole lot of other great SQL Server information. > Watch the show here Also, don’t miss: Watch: Handling a DBA […]
(88) A wide-ranging Interview with Matt Nunn about Visual Studio 2008, what it does, what he likes about it, and so much more.
Pro-Center Video Programming for IT Professionals
500,000 Non-SSWUG Readers Have Their Databases Exposed
Check Out the SSWUG Virtual Conference – Any other conferences you know cover the basics to get you really productive, don’t require any travel AND offer a 100% guarantee? Didn’t think so. Get more information here. Now on SSWUGtv: Watch: Handling a DBA interview. A Mock interview with questions, answers and more. Watch: SelectViews: Interview with Kim Tripp and Paul […]
UPDATE SCHEMA and CATMAINT [DB2 9 for z/OS]
(Craig Mullins) Welcome back to my blog as I continue our examination of the new features of DB2 9 for z/OS. Today we will look at the new UPDATE SCHEMA capability of the CATMAINT utility.
Display Google Calendar events on your PHP Web site with XPath
(P.J. Cabrera) Google Calendar and other online calendaring applications provide simple centralized systems where online communities can maintain event calendars and community members can get information about upcoming events. But many organizations prefer to display event calendars on their communi
Simplified DPF backup
(Chris Eaton) In previous postings I mentioned that there were simplifications to the restore and rollforward commands (including the RECOVER command) that helped to make recovery simpler in DPF. Now in DB2 9.5, IBM has added simplification to the BACKUP process for DPF customers.
Clean up your SOAP-based Web services
(Rick Grehan) SOAP is the currency of the SOA marketplace – for now, anyway. Though SOAP’s significance may diminish as Web services evolve, its importance for the time being is unquestionable. Therefore, a substantial portion of the QA work by Web service providers and consumers must entail verifyi