Databases & DBA Blogs

Post

Databases & DBA

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Here you may find Databases & DBA related articles and news.

Blogs

Date of a day in a given week of the year

In this blog we have to find out a way to get the date of Monday in that week.
Arjun Panwar Nov 15, 2011
Database Normalization

Normalization is the process of efficiently organizing data in a database.
Akshay Teotia Nov 14, 2011
Many Ways to Get the Current Time.

It shows that how many ways to get the current time.
Arjun Panwar Nov 09, 2011
Count Unique Values of one Column

In this query how to count unique values of one column
Arjun Panwar Nov 08, 2011
Database size in MySQL

We have to find out our database size with the help of this query.
Arjun Panwar Nov 08, 2011
List databases, tables, columns in MySQL

Here we have to find out database column,table type and the data types.
Arjun Panwar Nov 08, 2011
ODBC is In. OLE DB is Out.

Guess what? Microsoft is bringing back the native ODBC support in the next version of SQL Server, probably SQL Server 2012. ODBC is already supported by SQL Azure.
Mahesh Chand Sep 05, 2011
Need a Database for Standalone Applications? SQL Server Compact 4.0 is the Way to Go

I have seen many questions floating around on C# Corner and other forums developers asking about Access database or SQL Server Express database to provide embedded database support for small applic...
Mahesh Chand Jul 03, 2011
Difference between operational systems and data warehouse

Difference between operational systems and data warehouse
Mukesh Kumar Jun 17, 2011
What is Data Mining?

Data mining is the process of sifting through large quantities of information to gain insight into the underlying processes.
Mukesh Kumar Jun 17, 2011
Goals of a Data Warehouse

Goals of a Data Warehouse
Mukesh Kumar Jun 15, 2011
Stored Procedure optimization Tips

Every developer / DBA can write stored procedure,But some time he face performance issues related to stored procedure.So he can optimized their stored procedure with take care of some tips.
Santosh Kumar Kotnala Jun 07, 2011
Use of Recycle Bin in Oracle 10g

Recycle bin is one of the new feature of Oracle 10g. This feature works a little bit like the familiar Windows recycle bin or Mac Trash.
Nipun Tomar May 18, 2011
(MMDBs) Multimedia Databases

We have number of data types that can be sais as multimedia data types. Text, images, Audio, Vedio and Graphic Object are the basic types of multimedia database.
Nipun Tomar May 03, 2011
Dynamic port allocation in Microsoft SQL Server 2000 and Microsoft SQL Server 2005

Dynamic port allocation in Microsoft SQL Server 2000 and Microsoft SQL Server 2005.
Awadhesh Singh Oct 21, 2010
Decoupling in Relational Databases

Decoupling concepts in Relational databases, and using many-to-many tables to accomplish it.
Tim Claason Sep 01, 2009

61 - 76 of 76

Get Certified

Java Developer