|
 |
|
|
Feed: SQL SERVERS RESOURCE CENTER
SQL Server Resources. Database Server Information, Articles and Tips including MS SQL Server, MySQL Server, Oracle. SQL Server Buying Guides, SQL Programming Guides and more!
Removing Transaction Log Files in SQL Server Suspends Database Mirroring
08-Feb-12
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
08-Feb-12
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.
Career As a Database Administrator
08-Feb-12
Database administrator jobs are some of the top career opportunities at the moment. There are several positions to choose from such as the Oracle database administrator which works specifically with industry leading Oracle software.
SQL Tutorial For Beginners
08-Feb-12
Learn the basics of SQL quickly and easily in this easy to follow SQL tutorial. Learn how to query add modify and delete records in your Oracle database tables using SQL with this short tutorial.
Scalar subqueries tips for Oracle 9i
08-Feb-12
Scalar subqueries are a powerful enhancement to Oracle9i SQL. They allow for quick formulation of extremely complex SQL statements. Oracle s introduction of scalar subquery support is another example of the company s commitment to keeping pace with the evolution of the SQL language.
Some of MySQL Key area of performance tuning
08-Feb-12
6 general issues to consider when optimizing the performance of mySQL
What is a SQL Injection Attack
08-Feb-12
This article describes what a SQL injection attack is and what it does. If also gives a simple example of how the attack works.
Import Excel Data Into MySQL Using phpMyAdmin
08-Feb-12
So you have a bunch of data in Excel that you want to create a database from. But how do you import the Excel data in MySQL With phpMyAdmin the process is painless and easy. This tutorial will explain this process step by step.
SQL Server Triggers
08-Feb-12
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.
MySQL and BLOBs
08-Feb-12
One of MySQL s strengths is its use of Binary Large Object BLOB columns. These columns store unprocessed binary data typically files that can be retrieved and manipulated like the other common datatypes. The difficulty comes in accessing the BLOB column in VB. Prior to ADO 2.5 the only way to move data in and out of a MySQL BLOB column using Visual Basic was to use the appendchunk and getchunk methods. With ADO 2.5 the stream object has been added greatly simplifying the process of working with MySQL BLOBs. In this article I will focus entirely on using the stream object.
|