(Willie Favero) DB2 for z/OS Version 8 goes out of SERVICE (End of Service) on April 20, 2012, just three months from now.
Other News
Developing heterogeneous database applications using the IBM Data Server Provider for .NET
(Kanchana Padmanabhan) Transactional logic that works across heterogeneous databases needs to use global transactions. The IBM Data Server Provider for .NET supports the distributed transaction model from the System.Transactions namespace, which has the capability to create and manage global transac
Video: Chris Eaton on the benefits of migrating from Oracle Database to IBM DB2
IBMer Chris Eaton talks about migrating from Oracle Database to DB2.
Standardize SQL Server backups and maintain existing job schedules
(Burt King) After starting a new SQL Server DBA position I discovered that our servers, and there were hundreds, all had backups running, but they were all different. Some had backups to local storage, some across the network or to the SAN, and the list went on and on.
Understanding RAID and SQL Server
SSWUGtv: Avoiding surprises with your SQL Server configuration… who is changing what? Raj Sabhlok of ManageEngine on the show to talk about more holistic monitoring of your servers, plus Laura Rose with time management tips. [Watch the Show] Raid with DB In response to Accidental DBA editorial Adam asks,” Could you please send some article about RAID, main problems of […]
SSWUGtv: Stephen discusses the importance of changed rules and roles of security to keep your data safe
Video Programming for IT Professionals
Reader Interaction
Reader Interaction In the editorial today we have interesting responses from our readers on the topics of Cloud Integration and Accidental DBA. Cloud Integration Frank: first thanks for your ongoing insights via SSWUG. Last was about cloud integration. One solution to integrate SQL (and other on premise applications) with the cloud is data replication. What do you think about this […]
SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors
(Pinal Dave) A very common error new developers receive when they begin with SQL Server and start playing with the keys. Let us first run following code which will generate an error 8111.
Bending XML to Your Will
(Stephen Thorpe) If you’ve ever worked with the Twitter or Facebook APIs, looked at RSS feeds from a website, or made use of some type of RPC calls, you’ve undoubtedly experienced working with XML. Extensible Markup Language (XML) is a big building block of today’s web with hundreds of XML-based lan
Installing SQL Server 2008 R2 Express Edition
(Mike Chapple) Microsoft SQL Server 2008 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need