• دانلود رایگان کتاب Beginning SQL Server for Developers

    Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory features that are introduced in SQL Server 2014.

    Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and be introduced to best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code.

    SQL Server 2014 introduces in-memory tables and stored procedures. It's now possible to accelerate applications by creating tables (and their indexes) that reside entirely in memory, and never on disk. These new, in-memory structures differ from caching mechanisms of the past, and make possible the extraordinarily swift execution of certain types of queries such as are used in business intelligence applications. Beginning SQL Server for Developershelps you realize the promises of this new feature set while avoiding pitfalls that can occur when mixing in-memory tables and code with traditional, disk-based tables and code.

    Beginning SQL Server for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server.

     

    • Takes you through the entire database application development lifecycle
    • Includes brand new coverage of the in-memory features
    • Introduces the freely-available Express Edition
    تعداد صفحات کتاب 684
    Author Bio:
    Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.
    ISBN : 978-1484202814
    Publisher : Apress; 4th ed. 2015 edition
  • دانلود رایگان کتاب Business Intelligence: Making Better Decisions Faster

    This book illustrates how organizations can make better, faster decisions about their customers, partners, and operations using business intelligence, the process of turning large amounts of data into valuable information and making it easily available to decision makers. The book describes the comp
    تعداد صفحات کتاب نا مشخص
    Author Bio:
    Elizabeth Vitt, a manager at Aspirity, has six years of business development, project management, consulting, and training experience in business intelligence. Her industry experience includes implementations in retail, manufacturing, and healthcare. She has specialized expertise as an educator in data-warehousing design and implementation and is an author of the Microsoft® Official Curricula (MOC) for Microsoft's business intelligence product offerings. Elizabeth is also a frequent speaker at SQL Server™ conferences worldwide. She earned a B.S. in environmental engineering from Northwestern University in Evanston, IL.Michael Luckevich, the CEO of Aspirity, has 18 years of information technology and business intelligence experience. He has extensive experience in the architecture, design, development, and implementation of complex business intelligence solutions. He frequently teaches classes and offers seminars on various topics relating to business intelligence, data warehousing, and OLAP technologies. Michael is a graduate of the University of Waterloo Faculty of Mathematics.Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server®, including Microsoft SQL Server 2005 Reporting Services Step by Step. She is also the coauthor of Microsoft® SQL Server 2005 Administrator's Companion.
    ISBN : 978-0735616271
    Publisher : Microsoft Press
  • دانلود رایگان کتاب Essential SQLAlchemy

    Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the "cool" features.

    SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper (ORM) that lets you map "plain old Python objects" (POPOs) to database tables without substantially changing your existing Python code. Essential SQLAlchemy demonstrates how to use the library to create a simple database application, walks you through simple queries, and explains how to use SQLAlchemy to connect to multiple databases simultaneously with the same Metadata. You also learn how to:
     

    • Create custom types to be used in your schema, and when it's useful to use custom rather than built-in types
    • Run queries, updates, and deletes with SQLAlchemy's SQL expression language
    • Build an object mapper with SQLAlchemy, and understand the differences between this and active record patterns used in other ORMs
    • Create objects, save them to a session, and flush them to the database
    • Use SQLAlchemy to model object oriented inheritance
    • Provide a declarative, active record pattern for use with SQLAlchemy using the Elixir extension
    • Use the SQLSoup extension to provide an automatic metadata and object model based on database reflection

    In addition, you'll learn how and when to use other extensions to SQLAlchemy, including AssociationProxy, OrderingList, and more.

    Essential SQLAlchemy is the much-needed guide for every Python developer using this code library. Instead of a feature-by-feature documentation, this book takes an "essentials" approach that gives you exactly what you need to become productive with SQLAlchemy right away.

    تعداد صفحات کتاب 240
    Author Bio:
    Rick Copeland is a senior software engineer with retail analytics firm Predictix, LLC, where he uses SQLAlchemy extensively, primarily for web application development. He has been using Python full-time for development since 2005, in projects as diverse as demand forecasting, business web applications, compilers, and hardware synthesis.
    ISBN : 978-0596516147
    Publisher : O'Reilly Media; 1 edition
  • دانلود رایگان کتاب Expert SQL Server in-Memory OLTP

    Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 – support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically increase transactional throughput to handle thousands of transactions per second supporting millions of customers.
     
    Dmitri Korotkevitch is the five-star author of Pro SQL Server Internals, and now brings his same combination of clear thinking and deep expertise to the question of how to recognize the opportunities and benefit from Microsoft’s In-Memory OLTP feature set in SQL Server 2014.
     
    Learn the architecture and the internals in order to recognize when In-Memory OLTP can make a difference. Learn useful scenarios for thoughtfully incorporating in-memory support into existing applications. Recognize opportunities for In-Memory OLTP in new development. Don’t be without Dmitri Korotkevitch and the deep expertise he imparts in Expert SQL Server In-Memory OLTP as you move forward in using SQL Server’s new and important In-Memory OLTP feature set. 
    • Covers In-Memory OLTP internals and architecture, includin
    g data storage, indexing, multi-version concurrency control, transaction logging, and recovery
     
    • Illustrates In-Memory OLTP programmabili
    • ty and the process of native compilation
    • Guides in using In-Memory OLTP in new development and existing systems.
    تعداد صفحات کتاب 248
    Author Bio:
    Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master (in SQL Server 2008). He brings years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in design, development, and performance tuning of OLTP Systems working under heavy load.Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world. He blogs at: http://aboutsqlserver.com.
    ISBN : 978-1484211373
    Publisher : Apress; 1st ed. 2015 edition
  • دانلود رایگان کتاب Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services

    Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS.

    SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed.

    • Provides a timeless scripting toolkit for all current SSIS versions
    • Gives a comprehensive explanation of scripting in SSIS
    • Offers a wide array of readymade examples for everyday problems
    تعداد صفحات کتاب 472
    Author Bio:
    Joost van Rossum is a Data Warehouse / Business Intelligence consultant for over 10 years with a focus on the Microsoft SQL Server stack and especially on SQL Server Integration Services. He speaks, writes and blogs (http://microsoft-ssis.blogspot.com) about SSIS and related matters. He is a moderator for the Microsoft Developer Network for the SQL Server Integration Services forum and an active volunteer for the PASS Chapter in the Netherlands. In 2014 he was awarded with an MVP award for SQL Server. You can find him on twitter at @SSISJoostRégis Baccaro was born from the illegitimate alliance of C# and Business Intelligence in a SharePoint farm. He currently works as a Principal Consultant in Denmark mainly doing architecture, mentoring and performance tuning of large SQL Server DataWarehouses installations. He blogs at http://theblobfarm.wordpress.com and he is the founder of SQL Saturday Denmark, an active member of the European SQL Server community and a top-rated speaker at SQL Server conferences. When not working on a SQL Server you can find him cooking, running or farming on his Danish island. He tweets at @regbac.
    ISBN : 978-1484206393
    Publisher : Apress; 1st ed. 2015 edition
  • دانلود رایگان کتاب Mastering SQL Server 2014 Data Mining

    Master selecting, applying, and deploying data mining models to build powerful predictive analysis frameworks

    About This Book

    • Understand the different phases of data mining, along with the tools used at each stage
    • Explore the different data mining algorithms in depth
    • Become an expert in optimizing algorithms and situation-based modeling

    Who This Book Is For

    If you are a developer who is working on data mining for large companies and would like to enhance your knowledge of SQL Server Data Mining Suite, this book is for you. Whether you are brand new to data mining or are a seasoned expert, you will be able to master the skills needed to build a data mining solution.

    What You Will Learn

    • Get an overview of the data mining life cycle
    • Understand the intricacies of SQL Server BI Suite with the help of a practical example
    • Collate data from diverse data sources and build a data warehouse
    • Gain in-depth knowledge about the various data mining models such as classification, segmentation, association, and more
    • Perform data mining using Big Data and Excel add-ins
    • Work on real-world data and gain insights into it using various data mining algorithms
    • Fine tune data mining models
    • Troubleshoot problems encountered during data mining activities performed in this book

    In Detail

    Whether you are new to data mining or are a seasoned expert, this book will provide you with the skills you need to successfully create, customize, and work with Microsoft Data Mining Suite. Starting with the basics, this book will cover how to clean the data, design the problem, and choose a data mining model that will give you the most accurate prediction.

    Next, you will be taken through the various classification models such as the decision tree data model, neural network model, as well as Naive Bayes model. Following this, you'll learn about the clustering and association algorithms, along with the sequencing and regression algorithms, and understand the data mining expressions associated with each algorithm. With ample screenshots that offer a step-by-step account of how to build a data mining solution, this book will ensure your success with this cutting-edge data mining system.

    تعداد صفحات کتاب 386
    Author Bio:
    Amarpreet Singh Bassan Amarpreet Singh Bassan is a Microsoft Data Platform engineer who works on SQL Server and its surrounding technologies. He is a subject matter expert in SQL Server Analysis Services and reporting services. Amarpreet is also a part of Microsoft's HDInsight team. Debarchan Sarkar Debarchan Sarkar is a Microsoft Data Platform engineer. He specializes in the Microsoft SQL Server Business Intelligence stack. Debarchan is a subject matter expert in SQL Server Integration Services and delves deep into the open source world, specifically the Apache Hadoop framework. He is currently working on a technology called HDInsight, which is Microsoft's distribution of Hadoop on Windows. He has authored various books on SQL Server and Big Data, including Microsoft SQL Server 2012 with Hadoop, Packt Publishing, and Pro Microsoft HDInsight: Hadoop on Windows, Apress. His Twitter handle is @debarchans.
    ISBN : 978-1849688949
    Publisher : Packt Publishing - ebooks Account
  • دانلود رایگان کتاب Microsoft Azure SQL Database Step by Step (Step by Step Developer)

    Your hands-on guide to Azure SQL Database fundamentals
    Expand your expertise--and teach yourself the fundamentals of Microsoft Azure SQL Database. If you have previous programming experience but are new to Azure, this book is the tutorial that delivers the step-by-step guidance and coding exercises you need to master core topics and techniques.
    Discover how to:
    • Setup and configure Azure and SQL Database
    • Explore design and security considerations
    • Migrate databases and data
    • Backup and sync data
    • Design for scalability and high performance
    • Develop web and mobile applications using Azure SQL Database
    • Understand the differences between SQL Server on-premises and Azure SQL Database
    تعداد صفحات کتاب 400
    Author Bio:
    Eric D. Boyd has been helping companies drive innovation and accelerate time-to-market for the past two decades. During this time he has helped both tech startups and global enterprises deliver web, mobile and traditional client and server applications. Eric is a leading expert on cloud computing and Microsoft Azure. He spends most of his time helping companies boost agility and scale massively in the cloud. He is a Microsoft Azure MVP, and an Azure Insider, leads responsiveX which is a consultancy and Microsoft Azure Partner with offices in Chicago and Milwaukee, and is a frequent presenter at conferences around the world including Cloud Connect, Visual Studio Live, Live 360, and Microsoft's AzureConf.   Leonard G. Lobel, Microsoft MVP for SQL Server, is a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner, and he's one of the industry's leading .NET and SQL Server experts.
    ISBN : 978-0735679429
    Publisher : Microsoft Press; 1 edition
  • دانلود رایگان کتاب Pro SQL Server Wait Statistics

     

    Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding of how wait statistics are generated and what they can mean for your SQL Server’s performance.

    Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance threatening wait types. The different wait types are categorized by their area of impact, and include CPU, IO, Lock, and many more different wait type categories. Filled with clear examples, Pro SQL Server Wait Statisticshelps you gain practical knowledge of why and how specific wait times increase or decrease, and how they impact your SQL Server’s performance.

    What you’ll learn

    • How wait Statistics are generated by SQL Server
    • Script examples for analyzing and tuning wait statistics
    • How to lower, or even eliminate, wait times that hurt performance
    • How to query wait statistics information from Dynamic Management Views
    • How to build reliable and solid wait statistics baselines from which to detect performance issues

    Who this book is for

    Pro SQL Server Wait Statistics is the perfect guide for SQL Server DBAs wanting to troubleshoot and optimize SQL Server database installations. The book is also of interest to database developers who are serious about developing highly-performant applications and reporting systems.

    Table of Contents

    Introduction

    Part I: Foundations of Wait Statistics Analysis

    1. How Wait Statistics are Generated

    2. Querying Wait Statistics

    3. Building a Solid Baseline

    Part II: Wait Types

    4. CPU Wait Types

    5. I/O Wait Types

    6. Backup Wait Types

    7. Lock Wait Types

    8. Latch Wait Types

    9. High-Availability and Disaster Recovery Wait Types

    10: Preemptive Wait Types

    11: Background and Miscellaneous Wait Types

    12. Chapter 12

    13: Appendix A

    14. Appendix B

    15. Appendix C

     

    تعداد صفحات کتاب 336
    Author Bio:
    Enrico van de Laar is a database technology specialist with over a decade of experience with SQL Server. Enrico works for a Dutch IT company that specializes in building IT solutions for the Dutch healthcare sector, there he is responsible for maintaining and optimizing the databases of some of the largest hospitals in the Netherlands. Enrico is also the founder of DotNine SQL Server Training, a company that specializes in Microsoft SQL Server related training. Enrico is a SQL Server MVP and his main specializations inside SQL Server are performance tuning and database architecture.
    ISBN : 978-1484211403
    Publisher : Apress; 1 edition
  • دانلود کتاب Mastering SQL Server 2014 Data Mining

    Master selecting, applying, and deploying data mining models to build powerful predictive analysis frameworksAbout This Book
    • Understand the dif
  • دانلود کتاب Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)

    EXAM PREP GUIDE

    Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guid

  • دانلود کتاب Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

    Now in its second edition, this best-selling book by Tom Kyte of "Ask Tom" fame continues to bring you some of the best thinking on how to

  • دانلود کتاب Mastering MariaDB

    Debug, secure, and back up your data for optimum server performance with MariaDBAbout This Book
    • Monitor database activity and the major operati
  • دانلود کتاب آموزشی Developing Analytic Talent: Becoming a Data Scientist

    Harvard Business Review calls it the sexiest tech job of the 21st century. Data scientists are in demand, and this unique book shows you exactly what employers want and the skill set that separates the quality data scientist from other talented IT professionals. Data science involves extracting, creating, and processing data to turn it into business value. With over 15 years of big data, predictive modeling, and business analytics experience, author Vincent Granville is no stranger to data science. In this one-of-a-kind guide, he provides insight into the essential data science skills, such as statistics and visualization techniques, and covers everything from analytical recipes and data science tricks to common job interview questions, sample resumes, and source code.

  • دانلود کتاب آموزشی Microsoft Big Data Solutions از کمپانی Wiley

    Big Data is here, and Microsoft's new Big Data platform is a valuable tool to help your company get the very most out of it. This timely book shows you how to use HDInsight along with HortonWorks Data Platform for Windows to store, manage, analyze, and share Big Data throughout the enterprise. Focusing primarily on Microsoft and HortonWorks technologies but also covering open source tools, Microsoft Big Data Solutions explains best practices, covers on-premises and cloud-based solutions, and features valuable case studies.

  • دانلود کتاب آموزشی Creating Business Agility, How Convergence of Cloud Social Mobile Video and Big Data Enables Competitive Advantage

    Creating Business Agility: How Convergence of Cloud, Social, Mobile, Video, and Big Data Enables Competitive Advantage provides a game plan for integrating technology to build a smarter, more customer-centric business. Using a series of case studies as examples throughout, the book describes the agility that comes from collaborative commerce, and provides key decision makers the implementation roadmap they need to build a successful business ecosystem. The focus is on Business Agility Readiness in terms of the five major changes affecting the information technology landscape, and how data-driven delivery platforms and decision-making processes are being reinvented using digital relationships with a social business model as the consumer world of technology drives innovation and collaboration.

  • دانلود کتاب آموزشی Competing with High Quality Data, Concepts Tools and Techniques for Building a Successful Approach to Data Quality

    Data is rapidly becoming the powerhouse of industry, but low-quality data can actually put a company at a disadvantage. To be used effectively, data must accurately reflect the real-world scenario it represents, and it must be in a form that is usable and accessible. Quality data involves asking the right questions, targeting the correct parameters, and having an effective internal management, organization, and access system. It must be relevant, complete, and correct, while falling in line with pervasive regulatory oversight programs.

  • دانلود کتاب آموزشی Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services

    Complementing the bestselling Balanced Scorecards and Operational Dashboards with Microsoft Excel (9780470386811), this indispensable book shows you how to create maintainable and dynamically updated scorecards and performance dashboards using Microsoft's premier reporting tool for the enterprise: SQL Server Reporting Services. The book begins with coverage of performance management methods and metrics and then moves on to introduce you to techniques for developing and delivering both a dashboard and balanced scorecard using Reporting Services. The authors assume very limited knowledge of Reporting Services, allowing you to gradually progress through more advanced topics and solutions.

  • دانلود کتاب آموزشی Big Data, Data Mining and Machine Learning 2014

    Big data is big business. But having the data and the computational power to process it isn't nearly enough to produce meaningful results. Big Data, Data Mining, and Machine Learning: Value Creation for Business Leaders and Practitioners is a complete resource for technology and marketing executives looking to cut through the hype and produce real results that hit the bottom line. Providing an engaging, thorough overview of the current state of big data analytics and the growing trend toward high performance computing architectures, the book is a detail-driven look into how big data analytics can be leveraged to foster positive change and drive efficiency.

  • دانلود کتاب آموزشی Professional Microsoft SQL Server 2014 Integration Services از کمپانی Wrox

    The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage.

  • دانلود کتاب آموزشی OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062

    It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams.