Databasejournal - databasejournal.com - Databasejournal.com
General Information:
Latest News:
What’s New with SQL Server 2014 1 Aug 2013 | 12:01 pm
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 29 Jul 2013 | 12:01 pm
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.
EnterpriseDB: Federal Agencies Turn to PostgreSQL to Cut Costs 25 Jul 2013 | 02:40 am
EnterpriseDB announced that U.S. government agencies are moving to Postgres to cut costs as federal budgets tighten.
SSIS 2012 - Using PowerShell to Remotely Execute File System Packages 22 Jul 2013 | 12:01 pm
Marcin Policht presents two PowerShell based methods of executing SQL Server 2012 Integration Services packages remotely.
The Big Data DBA 18 Jul 2013 | 12:01 pm
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 sta...
Using Oracle Enterprise Manager 12c Command Line Interface Part 2 – Auditing and User Management Commands 15 Jul 2013 | 12:01 pm
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 ex...
Monitoring Smart Flash Cache Activity on Oracle Exadata 11 Jul 2013 | 12:01 pm
With a bit of effort and preparation, monitoring Smart Flash Cache can be fairly easy. If the time is taken to also establish user equivalence between nodes and storage cells, the process can be autom...
Perform Row Operations Using MySQL Cursors 8 Jul 2013 | 12:01 pm
Robert Gravelle explores the use of cursors and their role in stored procedure programming.
Oracle's Multitenant Database 12c Released 2 Jul 2013 | 01:27 am
The 'c' may stand for cloud, but DBAs will find plenty of improvements for down-to-earth enterprise workloads.
SQL Server: How Important Are Index Statistics 1 Jul 2013 | 12:01 pm
Greg Larsen shows you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.
