[EN] My book (MVP Deep Dives Vol2) has arrived !

SQLSRVMVPDDII_5Today, 2nd of November is my name day. And one of the best gift for all my name days has been delivered about midday. I’m sure, that You remember about my voluntary works in special project: Operation Smile. In fact I wrote one – 18th – chapter for new Manning Book: SQL Server MVP Deep Dives Volume Two. And printed version of this book, called Author’s Copy is now in my hands.

It was very hard job for me. I wrote it in Polish, next tranlated to English, send for proofreader, and send few times to my Great Bosses in this project: Paul Randal and Kimberly Tripp. I must say: BIG THANK YOU for this opportunity; for You help and patience. It’s my first experience with this kind of job: as writing for english readers. Hope my chapter will be interesting and halpfull for You. Please send me any comments, opinions, bad and/or good words when You read this. SQLSRVMVPDDII_6

Please buy this book, all money will go not for authors, but for childrens – directly for Operation Smile Foundation. Outside my chapter You will find a tons of great knowledge based on hundreds years of experience by over 60 Microsoft SQL Server Most Valuable Professionals. For details go HERE.

Last but not least – It looks excellent, isn’t?

[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:

  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

  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

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
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

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

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!