SQL Injections to database

  The vast majority of databases in use today have some form of web interface, allowing internal and/or external users easy access through familiar browser software. If you're security-conscious, you've undoubtedly spent a significant amount of time setting appropriate security permissions on your databases and web servers. Mot much of the DBA's considered the security of the code that powers the database-web interface.   One...

Read More

Resource Governor in SQL Server I

        In Production environment DBA's come across the scenarios, When there should be sudden spike in CPU and memory utilization and it lead to slow response to query results.In enterprise  some of running applications are business critical and they shouldn't be disturbed by other applications.Because of this there were problems for DBA about how to allocate specific hardware and resource to the critical...

Read More

Installig SQL Server 2012 Step by Step

1. Double click on the Setup.exe. 2. After Installation Wizard runs the SQL Server Installation Center. If you need to create a new installation of SQL Server, click Installation in the left-hand navigation area, and then click New SQL Server stand-alone installation else you need to add features to already installed server click on  add features. 3. The System Configuration Checker runs a discovery operation on your computer.If...

Read More