Monday, November 12, 2012

SQL Server Perfroamcne Tunning

Database Performance:
Performance is the most important thing that you have to think about, if your database performance is low then you will face with a lot of calls, emails, and client (customer) dissatisfaction.

System Performance Counter for SQL Server

Monitoring Server
Using System Monitor (Performance Monitor)

Thursday, September 27, 2012

Table Level VS Column Level Constraints

Table Level VS Column Level Constraints:
In this article we will differentiate between column level constraints and row level constraints.
Constraint is a way of enforcing rules in the database, and it maintains the integrity of the database.

Wednesday, September 12, 2012

SQL Server Database Creation

SQL Server Database Creation:
Database Planning:
1.       Storage.
Space needed to store your database the size of database determines where you can store it, and the growth of database will determine the size of storage you need to store data.

Information Security: Phishing

          Phishing is a way of attempting to acquire information (and sometimes, indirectly, money) such as usernames, passwords, and credit card details by masquerading as a trustworthy entity in an electronic communication.

Monday, September 3, 2012

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.

Tuesday, July 17, 2012

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

Thursday, June 7, 2012

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.

Sunday, April 15, 2012

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.

Wednesday, February 22, 2012

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