(Tony Darnell) There are several ways to upgrade MySQL. In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL data, and then re-import it back into the upgraded version of MySQL.
Other News
Moving Off the Web Server
The advances of browsers as they continue to implement HTML5 features have begun to redefine how we write code and where it is placed. With the expansion of RESTful services and the power of new JavaScript based libraries we are seeing more code executed in the browser than ever before. Browser code has become more testable and better organized. Code […]
SSWUGtv: Steve talks about SQL Server Permissions and walling off the castle.
Video Programming for IT Professionals
DB2 for z/OS: Can a Pooled DBAT Hold Locks?
(Robert Catterall) The answer to the question in the title of this post is, “No, it can’t — unless it can.” How’s that for a hook?
Convert JSON to a C# Class
(Dean Hume) As a web developer, I regularly write code to consume and create data in a JSON format. It’s a simple and easy way to represent data as a string and if you work with JSON every day, you’ll know how much easier it is to use than XML.
Creating A Reusable Timer In AngularJS
(Ben Nadel) In my AngularJS applications, I want my controllers to respond to events. But, often times, I don’t necessarily want the controller to react to every single event; rather, I’d like to throttle those events such that closely timed events trigger only one reaction.
Practical Use of ASP.NET Web API Attribute Routing in an MVC application
(Mahesh Sabnis) ASP.NET MVC is now widely used for web development on the .NET platform. It can be easily be integrated with the client-side JavaScript Frameworks and Libraries. The framework has incrementally progressed from one version to the other.
How to Save and Retrieve Picture in Format JSON
(Anis Derbel) The easiest way to do it is simply convert the pic to Byte[], then store it on Format JSON as local database, and we do the opposite to retrieve it.
Power Query Functions That Return Functions
(Chris Webb) You’re probably aware that, in Power Query, a query can return a function. So for example here’s a very simple query (so simple that no let statement is needed) called MultiplyTwoNumbers with the following definition:
Resolving Errors from Deployment of Database to Azure SQL DB
(Melissa Coates) This week our team at BlueGranite decided that the sample relational database called ContosoRetailDW would be best located for our demo & training purposes in Azure as a SQL Database.

