[EN] MVP Deep Dives Volume Two: Operation Smile is READY!!!

BOOKLET__SQLServerMVPDeepDivesVolumeTwoYeah! WOW! Amazing! Awesome! There are only few words for descibing in short form a long very interesting project which is already finished. If You remember my post about SQL Server MVP Deep Dive Volume One Codename: War Child You probably remember about short annoucement of the second volume. And from last few days it’s official information:

SQL Server MVP Deep Dives Volume Two Codename: Operation Smile

in now available on Manning Publishing site for pre-order. YAY!!!!

In this volume You can find best edvices and snapshots on many points for daily jobs with You SQL Server environment. Excellent desription by Manning: Individually, each SQL Server MVP possesses an impressive wealth of knowledge and skill. Collectively, the 63 MVPs who contributed to SQL Server MVP Deep Dives, Volume II represent over 1000 years of daily experience in SQL Server administration, development, training, and design. This incredible book captures this expertise and passion in a collection of sixty concise chapters, each handpicked by lead editor Kalen Delaney and section editors Louis Davidson, Greg Low, Brad McGehee, Paul Nielsen, Paul Randal, and Kimberly Tripp, and written by an active SQL Server MVP. Just look for the names of chapters:

ARCHITECTURE EDITED BY LOUIS DAVIDSON
  1. Where are my keys? by AMI LEVIN
  2. "Yes, we are all individuals:" A look at uniqueness in the world of SQL by ROB FARLEY
  3. Architectural growth pains by CHRIS SHAW
  4. Characteristics of a great relational database by LOUIS DAVIDSON
  5. Storage design considerations by DENNY CHERRY
  6. Generalization: the key to a well-designed schema by PAUL NIELSEN

DATABASE ADMINISTRATION EDITED BY PAUL RANDAL AND KIMBERLY TRIPP
  7. Increasing availability through testing by ALLAN HIRT
  8. Page restores by GAIL SHAW
  9. Capacity planning by GREG LARSEN
10. Discovering your servers with PowerShell and SMO by JOE WEBB
11. Will the real Mr. Smith please stand up? by JOHN MAGNABOSCO
12. Build your own SQL Server 2008 performance dashboard by PAWEL POTASINSKI
13. SQL Server cost recovery by PETER WARD
14. Best practice compliance with Policy-Based Management by ROD COLLEDGE
15. Using SQL Server Management Studio to the fullest by RODNEY LANDRUM
16. Multiserver management and Utility Explorer—best tools for the DBA by SATYA  JAYANTY
17. Top 10 SQL Server admin student misconceptions by TIBOR KARASZI
18. High availability of SQL Server in the context of Service Level Agreements by TOBIASZ JANUSZ KOPROWSKI

DATABASE DEVELOPMENT EDITED BY PAUL NIELSEN
19. T-SQL: bad habits to kick by AARON BERTRAND
20. Death by UDF by KEVIN BOLES
21. Using regular expressions in SSMS by JOHN PAUL COOK
22. SQL Server Denali: what’s coming next in T-SQL by SERGIO GOVONI
23. Creating your own data type by HUGO KORNELIS
24. Extracting data with regular expressions by MATIJA LAH
25. Relational division by PETER LARSSON
26. SQL FILESTREAM: to BLOB or not to BLOB by BEN MILLER
27. Writing unit tests for Transact-SQL by LUCIANO MOREIRA
28. Getting asynchronous with Service Broker by MLADEN PRAJDIC
29. Effective use of HierarchyId by  DENIS REZNIK
30. Let Service Broker help you scale your application by ALLEN WHITE

PERFORMANCE TUNING AND OPTIMIZATION EDITED BY BRAD M. MCGEHEE
31. Hardware 201: selecting and sizing database server hardware by GLENN BERRY
32. Parameter sniffing: your best friend… except when it isn’t by GRANT FRITCHEY
33. Investigating the plan cache by JASON STRATE
34. What are you waiting for? An introduction to wait states and queues by ROBERT PEARL
35. You see sets, and I see loops by LINCHI SHEA
36. Performance-tuning the transaction log for OLTP workloads by BRAD M. MCGEHEE
37. Strategies for unraveling tangled code by JENNIFER MCCOWN
38. Using PAL to analyze SQL Server performance by TIM CHAPMAN
39. Tuning JDBC for SQL Server by JUNGSUN KIM

