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.
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.
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.
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.
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.
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 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.
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.
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.
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).
» 
