(Jan Brinkmann) Only the MySQL storage engine InnoDB supports transactions. A major benefit of transactions is that it’s possible to roll back changes until a transaction is committed.
Other News
TechTip: Protecting Against Accidental Updates with Masked Values
(Kent Milligan) With the intense focus on data privacy, many applications are being modified to protect the personal data that they are processing.
Class, Object and Class Inheritance in C#
(Krishna Vamshi Goud) So far, we have discussed about namespaces in C#. Now, let’s see the definition of class and class objects in this chapter.
WPF Data Binding – Binding to Controls
(Richard Carr) The ninetieth part of the Windows Presentation Foundation Fundamentals tutorial looks at the syntax for creating data bindings. In this article the data bindings use controls for the source and target properties, linking two or more controls together.
New Database Backup Options in SQL Server 2014
(Dinesh Asanka) Backup options are changing with every release of SQL Server. With SQL Server 2014, several important backup features have beenintroduced.
ISPACs – Got To Love Em
(Chris Yates) Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back further and, dare I say, DTS packages (I hope everyone did not just fall on the floor while reading that). Now-a-days this Database Professional does more deploying packag
Monitoring SQL
(Jody Roberts) These days, no one can afford to be without monitoring. SQL Server has some cool tools built in for monitoring, most notably extended events, sp_Serverdiagnostics (SQL 2012 and up) and DMV’s.
How To Manage Asynchronous Tasks Using the Task Object
(Peter Vogel) You want the responsiveness that asynchronous programming in the Microsoft .NET Framework 4 provides, but also need your asynchronous methods to work with other code in your application. Here’s how the Task object answers all of your problems.
Code Smell vs. Technical Debt
The last couple of editorials I have been considering the topics of Technical Debt and Code Smells. Two brave people have contributed their thoughts on these practices. Dilip writes: This Topic is of prime importance not just because of the situations mentioned by you such as : Fixing errors, Readability, trying to follow standards etc. but also because Every technology […]
Resilient Career Choices for IT Professionals
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.