Difference between Primary Key and Candidate Key

Difference between Primary Key and Candidate Key:

Primary key is a uniquely identifies each record in the relation, it cannot accept null values. The primary key may be one attribute or a composite of attributes, e.g.

SQL Server Security

SQL Server Security

This is first post about SQL Server Security, in this post we will speak about Sever Configuration:

First you need clear plan about your installation; what services you want, and what you aren’t, if you need SSAS, SSRS, Filestream and so on

Eliminate holidays (weekends, specific day) using T-SQL

Eliminate holidays (weekends, specific day) using T-SQL

One of the tasks that may we have to deal with is how to eliminate weekends and holidays from a period using SQL server, e.g. if you want to calculate number of business days for specific company you may need to eliminate Saturday and Sunday or Friday.

Progress DB Migration

The purpose of this article is to guide you through step by step procedure on how to migrate from progress DB to access DB or to any other DBMS.

Progress DB Migration:

Database Migration is a process of moving or coping data from one database management system (DBMS) to another or moving data from an old system to another for example moving/coping data from Progress DB to SQL Server or to Access and so on.

Auditing User Change in your DB

Auditing User Change in your DB:

In this article I will speak about the well-known and useful solutions in Microsoft SQL Server 2008.

Some of these solutions needs enterprise edition to work (check Microsoft web site for more info)

Auditing you database is most important thing, always we have to audit our database server our

Stored Procedure

When you want to develop application that has connection with database and need to do basic operation or even you have special logic you want to perform.

You need to specify many points (here what I think is related to DB):

SQL Injection

This post is intended for learning purpose in a topic of PenTest and how to avoid bad user input to protect your site, system from begin misused.

SQL Injection:

SQL Injection is most popular SQL vulnerability that used to attack SQL database, this attack may affect the hosting operating system. When user gains access to your database, he tries to escalate his privilege to gain administration permission.

الإخلاص في العمل

وعن أنس بن مالك قال : قال رسول الله - صلى الله عليه وسلم - : " إذا كان آخر الزمان صارت أمتي ثلاث فرق : فرقة يعبدون الله خالصا ، وفرقة يعبدون الله رياء ، وفرقة يعبدون الله ليستأكلوا به الناس ، فإذا جمعهم الله يوم القيامة قال للذي كان يستأكل الناس : بعزتي وجلالي ما أردت بعبادتي ؟ فيقول : وعزتك وجلالك أستأكل به الناس . قال : لم ينفعك ما جمعت شيئا تلجأ إليه ، انطلقوا به إلى النار . ثم يقول للذي كان يعبد رياء : بعزتي وجلالي ، ما أردت بعبادتي ؟ قال : بعزتك وجلالك رياء الناس ، قال : لم يصعد إلي منه شيء ، انطلقوا به إلى النار . ثم يقول للذي كان يعبده خالصا : بعزتي وجلالي ما أردت بعبادتي ؟ قال : بعزتك وجلالك ، أنت أعلم بذلك مني ، أردت به ذكرك ووجهك ، قال : صدق عبدي ، انطلقوا به إلى الجنة " . 

 رواه الطبراني

خلق المسلم - محمد الغزالي

حسن الخلق

عن عائشة رضي الله عنها قالت قال رسول االله صلى الله عليه وسلم (إن المؤمن ليدرك بحسن الخلق درجات قائم الليل وصائم النهار)

كتاب خلق المسلم محمد الغزالي * أبو داود

Database and Database Management Systems

Database and Database Management System

There are many books written about Database and Database Management System, in this post I will try to provide overview of database and DBMS.

This post is a very brief on the field of Database and Database Management Systems, so I strongly