(K. Brian Kelley) We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn’t have the fixed database roles for a critical database.
Other News
One True Lookup Table
Free MMC Webcast This Wednesday, March 9th Do you use Source Control for your database objects? If you are just starting, or looking for tips on how to optimize your source control, this webcast will provide you insight on how to accomplish this non-intuitive task for relational databases. There will be lots of other topics covered as well, centered on […]
XBRL backgrounder: XML meets the CPA
(Alan Earls) For public companies, XBRL has arrived. For other financial organizations, the journey may just be beginning.
Using jQuery with CheckBox and ASP.NET GridView
(Suprotim Agarwal) It’s very common to use client script like jQuery to perform actions on the ASP.NET GridView. I have written articles in the past that shows how to use jQuery with controls like the Checkbox inside a GridView.
PowerTech Adds Innovatum’s Monitoring Tool to Product Mix
(Alex Woodie) PowerTech has inked a deal with Innovatum to resell DataThread, a powerful database monitoring tool designed to provide real-time alerts into DB2/400 events for security and regulatory compliance purposes.
What’s my name? – Finding out user information by asking the user
(Matt Canning) Over the years there have been many occasions where someone has telephoned to say that they are having problems running SQL code.
7 MySQL Command-line Tool Tips
This tutorial will introduce you to seven MySQL command-line tool tips that help increase your productivity and skills using the command-line method. These are written with beginners in mind, but can still be applied by any MySQL user.
SQL SERVER – BACKUPIO, BACKUPBUFFER – Wait Type – Day 14 of 28
(Pinal Dave) Backup is the most important task for any database admin. Your data is at risk if you are not performing database backup. Honestly, I have seen many DBAs who know how to take backups but do not know how to restore it. (Sigh!)
Yes, you can do DB2 V8 to DB2 10, but SHOULD you skip DB2 9; the story continues?
(Willie Favero) One of the interesting (and unexpected in my opinion) features of DB2 10 for z/OS is a customer’s ability to upgrade to DB2 10 directly from DB2 Version 8 new function mode (NFM), without having to go through DB2 9.
MySQL InnoDB File Formats
(Chris Schneider) Versions of MySQL now come equipped with the powerful and stable InnoDB plugin. The InnoDB plugin comes with a lot of new features, bug fixes and performance gains. We will be covering file formats today, which is a very important part of the InnoDB plugin feature set.