Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Feature Database Articles

MS SQL

Getting Started with Azure SQL Data Warehouse - Part 5 05/22/2017

In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali covers performance optimization and the different aspects that impact performance.

Setting Variables in Calling T-SQL Code While Using sp_executesql 05/04/2017

In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.

Where is my SQL Server Configuration Manager? 05/04/2017

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.

more...

Oracle

Oracle B-Tree Index On A BLOB 05/11/2017

Interestingly, you can create a B-tree index on a BLOB column; read on to see how to do it and just how useful, or not, it might be.

Using the optimizer_index_cost_adj Parameter in Oracle 04/24/2017

When all else fails it may be necessary to tell Oracle that index access is the way to go.  Read on to see what parameter is used, how to set it, and what surprises you may find after you do.

Does NOLOGGING In Oracle Really Save Time? 04/17/2017

Using NOLOGGING is a time-saver, some say, but is it really?  Read on to see why it may not be and how it can get you into trouble.

more...

MS Access

more...

DB2

Database as a Service: Outlook Cloudy 05/15/2017

For most companies, IT-related hardware and software maintenance is costly, time-consuming and requires hiring and retaining a support staff of operating system and database management system specialists. Delegating these responsibilities to an outside firm allows a new application to be developed and implemented more quickly. However, there are issues with delegating database support to an outside service. In this article, we will concentrate on how these environments scale with application growth, especially if the data and services are stored in the cloud.

Database as a Service: A Practicum 04/13/2017

Vendors now offer Database as a Service (DBaaS) as part of a bundled solution of managed IT services. Delegating database management services to an external provider may have many benefits, but delegating database administration services has many hidden dangers. In this article, we focus on how delegating data modeling to an outside service can cause problems when making application updates, changing business rules or doing performance tuning.

Big Data DBA Support Strategies 03/16/2017

The Database Administrator (DBA) is usually a technical professional who supports one or more hardware and software platforms that provide application solutions. However, technical details such as SQL tuning, hardware and software upgrades, and database designs tend to be tactical in nature. It is essential that the DBA also maintain a strategic outlook to get ahead of potential problems. Lockwood Lyon addresses two of these strategies: knowing application breaking points and preparing for future enhancements to big data applications.

more...




Latest Forum Threads
DB2 Forum
Topic By Replies Updated
tables get lock during backup in db2 v9.5 Hamsoo 0 May 8th, 01:03 AM
Query to Pull Last 7 days records from a table vgoushik 0 March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem 10Pints 0 October 5th, 02:08 AM
Things that are everbodys labor day ideas? Lipsett197 0 September 1st, 09:42 AM