Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed


follow us on Twitter





Brocade Doubles Down on 16 Gbps Fibre Channel

Microsoft Wants iOS Apps to Run on WP7

Avaya Debuts New Virtual Services Switch
Database Journal |DBA Support |SQLCourse |SQLCourse2










MySQL management, tutorials, scripts, coding, programming and tips for database administrators

MySQL

Automate Database Backups with MySqlDump and PowerShell 05/16

One of the Database Administrator's most important duties is performing regular scheduled database backups. To this end, tools like mysqldump are indispensable. Now, with the introduction of PowerShell, database backups can be more automated than ever.

Perform Routine Server Checks Using PowerShell 05/02

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.

Create MySQL Databases and Tables from a PowerShell Script 04/20

PowerShell is a great way to run select queries and stored procedures alike.  Rob Gravelle shows you how to write your own function to execute queries against the database.

Automate MySQL Queries with PowerShell 04/06

If you're hosting your database(s) on a Windows Operating System, you may want to consider performing batch jobs using PowerShell, rather than DOS or Wsh scripts. Read on to learn how to create a PowerShell script that can run queries against your MySQL database and process the results with a press of the Enter key.

Running Commands Against Your MySQL Databases using PowerShell 03/26

Are you still using DOS batch files to automate MySQL tasks?  It’s time for you to move up to PowerShell, Microsoft Window's newest shell scripting language. It has all the functionality of the .NET language, so it can do a whole lot with a lot less code. This article demonstrates how to use PowerShell to issue commands against your MySQL database.

The Pros and Cons of MySQL Table Locking 03/19

It's crucial to know when and how to perform table locking to achieve maximum benefits and avoid having your database slow to a crawl or grind to a halt. This article covers when and how to perform table locking, while highlighting the pros and cons of using table locking under different circumstances.

MySQL's User Privileges Model for Access Control 03/09

MySQL Access Control is not just about giving your users access to the database by adding their login credentials to the User table. Beyond that there's another layer of access control, based on user privileges. Follow along as Rob Gravelle explains stage 2 of MySQL access control.

How MySQL Protects Your Password 02/27

There are many ways to safely store passwords in MySQL. This article covers a few different encryption algorithms supported in MySQL that will help you make a sound decision as to which suits your needs best.

Securing the MySQL Root Account 02/13

The world's favorite open source DBMS has made itself a target of hackers. A little time spent in this area can yield big dividends down the road. One of the easiest steps you can take in securing your data is to lock down the root and anonymous accounts.

Data Driven Subscription in SSRS 2008 R2 01/23

Learn how to acquire data or parameter values required during the execution of a report from a database query, using Data-Driven Subscription in SQL Server Reporting Services (SSRS).

Achieving Five Nines Availability Using Synchronous Cluster Replication for MySQL 11/23

SchoonerSQL can help you achieve five nines availability for your MySQL database.

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Database Buyer's Guide Conclusion: Which Database Is Best for You? 10/27

Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?

Database Buying Guide: Open Source Databases 09/23

MySQL and PostgreSQL are worthy alternatives to the major commercial databases.

Oracle Expands MySQL for Windows 09/07

MySQL isn't just for the LAMP stack anymore.

MySQL Archives



Latest Forum Threads
MySQL Forum
Topic By Replies Updated
change collation at once supercain 0 May 17th, 02:48 AM
Foreign Key will not work. Code provided. SAMHOR 0 April 28th, 10:20 AM
GPL Free Digital Library Schema cypherinfo 0 April 8th, 05:21 AM
sql error mmmrafik 1 April 4th, 10:34 AM