(Dan Burger) The cost of application maintenance can really shrivel the effectiveness of IT. Too many people with too many hours devoted to maintenance should be raising red flags. One thing you can do to diminish the application maintenance money pit is re-evaluating mature (overly kind description
Author: SSWUG Research
MySQL performance schema threads
(Ronald Bradford) A trap for those new to the MySQL Performance Schema is the expectation that thread_id in tables such as events_statements_current matches the id you find in the MySQL processlist. This is NOT TRUE.
CPU Queue Time as SQL*Net wait
(Bobby Durrett) I was testing a script that did a lot of very short SQL statements and running many of them at the same time to bog down the CPU on the database server. I kept seeing high “SQL*Net message from client” waits from my profiling SQL code.
A Look at the Razor View Engine in ASP.NET MVC
(Dino Esposito) The biggest architectural difference that exists between ASP.NET MVC and ASP.NET Web Forms is the neat separation between the two key phases of processing the request and generating the response. In general, rendering an ASP.NET Web Forms page means looping through the page’s server
Connection options in SSMS
(Kenneth Fisher) When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know have only ever looked beyond the basics so I thought I would mention a few of the others.
My obsession with subsystem parameters (aka DSNZPARMs)
(Willie Favero) It’s true, I do have (and have had for a long time) a kind of odd obsession with DB2’s subsystem parameters, or what are more commonly, and incorrectly, referred to as DSNZPARMs. This obsession has been going for a very long time. In fact, I think it all started when I heard Dave F
Create Tablespace and ORA-28374
(Jeremy Schneider) One of the projects I worked on last week was improving our processes around encryption in Oracle. I spent a lot of time becoming intimate friends with the database wallet. Late in the week while attempting to create an encrypted tablespace on an 11.2.0.3 (PSU6) system, we mysteri
CRUD Operations using Partial View and jQueryUI in ASP.NET MVC4 – Part 2
(Snesh Prajapati) This is the second part of the article “CRUD operations using partial views in ASP.NET MVC4”. If you have not visited Part 1, please do so, it would help to understand this part better. In the first part, we have seen how to display training data on the view by making a call to the
Reducing MySQL durability for testing
(Morgan Tocker) A while ago, I wrote how to make MySQL perform durably in production. Today I want to do the opposite: configure MySQL (with the InnoDB storage engine) for when you really don’t care about your data.
SSWUGtv News: 3D printers, Carbon Negative Power, and Attention-Powered Cars! Don’t miss it.
Video Programming for IT Professionals