PART 5 BUSINESS INTELLIGENCE EDITED BY GREG LOW
40. Creating a formal Reporting Services report part library by JESSICA M. MOSS
41. Improving report layout and visualization by GREG LOW
42. Developing sharable managed code expressions in SSRS by WILLIAM (BILL) VAUGHN
43. Designing reports with custom MDX queries by PAUL TURLEY
44. Building a scale-out Reporting Services farm by EDWIN SARMIENTO
45. Creating SSRS reports from SSAS by ROBERT CAIN
46. Optimizing SSIS for dimensional data loads by MICHAEL COLES
47. SSIS configurations management by ANDY LEONARD
48. Exploring different types of enumerators in the SSIS Foreach Loop container by ABOLFAZL RADGOUDARZI AND SHAHRIAR NIKKHAH
49. Late-arriving dimensions in SSIS by JOHN WELCH
50. Why automate tasks with SSIS? by TED KRUEGER
51. Extending SSIS using the Script component by TIM MITCHELL
52. ETL design checklist by RAFAEL SALAS
53. Autogenerating SSAS cubes by JOHAN AHLEN
54. Scripting SSAS databases—AMO and PowerShell, Better Together by DARREN GOSBELL
55. Managing context in MDX by BOYAN PENEV
56. Using time intelligence functions in PowerPivot by THIAGO ZAVASCHI
57. Easy BI with Silverlight PivotViewer by GOGULA ARYALINGAM
58. Excel as a BI frontend tool by PEDRO PERFEITO
59. Real-time BI with StreamInsight by ALLAN MITCHELL
60. BI solution development design considerations by SIDDHARTH MEHTA

Three most important information for this book:

First – all MVP’s wrote their chapters for free, especially with fun and pleasure for sharing knowledge to community,

Second – all money from sales this book going to Operation Smile Foundation – an international children’s medical charity dedicated to healing cleft lip, cleft palate, and other facial deformities through safe and effective surgical care. Every donation can help change a life! Learn more at www.operationsmile.org ,

Three – I’m (YES!! I AM!!) one of two authors from Poland, with my friend from Polish SQL Server User Group: Microsoft MVP, Certified Trainer, Leader and Past President of our group Mr. Pawel Potasinski {BLOG | TWITTER}

Please, buy this book. Don’t crack, don’t steal, don’t rapid! Share links and opinions, but not book! Just buy: it’s only 60 dollars (with digital format) in best way on Manning Publishing site HERE. When You do this – it’s the same like: Thank You for us and with us You can help the childrens!

THANK YOU !!!

[EN] SQL SERVER MVP Deep Dives Volume One on sale!

Hey Folks!

BOOKLET__MVP_DeepDivesIIf You are SQL Server Administrator, Programmer, Developer, Architect, Technician… If You are Newbie, Expert, Consultant… I’m sure that You read a lot of stuff about SQL Server on blogs, web sites, technical, documentations, twitter, forums, books. One of the most interesting and helpful (not only for SQL Peoples) book is SQL Server MVP Deep Dives Volume One, published by Manning (more info here) last year. Why not only for SQL peoples? It’s simple:

  • First – in 59 chapters 59 MVP from whole world share theirs knowledge about SQL Server for administrators, designers, developers, newbie, technicians and experts. It is helpful for You, SQL Folks.
  • Second – all authors decided to wrote their own chapter for free and send all money from selling process to charity: War Child International (WEB | WIKIPEDIA). More about this big success You can read on a post of one of well known MVP Aaron Bertrand {TWITTER | BLOG} here.  

What interesting subjects You can find in this book? Many, too many or not too much – on depend as always. See subjects and authors below:

PART I    DATABASE DESIGN AND ARCHITECTURE
Paul Nielsen, Editor
1. Louis and Paul’s 10 relational database design rules by Paul Nielsen and Louis Davidson
2. SQL Server tools for maintaining data integrity by Louis Davidson
3. Finding functional dependencies by Hugo Kornelis

PART II    DATABASE DEVELOPMENT
Adam Machanic, Editor

