(Rajiv Ramachandran) In the world of enterprise application integration (EAI), it’s essential that all participating systems operate under an overarching global transaction so that these systems all return to a consistent state in case of a failure. With the various systems supporting different prot
Other News
How the MySQL Enterprise Upgrade Advisor Helps DBAs Avoid Being Bitten by Known Bugs
(Rob Young) In an earlier article I described how MySQL Enterprise takes the guesswork out of deciding which version of the MySQL server customers should be running by providing alerts around regularly scheduled Monthly Rapid Update and Quarterly Service Pack releases of the Enterprise Server. Being
Building and customizing SQL Server script templates
(Tim Ford) All that SQL Server POWER! All that SQL Server FUNCTIONALITY! There is not enough time in the day to keep it all straight! There is no shame in making use of any short cuts or cheats that allow you to be a more productive and well-versed SQL Professional in order to cope with the sheer
Additional Thoughts on DBAs, Architects, Etc.
New SQL Server Show, SelectViews Accidental DBA Tips Continue, Security Tips, Data Masking (and what it is) and More. Noise and News in the Industry, Upcoming Events, VLDBs and Replication Renames and Other Goodies On the Show Today. > Watch the show Other Video Programs/Shows available: [Watch] Disaster Recovery and Response Planning [Watch] SelectViews – the Accidental DBA – tips, […]
(102) SelectViews: Accidental DBA Tips Continue, Security Tips, Data Masking (and what it is) and More.
Video Programming for IT Professionals
An Architect or Not an Architect, That is the Question
Do You Really Know What’s Running? I’ve written before about the need to know and understand what’s happening on your server in terms of OS jobs, SQL Agent jobs and the like. Of particular interest are the recurring jobs – and their potential impact on other jobs that run later. As the day goes on, the schedules can really pile […]
SQL Server 2005 log shipping setup using the wizard
(Hilary Cotter) Log shipping is a native SQL Server high-availability technology, which is essentially a continuous backup and restore operation. Log shipping involves copying a database backup and subsequent transaction log backups from the primary (source) server and restoring the database and tra
Oracle Connections to Non-Oracle Databases
(Lewis Cunningham) Have you ever needed to bring data from a non-Oracle databases into your Oracle database? This is very common in a warehouse and is even somewhat common in ERP solutions. For a price, Oracle offers Transparent Gateways to many popular databases. What do you do if you need to load
How To Create a Trace with SQL Server Profiler
(Mike Chapple) Traces allow you to track the specific actions performed against a SQL Server databases. They provide valuable information for troubleshooting database issues and tuning database engine performance. In this tutorial, we walk through the process of creating a SQL Server Trace with SQL
How Will IBM DB2 Web Query for System i Benefit Your Shop?
(Gene Cobb) If you have been following recent IT industry trends, you may have noticed that there has been a lot of activity in the area of Business Intelligence (BI). Mergers, major acquisitions, and announcements have dominated the headlines in the past year. IBM has been quite active in this area