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


[EN] RTM status for Self-Paced Training Kit 70-667 (SharePoint 2010)

BOOKLET__MSPress_MCTS70667Microsoft Press announced on his blog that new Training Kit going to print. It is MCTS Self-Paced Training Kit (Exam 70-667): Configuring Microsoft SharePoint 2010 (ISBN 9780735638853)by Dan Holme {BLOG|TWITTER} and Alastair Matthews {BLOG}. This book contains a lot of informations, lesson files, labs, practice test and advices for everyone who think about passing Prometric Exam 70-667.

In this book 864 pages are collected in twelve chapters below:

CHAPTER 01 | Creating a SharePoint 2010 Intranet
CHAPTER 02 | Administering and Automating SharePoint
CHAPTER 03 | Managing Web Applications
CHAPTER 04 | Administering and Securing SharePoint Content
CHAPTER 05 | Service Applications and the Managed Metadata Service
CHAPTER 06 | Configuring User Profiles and Social Networking
CHAPTER 07 | Administering SharePoint Search
CHAPTER 08 | Implementing Enterprise Service Applications
CHAPTER 09 | Deploying and Upgrading to SharePoint 2010
CHAPTER 10 | Administering SharePoint Customization
CHAPTER 11 | Implementing Business Continuity
CHAPTER 12 | Monitoring and Optimizing SharePoint Performance

As the publisher wrote on blog post:

By using this training kit, you will learn how to do the following:

  • Deploy SharePoint Server 2010 farms.
  • Create a logical architecture of web applications, content databases, site collections, and sites.
  • Manage security of SharePoint content by configuring authentication and access controls.
  • Configure SharePoint services including search, user profiles, and the managed metadata service.
  • Optimize, monitor, and troubleshoot performance of SharePoint servers and services.
  • Ensure that data is protected and highly available.
  • Deploy and manage customized SharePoint functionality and solutions.


More information You can find on MS Press Blog HERE and in official store on O’Reily shop HERE.


Product Details (by O’Reilly Media)

Title: MCTS Self-Paced Training Kit (Exam 70-667): Configuring Microsoft® SharePoint® 2010
By: Dan Holme, Alastair Matthews
Publisher: Microsoft Press
Formats: Print | Safari Books Online
Print: September 2011 (est.)
Pages: 864 (est.)
Print ISBN: 978-0-7356-3885-3 | ISBN 10: 0-7356-3885-3

[PL] Bezpłatne szkolenia MS Office w DC Edukacja

Przyszedł wczoraj do mnie mailing, nie omieszkam się zatem tą informacją podzielić:

LOGO__DCEdukacjaFirma DC Edukacja realizuje obecnie projekt, który obejmuje BEZPŁATNE SZKOLENIA informatyczne m.in. z zakresu MS Office (MS Word, MS Excel, MS Access, MS PowerPoint). Szkolenia objęte są  dofinansowaniem ze środków Unii Europejskiej i są realizowane w ramach projektu: „Szkolenia informatyczne dla pracowników z branż: hotelarstwo, turystyka, gastronomia i obsługa imprez masowych z woj. dolnośląskiego”.
Przesyłamy tę informację do Państwa z prośbą o przekazanie jej dalej, bo być może ktoś z Państwa rodziny lub znajomych będzie chciał skorzystać z bezpłatnych szkoleń – warunek – musi pracować w jednej z wyżej wymienionych branż. Szczegółowe informacje o bezpłatnych szkoleniach realizowanych w ramach projektu można uzyskać na stronie
www.e2012.edukacja.com lub w Biurze Szkoleń pod numerem tel. 71/ 348 81 02

Informacje o szkoleniach

Szkolenia realizowane w ramach projektu składają się z:

  • Zajęć stacjonarnych – 24 godziny
  • E-learning – 2 tygodnie

Zajęcia stacjonarne będą realizowane poza godzinami i miejscem pracy Uczestników/Uczestniczek. Możliwe tryby realizacji zajęć stacjonarnych:

  • Tryb poranny: 6 dni x 4 godziny (w godzinach 8.30-11.45)
  • Tryb popołudniowy: 6 dni x 4 godziny (w godzinach 16.30-19.45)
  • Tryb dzienny: 3 dni x 8 godzin (w godzinach 8.30-15.30)
  • Tryb weekendowy: 3 dni x 8 godzin (w godzinach 9.00-16.00)

Część e-learningowa trwa 2 tygodnie i  realizowana jest pomiędzy zajęciami stacjonarnymi. Uczestnicy/Uczestniczki Projektu otrzymują dane dostępowe (login i hasło) do materiałów udostępnionych na platformie e-learningowej w pierwszym dniu szkolenia stacjonarnego. E-learning pozwala na samodzielne pogłębienie wiedzy wiedzę w miarę potrzeb i czasu Uczestników/Uczestniczek Projektu. Projekt przewiduje realizację szkoleń informatycznych w 60 grupach o średniej liczebności – 10 osób.

Każdy z Uczestników/Uczestniczek może wziąć udział średnio w 2 szkoleniach.

.TEMATY SZKOLEŃ (kliknij w wybrany temat i dowiedz się więcej)