4. Set-based iteration: the third alternative by Hugo Kornelis
5. Gaps and islands by Itzik Ben-Gan
6. Error handling in SQL Server and applications by Bill Graziano
7. Pulling apart the FROM clause by Rob Farley
8. What makes a bulk insert a minimally logged operation? by Denis Gobo
9. Avoiding three common query mistakes by Kathi Kellenberger
10. Introduction to XQuery on SQL Server by Michael Coles
11. SQL Server XML frequently asked questions by Michael Coles
12. Using XML to transport relational data by Matija Lah
13. Full text searching by Robert C. Cain
14. Simil: an algorithm to look for similar strings by Tom van Stiphout
15. LINQ to SQL and the ADO.NET Entity Framework by Bob Beauchemin
16. Table-valued parameters by Don Kiely
17. Build your own index by Erland Sommarskog
18. Getting and staying connected—or not by William Vaughn
19. Extending your productivity in SSMS and Query Analyzer by Pawel Potasinski   
20. Why every SQL developer needs to have a tools database by Denis Gobo
21. Deprecation feature by Cristian Lefter
22. Placing SQL Server in your pocket by Christopher Fairbairn
23. Mobile data strategies by John Baird

PART III    DATABASE ADMINISTRATION
Kimberly L. Tripp and Paul S. Randal, Editors

24. What does it mean to be a DBA? by Brad McGehee
25. Working with maintenance plans by Tibor Karaszi
26. PowerShell in SQL Server by Richard Siddaway
27. Automating SQL Server management using Server Management Objects by Allen White
28. Practical auditing in SQL Server 2008 by Jasper Smith
29. My favorite DMVs and why by Aaron Bertrand
30. Reusing space in a table by Joe Webb
31. Some practical issues in table partitioning by Ron Talmage
32. Partitioning for manageability (and maybe performance) by Dan Guzman
33. Faster, smaller, and more energy-efficient backups without indexes by Greg Linwood
34. Using database mirroring to become a superhero! by Glenn Berry
35. The poor man’s SQL Server log shipping by Edwin Sarmiento
36. Some understated changes found in SQL Server 2005 replication by Paul Ibison
37. High performance Transactional Replication by Hilary Cotter
38. Successfully implementing Kerberos delegation by Scott Stauffer
39. Running SQL Server on Hyper-V by John Paul Cook   

PART IV    PERFORMANCE TUNING AND OPTIMIZATION
Kalen Delaney, Editor

40. When is an unused index not an unused index? by Rob Farley
41. Speeding up queries with index covering by Alex Kuznetsov
42. Tracing the deadlock by Gail Shaw
43. How to optimize tempdb performance by Brad McGehee
44. Does the order of columns in an index matter? by Joe Webb
45. Correlating SQL Profiler with Windows Performance Monitor by Kevin Kline
46. Using correlation to improve query performance by Gert-Jan Strik
47. Dr. DMV: how to use Dynamic Management Views by Glenn Berry
48. Query performance and disk I/O counters by Linchi Shea
49. XEVENT: the next event infrastructure for SQL Server by Cristian Lefter

PART V    BI DEVELOPMENT
Greg Low, Editor

50. BI for the relational guy by Erin Welker
51. Unlocking the secrets of SQL Server 2008 Reporting Services by William Vaughn
52. Reporting Services tips and tricks by Bruce Loehle-Conger
53. SQL Server Audit: change tracking or change data capture? by Aaron Bertrand
54. Introduction to SSAS data mining by Dejan Sarka
55. To aggregate or not to aggregate: is there really a question? by Erin Welker
56. Incorporating data profiling in the ETL process by John Welch
57. Expressions in SQL Server Integration Services by Matthew Roche
58. SSIS performance tips by Phil Brammer
59. Incremental loads using T-SQL and SSIS by Andy Leonard

One of this chapter is special for me, because has been written by my friend SQL Server MVP from Poland: Pawel Potasinski {BLOG | TWITTER}!

And now You can (and still MUST HAVE !!) buy this book on SALE for 38.00  USD (regular price 59,99 USD) at Amazon.com HERE and/or still on Manning shop HERE in digital formats too: for Kindle or other readers.

And one good news for the end:

 SQL Server MVP Deep Dives Volume Two is coming !!! 

More information soon on internet and on this blog too.