(Chris Webb) In one of my first posts on Power Query (and still my favourite) I found the top 100 words in the complete works of Shakespeare. As always when you’re learning a new tool, though, I look back at what I wrote then and realise there are better ways of doing things… one of which is removin
Other News
How To Refactor For Dependency Injection, Part 4: Configuration Changes
(Ondrej Balas) So far in this series on dependency injection (DI), I have only talked about the configuration of the container being done at compile time. This works well for most applications and is my preferred way of doing things, but there are times in which the decisions about application compo
Getting started Part 3 – Index maintenance
(Roger Ford) This post follows on from Part 1 and Part 2, and uses the same example “quickstart” table.
A first look at RAC 12c (part I)
(Martin Bach) I have recently upgraded my RAC 12.1.0.1.3 system to RAC 12.1.0.2 including the RDBMS installation. Currently I am updating my skills with information relevant to what I would normally have called 12c Release 2 (so that would also answer the question: when is 12c Release 2 coming out?)
#GoldenGate Bound Recovery
(Bobby Curtis) Every once in awhile when I restart an extract, I see entries in the report file that reference “Bounded Recovery”. What exactly is “Bounded Recovery”?
Gain confidence about data security in the cloud
(Walid Rjaibi) This tutorial demystifies cloud security and arms you with the know-how to adopt the cloud with confidence. Learn how cloud security is a shared responsibility between the cloud service provider and the client.
Using Extension Methods To Avoid XML Problems
(Richard Deeming) This is an alternative to JSOP’s XML extension methods, which uses the System.Linq.Expressions namespace to dynamically generate reasonably efficient methods for converting elements and attributes to different types.
What I learned while migrating a customer MySQL installation to Amazon RDS
(Michael Coburn) Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons:
SQL SERVER – Validating If Date is Last Day of the Year, Month or Day
(Pinal Dave) Here is one more question I recently received in an email-
Time to Get Certified
Recently I have been looking at certifications again. The last certification I had was for a Microsoft Certified Software Developer back in the early 2000s using SQL Server 2000 as a base. I haven’t needed a certification to land work; nobody has asked or cared. Moreover, some of the certifications back then were simply a measurement of how good your […]