(Flavio Casetta) A quick tip for formatting years when they show up as labels in flash charts inside Oracle Application Express (Apex).
Other News
Record Types 101
(Lewis Cunningham) A record type is a simple structure that combines multiple datatypes into a single package.
A Note on the Data Capacity of a DB2 for z/OS LOB Column
(Robert Catterall) Last week, a DBA asked me a few questions about LOBs (large objects) in a DB2 for z/OS context. Most of you probably know that a LOB is a DB2 data type. There are actually two LOB data types: BLOB (binary large object — a string of bits) and CLOB (character large object — a stri
Migrating from DB2 Control Center to IBM Data Studio
(Antonio Maranhao and Kevin Jiang) Since the IBM DB2 Control Center tools have been deprecated in DB2 9.7, users have been encouraged to adopt IBM Data Studio and IBM InfoSphere Optim tools for managing DB2 databases.
Holiday Extras DB2 9.7 Migration Success Story
(Laura Hood) In this video we chat to Holiday Extras about their successful migration to DB2 9.7 and how Triton helped with the project.
Backing up binary log files with mysqlbinlog
(Tamas Kozak) Backing up binary logs are essential part of creating good backup infrastructure as it gives you the possibility for point in time recovery. After restoring a database from backup you have the option to recover changes that happend after taking a backup. The problem with this approach
Options for cross database access within SQL Server
(Diana Moldovan) I need to create a stored procedure that queries data that are not in the current database. What are my options?
Accidental Programmer
SSWUG TV With Stephen Wynkoop and Sam Brace Watch this edition for interviews with DotCloud’s CEO Solomon Hykes and IT Career Coach Laura Rose. Catch the Show Accidental Programmer One of our favorite topics here at SSWUG is the issues facing the Accidental DBA. This is the person who, for one reason or another, ends up supporting and sometimes developing […]
Manage Open Source Dot Net Add-ins with NuGet
New Windows Azure Course Starts Next Tuesday! SSWUG’s new virtual class will provide you with the knowledge of Window Azure’s components and aspects to run applications without the expense needed to maintain the hardware and save money on licensing costs. Scott Klein, who is a Microsoft SQL Azure MVP and the co-founder of Blue Syntax Consulting, will showcase the different […]
How Can I Use Storage Replication For A Data Center Migration?
(Denny Cherry) Q: We are moving our data center to a new location, and as a part of the move we are upgrading from SQL Server 2005 to SQL Server 2008. SQL Server 2008 will only be running at the new site, so we have to do all our testing at the new site. The database is very large so […]