Featured Database Articles

Feature Database Articles

What’s New with SQL Server 2014 08/01/2013

Learn about the exciting new features that come along with SQL Server 2014, where you can download CTP1, and where you can find additional resources related to SQL Server 2014.

SQL Server Data Tools in SQL Server 2012 – Part 2 07/29/2013

Arshad Ali illustrates how to use SQL Server Data Tools in Connected mode and discusses some of the common features that are available both in Disconnected and Connected modes.

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages 07/22/2013

Marcin Policht presents two PowerShell based methods of executing SQL Server 2012 Integration Services packages remotely.

more...

Using Oracle Enterprise Manager 12c Command Line Interface Part 3 – Credential Management Commands 08/12/2013

Many of the activities that DBAs do through the Oracle Enterprise Manager 12 Cloud Control GUI interface can also be accomplished via the Command Line Interface (EM CLI). Read on to learn more about the commands used for managing credentials for Cloud Control.

Oracle: Sorting Out Constraints 08/08/2013

Oracle is good about creating unique indexes when you create a unique constraint, but it doesn't work the other way around. Read on to find a possible reason why Oracle won't create a unique constraint when you create a unique index on a table.

Using Oracle Enterprise Manager 12c Command Line Interface Part 2 – Auditing and User Management Commands 07/15/2013

Many of the activities that DBAs do through the Oracle Enterprise Manager 12 Cloud Control GUI interface can also be accomplished via the Command Line Interface (EM CLI). Join Karen Reliford as she explores three categories of commands – auditing and user account management.

more...

more...

The Big Data DBA 07/18/2013

Many IT enterprises are starting pilot projects to implement big data solutions. As a DBA, are you ready to support these efforts, and integrate them into your current architecture, processes, and standards?

Performance Tuning in the Age of Big Data 06/17/2013

Big Data is here, or will soon be here for the majority of IT enterprises. Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis.  If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.

Managing the Transition to Big Data 05/16/2013

Articles and advice on Big Data hardware and software solutions abound. The most popular topic is the role to be played by new analytics solutions such as analytical appliances, NoSQL database management systems (DBMSs) and Apache Hadoop software. How can the IT enterprise plan such implementations? What are the first steps?

more...