Sunday, July 13, 2014

Custom result set layout for end users

Sometimes you asked to view your query result in an away that customers need to provide for example for another system that will handle it, once I asked to provide some result in CSV file that will be displayed in a specific order. They asked to get data like this

Tuesday, April 23, 2013

SQL Server Backup and Recovery Mode Information

The bellow queries help you to get information about backup and recovery mode in your server.
--When the last time  my databases are backed up

Monday, April 22, 2013

Naming Convention Saves your Time

Naming Convention:
As a database administrator, database developer and software developer or any technical person you always works in project that may consist of many participants and even if

Thursday, March 28, 2013

SQL Server Backup and Restore

SQL Server Backup and Restore
Backup is the most important process to protect your database from unintentional/intentional users behavior – user may delete all data from a table accidentally or update it – if one of your

Sunday, February 17, 2013

SQL Server Batch Update

Always we should take care of database server performance but sometimes you need to perform a huge update on your table/tables this will affect performance for concurrent users and they will complain about it.

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.