MySQL: Five More Dials To Turn7/09 Last month we talked about some things to set and tune in a new MySQL database installation. We touched on connections, query cache, temp tables, session memory, and the slow query log.
This second part in the series hits on some other very important things to tune in a new MySQL database.
RMAN Drills7/08 This article and the next cover a couple of RMAN exercises using an older version of Oracle. The exercises or samples cover duplicating a database on the same server, and performing a tablespace point in time recovery (with a built-in error condition that requires some file editing).
Database Mirroring in SQL Server 20087/07 Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.
Working With Outlook from Access7/06 Last month we discussed how to get data from Microsoft Access into Outlook objects, such as in the creation of new appointments, tasks, contacts and emails. This month we perform the reverse operation: get data out of Outlook into Microsoft Access.
SQL Server Tracing By Jani Jarvinen
Published June 10, 2009
Let Jani show you how to how use SQL's profiler tools to createtraces of all SQL statements executed by your database server, and how to benefit from this during the development phase as well.
Custom Sprocs in Entity By Dan Rigsby
Published May 12, 2009
Working with Custom Stored Procedures in Entity Framework.
ASP.NET MVC Basics By Jani Jarvinen
Published April 29, 2009
Jani Jdrvinen shows you how to develop your first ASP.NET MVC application and helps you understand the controller classes and view pages. Jani will also discuss the relation between action methods and views with this new technology.