(Uwe Hesse) You may have noticed that we introduced Invisible Indexes as an 11g New Feature. Their main benefit is that we can test whether performance differs if we would drop an index without actually dropping it. This is particular useful after an Exadata Migration because we expect that some con
Other News
Our favourite new features in DB2 10 z/OS – part 2
(Laura) In V8 IBM began a major project to transform DB2 into a 64-bit RDBMS. The groundwork was laid to provide some scalability improvements but a lot of DBM1 objects remained below the 2GB bar.
Three Ways to Identify Non-matching Records in MySQL
(Robert Gravelle) There are many times as a database developer and administrator that you’ll want to know what entities are being excluded from a straight table join. For instance, it would be instructive for management to identify sales people who haven’t received any bonuses, as these might be dee
Database Initializers and EF Code First – Database.SetInitializer
(David Hayden) In addition to the features mentioned in the tutorials above, another feature worth mentioning are Database Initializers. Database Initializers allow you to run custom logic the first time a DbContext class is first used in your application. In the example below I will use it to popul
Partial Page Refresh Using jQuery and ASP.NET
(Sheo Narayan) This article descibes how to do partial page refresh using jQuery.
What Does It Mean When You Paint in SVG
(Darla Ferrara) If you are familiar with the basics of image construction, the term painting is probably not a mystery to you. What does it mean when you paint in SVG?
When should you use the ‘var’ keyword in C#?
(Vulpes) ‘var’ is a contextual keyword that was first introduced in C# 3.0. It’s described as contextual because it’s only a keyword when used in a certain context – in other contexts it can be used as an ordinary identifier.
Creating a multi-instance queue manager for WebSphere MQ on UNIX with auto client reconnect
(Geetha Rh Murthy and Chaitra Sampige) Learn how to use WebSphere MQ V7 to create a multi-instance queue manager on UNIX and then run a sample program to check client connectivity.
Comparing SQL Server Native Backup Times to SnapManager Backups
(Scott Shaw) What are the backup and restore time differences between different implementations of SnapManager (snapshots vs. streaming) and native SQL Backups?
Can Normalization be a Bad Thing?
Can Normalization be a Bad Thing? Today I have the opportunity to share the second of David’s un-votes from the survey of “Worst Things to Do in a Database.” David does not agree that De-normalizing a database for ease of consumption by a business layer should automatically be considered a de-facto "Bad thing". He does a good job of explaining […]