(Giuseppe Maxia) Using MySQL Sandbox I can install multiple instances of MySQL. It is not uncommon for me to run 5 or 6 instances at once, and in some occasions, I get to have even 10 of them. It is usually not a problem. But today I had an issue while testing MariaDB, for which I needed 5 instances
Other News
SQL SERVER – Introduction to SQL Server Management Studio Reports
(Pinal Dave) I get a ton of questions over mail and one of the most theme is always around Performance tuning and troubleshooting. To add to this confusion, even my chat window mostly involve around talking about some performance problem with SQL Server.
Loading CSS Asynchronously
(Dean Hume) When it comes to web page performance, the size and weight of every resource on the page is important. Large JavaScript and CSS files can slow down your page load times and frustrate your users.
Traits of a DBA – Part Two – The Personal Side of a DBA
(Greg Larsen) Over the years I’ve been asked a number of times what does it take to become a DBA, or what kinds of traits should I be looking for when hiring a DBA. Those traits can be summarized it two categories: Technical and Personal.
ASP.NET REPEATER WITH JQUERY SLIDER
(taditdash) In this Blog, we will learn how to integrate one jQuery Slider Plugin with the ASP.NET Repeater Control.
A refresher on setting up a buffer pools: Part 2 – Object Separation
(Willie Favero) If you have had the chance to read “A refresher on setting up a buffer pools: Part 1 – Background” (posted June 24, 2014), you have been introduced to a short course on history of buffer pools in DB2 for z/OS; how the portion of the buffer pools that we have to deal with and administ
MySql Enumeration Data Type
Enumerations are popular in most modern programming lanugages because they do away with “Magic” numbers. A number has a strongly defined definition verified at compile time. Problems occur when you attempt to keep those enumerations synchronized with values in your database. I was looking at the Enumeration data type found in MySql hoping to find a solution to Enumeration synchronization. […]
Undocumented SQL Server 2012 log shipping stored procedures
Undocumented SQL Server 2012 log shipping stored procedures In this article, I want to describe the following six undocumented log shipping stored procedures shipped with SQL Server 2012: sp_add_log_shipping_monitor_jobs sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_log_shipping_get_date_from_file sp_add_log_shipping_monitor_jobs The sp_add_log_shipping_monitor_jobs log shipping stored procedure is used to add ‘Log Shipping Alert Job – Backup’ and ‘Log Shipping Alert Job – Restore’ jobs. Syntax...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
XSLT to transform Excel XML worksheet to ‘named’ nodes
(Anamera) Many third party applications output sequential files (rows of “records”) in Excel format for data sharing. Unfortunately, compared to normal “CSV” files, Excel’s native XML format is not very practical to use, because the columns/record fields (= Excel cells) don’t have distinct element n
Calculate storage capacity of indexes in DB2 for z/OS
(Sriram Lakshminarasimhan) With the drastic growth of data stored in IBM DB2 tables, index sizes are bound to increase. Most indexes are still uncompressed, so there’s an urgent need to monitor indexes to avoid unforeseen outages related to index capacity.