MS SQL Server
Removing Transaction Log Files in SQL Server Suspends Database Mirroring
In Microsoft SQL Server 2008, you can configure the database mirroring between two database. It improves database reliability and prevent data loss situations, if one database gets damaged due to any reason. In case of failure, you can restore the copy of your database from mirror database. However, if you unintentionally remove the transaction log files on SQL database, database mirroring session is broken by principle server.
No Need For a SQL Tutorial Or to Learn SQL
Many proprietary database systems come with a report writer but are too difficult to use. They need a knowledge of SQL or they need an expensive expert to prepare the report. Sometimes there is no report writer available at all. Here is a solution.
What is a SQL Injection Attack?
This article describes what a SQL injection attack is and what it does. If also gives a simple example of how the attack works.
SQL Server Triggers
Triggers are stored procedures which are fired when data is modified in an underlying table. They can evaluate data being added to a table for validation purposes, or can make changes in that or other fields depending on the value of that data. You can use them even to execute a separate stored procedure, or to roll back a data modification or an entire transaction.
Importing Data with SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) allows you to import and export data from SQL Server databases using an easy-to-navigate graphical interface. It replaces the Data Transformation Services (DTS) found in earlier versions of SQL Server.
| Related News: |
