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
 

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles

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.

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.

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.

Implement a Secure WordPress Search 05/08/2017

Rolling your own search is especially advantageous for WordPress sites that include a lot of custom post types. Rob Gravelle shows you how to build a query that searches by post_title and taxonomy metadata.

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.







Recent Headlines
Oracle
Oracle B-Tree Index On A BLOB 05/11
Using the optimizer_index_cost_adj Parameter in Oracle 04/24
Does NOLOGGING In Oracle Really Save Time? 04/17
more...
MS SQL
Getting Started with Azure SQL Data Warehouse - Part 5 05/22
Setting Variables in Calling T-SQL Code While Using sp_executesql 05/04
Where is my SQL Server Configuration Manager? 05/04
more...
MS Access
more...
DB2
Database as a Service: Outlook Cloudy 05/15
Database as a Service: A Practicum 04/13
Big Data DBA Support Strategies 03/16
more...