Month: March 2016

New course: Understanding and Using DBCC Commands

Erin’s new course is called SQL Server: Understanding and Using DBCC Commands and is just over 2.25 hours long. It covers all the documented DBCC commands and a few of the undocumented ones, plus Erin goes into details about how to use DMVs, when available, to provide more detailed information. The modules are: Introduction Basic Commands Informational Commands […]

The post New course: Understanding and Using DBCC Commands appeared first on Paul S. Randal.

Developer Edition and Pluralsight subscription for free, courtesy of Microsoft

No, this isn’t an April fools joke. Microsoft announced today at the Build conference that they’ve made SQL Server 2014 (and 2016 when it ships) Developer Edition completely free to download for anyone who’s a member of the free Visual Studio Dev Essentials community. The idea is to make it easier for developers to work […]

The post Developer Edition and Pluralsight subscription for free, courtesy of Microsoft appeared first on Paul S. Randal.

Log Buffer #467: A Carnival of the Vanities for DBAs

This Log Buffer Edition brings some top of the list blog posts from Oracle, SQL Server and MySQL.Oracle:An Exadata quarter rack has two database servers and three storage cells. In a typical setup, such a system would have three ASM disk groups, say DATA, RECO and DBFS_DG. Usually the disk group DATA would be high redundancy and the other two disk groups would be normal redundancy.Best practice for calling web services from Oracle Process Cloud Service2 Min Tech Tips at Oracle OpenWorld: Are You Ready for Your Close-Up?Are your SQL Plus scripts going to ‘ell ?New ways of input still on the verge of the enterpriseSQL Server:Why Every SQL Server Installation Should Be a ClusterWhen AUTO_UPDATE_STATISTICS Doesn’t HappenFixing Maintenance Plan Error code 0x534SQL Server Table SmellsSome companies have been slow to acquire big data applications. They discovered that modern hardware platforms and database management systems were more than adequate for most of their business analytics needs.MySQL:Galera Cluster and Docker SwarmMariaDB 10.1.13 and Connector/J 1.3.7 now availableWhy an App-Centric View Isn’t EnoughHow to Install and Configure MySQL Cluster on CentOS 7Invalid datetime when converting to timestamp

Announcing MySQL Utilities 1.6.3 Beta!

The MySQL Utilities Team is pleased to announce a new beta release of MySQL Utilities. This release includes a number of improvements for usability, stability, and a few enhancements. A complete list of all improvements can be found in our release notes.New Enhancements!This release represents a stable release of the product. Along with several defect patches, we also include the following enhancements.Improved support for MySQL 5.7 Improved functionality of –exclude option with SQL wildcardsImproved packaging in RPM and Windows distributions Improved accuracy of calculated disk usage for mysqldiskusage…and a host of minor improvements for quality and robustness How Can I Download MySQL Utilities?You can download MySQL Utilities 1.6.3 Beta from the following link using one of the pre-built installation repositories including a source download. Click on “Development Releases” to see the 1.6.3 release downloads.http://dev.mysql.com/downloads/tools/utilities/Where is the Documentation?You can find online documentation for MySQL Utilities version 1.6 at:http://dev.mysql.com/doc/index-utils-fabric.html

Codership Galera Cluster Webinar – Migrating from Master-Slave MySQL Replication to Multi-Master Galera Cluster-April 12th

AGENDA:In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster. DATE AND TIME FOR USA:  Tue, Apr 12, 2016 10:00 AM – 11:00 AM PDT (Pacific time)PRESENTERS: Philip Stoev, Sakari Keskitalo CodershipREGISTER TO THE USA WEBINAR WITH THIS LINK! DATE AND TIME FOR EMEA:  Tue, Apr 12, 2016 11:00 AM -12:00 PM EEST (Eastern Europe time)PRESENTERS: Philip Stoev, Sakari Keskitalo CodershipREGISTER TO THE EMEA WEBINAR WITH THIS LINK!  

Codership Galera Cluster Webinar USA – Migrating from Master-Slave MySQL Replication to Multi-Master Galera Cluster-April 12th

AGENDA:In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster.DATE AND TIME:  Tue, Apr 12, 2016 10:00 AM – 11:00 AM PDT (Pacific time)PRESENTERS: Philip Stoev, Sakari Keskitalo CodershipREGISTER TO THE USA WEBINAR WITH THIS LINK!

Codership Galera Cluster Webinar EMEA – Migrating from Master-Slave MySQL Replication to Multi-Master Galera Cluster-April 12th

AGENDA:In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster.DATE AND TIME:  Tue, Apr 12, 2016 11:00 AM -12:00 PM EEST (Eastern Europe time)PRESENTERS: Philip Stoev, Sakari Keskitalo CodershipREGISTER TO THE EMEA WEBINAR WITH THIS LINK!

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569