[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] SQL Server MVP Deep Dives Free PASS Edition

BOOKLET__MVPDeepDives_FreePASSeditionYes, I know – we all should be in Seattle now at PASS Summit 2011. But it is not possible. Yes, I know – almost all of us waiting for delivery of fresh, just published (on Thursday, 13th October) SQL Server MVP Deep Dives Volume Two: Operation Smile. But… Why we are waiting?

In the meantime between ordering process (I prefer Manning Shop) and delivery GREAT moment… we can preview a selected chapters from both volumes: SQL Server MVP Deep Dives Volume One: War Child and SQL Server MVP Deep Dives Volume Two: Operation Smile. Just go to Manning Special Site, and get free PDF format (for kindle and epub will be soon) with four selected chapters of each books (almost one hundred pages):

From SQL Server MVP Deep Dives
BI for the Relational Guy by Erin Welker
Business Intelligence can be intimidating if you spend most of your time in relational database development. This chapter provides an overview of building BI solutions from the perspective of traditional relational database development–including tips from someone who’s been there.

Louis and Paul’s 10 key relational database design ideas by Paul Nielsen and Louis Davidson
Database design hasn’t changed considerably in the past ten years, and yet we often see the same mistakes now that we did in the early days of SQL Server. Paul and Louis take a swing at ten key concepts required to design and implement a database the right way.

Practical Auditing in SQL Server 2008 by Jasper Smith
Starting with SQL Server 2008, Enterprise Edition, instance and database audits are built into the database engine. This chapter looks at the lightweight audit model and the new extended events infrastructure.

Tracing the Deadlock by Gail Shaw
Have you ever seen a deadlock? If so, you’ve also stared at the incomprehensible error messages and deadlock graph pages that accompany it. Here, Gail Shaw shows you how to trace the details of a deadlock and tease the necessary information out of the deadlock graph so you can figure out what happened and how to fix it.

From SQL Server MVP Deep Dives, Volume 2
TSQL: Bad Habits to Kick by Aaron Bertrand
We all haall have bad habits, but not many are as obvious as using SELECT *. In this chapter, Aaron explains a few of these bad habits that affect performance and maintainability, how they develop, and why they’re so bad in the first place.

Yes, we are all "individuals" (A look at uniqueness in the world of SQL) by Rob Farley
You may know that you can put uniqueness constraints on your data. You may not realize the significant benefits uniqueness constraints can have on your SQL queries. Here, Rob Farley shows you how to make the most of this unique feature.

SQL Server Cost Recovery by Peter Ward
IT departments are continually being asked to do more with less because it’s difficult to recover the costs associated with database management. Peter Ward shows you techniques to recover the costs associated with SQL Server management in a way that will satisfy the corporate bean counters.

Parameter Sniffing: Your Best Friend…Except When It Isn’t by Grant Fritchey
Parameter sniffing has two faces. Here, Grant Fritchey shows you the good side of the technique, which should be complimented and promoted. He also outlines several ways that bad parameter sniffing can be addressed and presents mechanisms for investigating bad parameter sniffing issues.

It’s easy, nice and AWESOME!!!!

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