Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Author: SSWUG Research
Different Ways to Restore a SQL Server Database
(Simon Liew) Can you describe SQL Server database restore principles for full backups, differential backups and transaction log backups and how I would need to perform the restores to get to a particular point in time?
Database Snapshot failed due to disk space issue
(Rohit Garg) Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML operations on database. But if disk containing snapshot file run out of space then what will be the impact on new transactions, database & snapshot?
NUnit Collection Assertions
(Richard Carr) The basic assertions provided by the NUnit framework can be used for all unit tests. To make unit tests more readable, there are other assertion types that more clearly express the intent of the tests. This article describes the collection assertions.
12c Improvement in Database Service Management
(Martin Nash) Removing a service via srvctl has not historically resulted in the service being fully removed from the database and it would still be visible in DBA_SERVICES as show below in an 11.2.0.3 database:
Step-by-step installation of a SQL Server 2012 Clustered Instance – Part 1
(Murilo Miranda) On this article I will show how to install a SQL Server 2012 clustered instance in a cluster of two nodes. In general, the installation will be done in two parts:
Windows Azure: New Scheduler Service, Read-Access Geo Redundant Storage, and Monitoring Updates
(Scott Guthrie) This morning we released another nice set of enhancements to Windows Azure. Today’s new capabilities include:
ADO.NET: Grouping data returned from a database
(Ged Mead) It will have become very clear to you if you’ve read some of the posts in this series that there’s usually more than one way of carrying out an action or getting a required result. Grouping of returned data is no different, but I’m only going to cover one approach in this post – using th
ORA-01427
(Andrew Reid) This was tested on Oracle 11.2. I created a small table as shown below:
Fusion Concepts: FND_MESSAGES
(Vik Kumar) In the previous post of this series, we talked about translation support in Fusion Applications. We discussed on how language specific data is handled by ADFbc entities. This post covers on how errors and warnings messages are implemented in Fusion Applications using FND_Messages.