For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later.In The Art of SQL, author and SQL expert Stephane Faroult argues that this "safe appro...

Create memorable presentations on technical and complex topics in slideware such as Microsoft PowerPoint and Apple’s Keynote for Mac. Learn good pacing and rhythm as well as judicious use of special effects.Whether the goal is to help a sale or to educate, and whether the final delivery is a live presentation, a webinar, or a short video presentation, this book focuses on the particular difficulties linked to technical presentations. You will learn to create a story when there is n...

What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. Refactoring SQL Applications provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications wit...