| Microsoft SQL Server 2012 Internals Posted: 12 Feb 2014 07:20 AM PST 
Book Description Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you're a database developer, architect, or administrator. Discover how to: - Dig into SQL Server 2012 architecture and configuration
- Use the right recovery model and control transaction logging
- Reduce query execution time through proper index design
- Track events, from triggers to the Extended Event Engine
- Examine internal structures with database console commands
- Transcend row-size limitations with special storage capabilities
- Choose the right transaction isolation level and concurrency model
- Take control over query plan caching and reuse
Table of Contents
Chapter 1. SQL Server 2012 architecture and configuration
Chapter 2. The SQLOS
Chapter 3. Databases and database files
Chapter 4. Special databases
Chapter 5. Logging and recovery
Chapter 6. Table storage
Chapter 7. Indexes: internals and management
Chapter 8. Special storage
Chapter 9. Special indexes
Chapter 10. Query execution
Chapter 11. The Query Optimizer
Chapter 12. Plan caching and recompilation
Chapter 13. Transactions and concurrency
Chapter 14. DBCC internals Book Details - Paperback: 982 pages
- Publisher: Microsoft Press (November 2013)
- Language: English
- ISBN-10: 0735658560
- ISBN-13: 978-0735658561
Note: There is a file embedded within this post, please visit this post to download the file. Related Books The post Microsoft SQL Server 2012 Internals appeared first on Wow! eBook. |
| Windows PowerShell Best Practices Posted: 12 Feb 2014 07:18 AM PST 
Book Description Expert recommendations, pragmatically applied. Automate system administration using Windows PowerShell best practices—and optimize your operational efficiency. With this practical guide, Windows PowerShell expert and instructor Ed Wilson delivers field-tested tips, real-world examples, and candid advice culled from administrators across a range of business and technical scenarios. If you're an IT professional with Windows PowerShell experience, this book is ideal. Discover how to: - Use Windows PowerShell to automate Active Directory tasks
- Explore available WMI classes and methods with CIM cmdlets
- Identify and track scripting opportunities to avoid duplication
- Use functions to encapsulate business logic and reuse code
- Design your script's best input method and output destination
- Test scripts by checking their syntax and performance
- Choose the most suitable method for running remote commands
- Manage software services with Desired State Configuration
Table of Contents
Part I: Understanding the basics of Windows PowerShell
Chapter 1. Survey of Windows PowerShell capabilities
Chapter 2. Using the CIM cmdlets Part II: Planning for scripting
Chapter 3. Using the Active Directory module
Chapter 4. Identifying scripting opportunities
Chapter 5. Configuring the script environment
Chapter 6. Avoiding scripting pitfalls
Chapter 7. Tracking scripting opportunities Part III: Designing the script
Chapter 8. Designing the script
Chapter 9. Designing help for scripts
Chapter 10. Designing modules
Chapter 11. Handling input and output
Chapter 12. Handling errors
Chapter 13. Testing scripts
Chapter 14. Documenting scripts Part IV: Deploying the script
Chapter 15. Managing the execution policy
Chapter 16. Running scripts
Chapter 17. Versioning scripts
Chapter 18. Logging results
Chapter 19. Troubleshooting scripts
Chapter 20. Using the Windows PowerShell ISE
Chapter 21. Using Windows PowerShell remoting and jobs
Chapter 22. Using Windows PowerShell Workflow
Chapter 23. Using the Windows PowerShell DSC Book Details - Paperback: 760 pages
- Publisher: Microsoft Press (December 2013)
- Language: English
- ISBN-10: 0735666490
- ISBN-13: 978-0735666498
Note: There is a file embedded within this post, please visit this post to download the file. Related Books The post Windows PowerShell Best Practices appeared first on Wow! eBook. |
| Microsoft SharePoint 2013 Administration Inside Out Posted: 12 Feb 2014 07:14 AM PST 
Book Description Conquer Microsoft SharePoint 2013 administration—from the inside out! Dive into SharePoint 2013 administration—and really put your systems expertise to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. Discover how the experts deploy, configure, and manage SharePoint—and challenge yourself to new levels of mastery. - Automate the installation and configuration of SharePoint 2013
- Effectively manage SharePoint apps and custom solutions
- Optimize farms, web apps, content databases, and site collections
- Use methods to help users attain productive search experiences
- Configure business intelligence features in SharePoint 2013
- Dive deep into SharePoint security practices and architecture
- Add SharePoint Online to your existing SharePoint environment
- Manage User Profiles and the SharePoint social experience
- Monitor and troubleshoot SharePoint with insider tips
For Intermediate to Advanced IT Professionals Table of Contents
Chapter 1. What's new in SharePoint 2013
Chapter 2. Planning and preparing for SharePoint 2013 installation
Chapter 3. Upgrading to SharePoint 2013
Chapter 4. Installing SharePoint 2013
Chapter 5. Managing farms, web applications, and content databases
Chapter 6. Creating and managing service applications
Chapter 7. Creating and managing site collections
Chapter 8. Creating and configuring Search service applications
Chapter 9. Customizing search results and the Search Center site
Chapter 10. Configuring Metadata Management Services
Chapter 11. Configuring User Profile Services
Chapter 12. Understanding and configuring social capabilities
Chapter 13. Configuring Business Connectivity Services
Chapter 14. Configuring records management and eDiscovery
Chapter 15. Understanding and managing SharePoint 2013 apps
Chapter 16. Managing farm and sandboxed solutions
Chapter 17. Installing and configuring business intelligence components
Chapter 18. Monitoring and troubleshooting SharePoint 2013
Chapter 19. Understanding and configuring security
Chapter 20. Scaling and optimizing farms
Chapter 21. Installing and configuring Office Web Apps 2013
Chapter 22. Understanding SharePoint Online, Azure, and hybrid scenarios
Chapter 23. Performing content and disaster recovery Book Details - Paperback: 954 pages
- Publisher: Microsoft Press (January 2014)
- Language: English
- ISBN-10: 0735675392
- ISBN-13: 978-0735675391
Note: There is a file embedded within this post, please visit this post to download the file. Related Books The post Microsoft SharePoint 2013 Administration Inside Out appeared first on Wow! eBook. |
| Microsoft Excel 2013: Data Analysis and Business Modeling Posted: 12 Feb 2014 07:10 AM PST 
Book Description Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel—and sharpen your edge - Summarize data with PivotTables and Descriptive Statistics
- Explore new trends in predictive and prescriptive analytics
- Use Excel Trend Curves, multiple regression, and exponential smoothing
- Master advanced Excel functions such as OFFSET and INDIRECT
- Delve into key financial, statistical, and time functions
- Make your charts more effective with the Power View tool
- Tame complex optimization problems with Excel Solver
- Run Monte Carlo simulations on stock prices and bidding models
- Apply important modeling tools such as the Inquire add-in
Table of Contents
Chapter 1. Range names
Chapter 2. Lookup functions
Chapter 3. INDEX function
Chapter 4. MATCH function
Chapter 5. Text functions
Chapter 6. Dates and date functions
Chapter 7. Evaluating investments by using net present value criteria
Chapter 8. Internal rate of return
Chapter 9. More Excel financial functions
Chapter 10. Circular references
Chapter 11. IF statements
Chapter 12. Time and time functions
Chapter 13. The Paste Special command
Chapter 14. Three-dimensional formulas
Chapter 15. The Auditing tool and Inquire add-in
Chapter 16. Sensitivity analysis with data tables
Chapter 17. The Goal Seek command
Chapter 18. Using the Scenario Manager for sensitivity analysis
Chapter 19. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
Chapter 20. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
Chapter 21. The OFFSET function
Chapter 22. The INDIRECT function
Chapter 23. Conditional formatting
Chapter 24. Sorting in Excel
Chapter 25. Tables
Chapter 26. Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes
Chapter 27. The analytics revolution
Chapter 28. Introducing optimization with Excel Solver
Chapter 29. Using Solver to determine the optimal product mix
Chapter 30. Using Solver to schedule your workforce
Chapter 31. Using Solver to solve transportation or distribution problems
Chapter 32. Using Solver for capital budgeting
Chapter 33. Using Solver for financial planning
Chapter 34. Using Solver to rate sports teams
Chapter 35. Warehouse location and the GRG Multistart and Evolutionary Solver engines
Chapter 36. Penalties and the Evolutionary Solver
Chapter 37. The traveling salesperson problem
Chapter 38. Importing data from a text file or document
Chapter 39. Importing data from the Internet
Chapter 40. Validating data
Chapter 41. Summarizing data by using histograms
Chapter 42. Summarizing data by using descriptive statistics
Chapter 43. Using PivotTables and slicers to describe data
Chapter 44. The Data Model
Chapter 45. PowerPivot
Chapter 46. Power View
Chapter 47. Sparklines
Chapter 48. Summarizing data with database statistical functions
Chapter 49. Filtering data and removing duplicates
Chapter 50. Consolidating data
Chapter 51. Creating subtotals
Chapter 52. Charting tricks
Chapter 53. Estimating straight-line relationships
Chapter 54. Modeling exponential growth
Chapter 55. The power curve
Chapter 56. Using correlations to summarize relationships
Chapter 57. Introduction to multiple regression
Chapter 58. Incorporating qualitative factors into multiple regression
Chapter 59. Modeling nonlinearities and interactions
Chapter 60. Analysis of variance: one-way ANOVA
Chapter 61. Randomized blocks and two-way ANOVA
Chapter 62. Using moving averages to understand time series
Chapter 63. Winters's method
Chapter 64. Ratio-to-moving-average forecast method
Chapter 65. Forecasting in the presence of special events
Chapter 66. An introduction to random variables
Chapter 67. The binomial, hypergeometric, and negative binomial random variables
Chapter 68. The Poisson and exponential random variable
Chapter 69. The normal random variable
Chapter 70. Weibull and beta distributions: modeling machine life and duration of a project
Chapter 71. Making probability statements from forecasts
Chapter 72. Using the lognormal random variable to model stock prices
Chapter 73. Introduction to Monte Carlo simulation
Chapter 74. Calculating an optimal bid
Chapter 75. Simulating stock prices and asset allocation modeling
Chapter 76. Fun and games: simulating gambling and sporting event probabilities
Chapter 77. Using resampling to analyze data
Chapter 78. Pricing stock options
Chapter 79. Determining customer value
Chapter 80. The economic order quantity inventory model
Chapter 81. Inventory modeling with uncertain demand
Chapter 82. Queuing theory: the mathematics of waiting in line
Chapter 83. Estimating a demand curve
Chapter 84. Pricing products by using tie-ins
Chapter 85. Pricing products by using subjectively determined demand
Chapter 86. Nonlinear pricing
Chapter 87. Array formulas and functions Book Details - Paperback: 888 pages
- Publisher: Microsoft Press (January 2014)
- Language: English
- ISBN-10: 0735669139
- ISBN-13: 978-0735669130
Note: There is a file embedded within this post, please visit this post to download the file. Related Books The post Microsoft Excel 2013: Data Analysis and Business Modeling appeared first on Wow! eBook. |
| Windows Server 2012 R2 Pocket Consultant: Storage, Security, & Networking Posted: 12 Feb 2014 07:06 AM PST 
Book Description Portable and precise, this pocket-sized guide delivers ready answers for administering storage, security, and networking features in Windows Server 2012 R2. Zero in on core tasks through quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done – whether at your desk or in the field. Coverage includes: - Managing file systems and drives
- Configuring storage
- Data sharing
- Managing TCP/IP networking
- Running DHCP clients and servers
- Optimizing DNS
- Administering network printers and print services
- Security, compliance, and auditing
- Backup and recovery
Table of Contents
Chapter 1. Managing file systems and drives
Chapter 2. Configuring storage
Chapter 3. Data sharing and redundancy
Chapter 4. Data security and auditing
Chapter 5. Enhancing computer security
Chapter 6. Managing users and computers with Group Policy
Chapter 7. Managing TCP/IP networking
Chapter 8. Running DHCP clients and servers
Chapter 9. Optimizing DNS
Chapter 10. Administering network printers and print services
Chapter 11. Data backup and recovery Book Details - Paperback: 416 pages
- Publisher: Microsoft Press (January 2014)
- Language: English
- ISBN-10: 0735682593
- ISBN-13: 978-0735682597
Note: There is a file embedded within this post, please visit this post to download the file. Related Books The post Windows Server 2012 R2 Pocket Consultant: Storage, Security, & Networking appeared first on Wow! eBook. |
Tidak ada komentar:
Posting Komentar