Scott Klein

Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement SQL in Azure • Manage databases and instances • Manage storage This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning

Collect and analyze sensor and usage data from Internet of Things applications with Microsoft Azure IoT Suite. Internet connectivity to everyday devices such as light bulbs, thermostats, and even voice-command devices such as Google Home and Amazon.com's Alexa is exploding. These connected devices and their respective applications generate large amounts of data that can be mined to enhance user-friendliness and make predictions about what a user might be likely to do next. Microsoft's Azure IoT Suite is a cloud-based platform that is ideal for collecting data from connected devices. You'll learn in this book about data acquisition and analysis, including real-time analysis. Real-world examples are provided to teach you to detect anomalous patterns in your data that might lead to business advantage. We live in a time when the amount of data being generated and stored is growing at an exponential rate. Understanding and getting real-time insight into these data is critical to business. IoT Solutions in Microsoft's Azure IoT Suite walks you through a complete, end-to-end journey of how to collect and store data from Internet-connected devices. You'll learn to analyze the data and to apply your results to solving real-world problems. Your customers will benefit from the increasingly capable and reliable applications that you'll be able to deploy to them. You and your business will benefit from the gains in insight and knowledge that can be applied to delight your customers and increase the value from their business. What You'll LearnGo through data generation, collection, and storage from sensors and devices, both relational and non-relationalUnderstand, from end to end, Microsoft’s analytic services and where they fit into the analytical ecosystemLook at the Internet of your things and find ways to discover and draw on the insights your data can provideUnderstand Microsoft's IoT technologies and services, and stitch them together for business insight and advantageWho This Book Is ForDevelopers and architects who plan on delivering IoT solutions, data scientists who want to understand how to get better insights into their data, and anyone needing or wanting to do real-time analysis of data from the Internet of Things

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft’s worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime.SQL Azure is ideally suited for startups, who can benefit from instant access to a robust and secure web-accessible database platform for use in rapidly deploying new products to market. SQL Azure is also ideal for small and mid-sized businesses, giving them the same ability to deploy SQL Server as any large enterprise, but without the management overhead. Even large enterprises find SQL Azure useful in creating failover environments, development environments, extra capacity to handle surges in demand, and more.Pro SQL Database for Windows Azure covers the very latest in Microsoft’s fast-moving, cloud platform, showing how to program and administer it in a variety of cloud computing scenarios. You’ll learn to program SQL Azure from ASP.NET, from WinForms, and from SQL Reporting Services. You’ll learn to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. You’ll learn the unique aspects of SQL Azure such as sharding and federation support that combine to place SQL Azure a step above and ahead of the competiton.Shows how to use SQL Azure from classic Windows applications, ASP.NET and Windows Communication FoundationCovers management, performance, scalability, and troubleshootingAddresses the all-important issue of securing your dataHelps you properly design for high-performance in a cloud environmentHelps you adopt the new Federations feature in SQL Azure

SQL Azure represents Microsoft’s cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name "Oslo"). Pro SQL Azure introduces you to this new platform, showing you how to program and administer it in a variety of cloud computing scenarios. You’ll learn to program SQL Azure from Silverlight, ASP.NET, WinForms, and from SQL Reporting Services. You’ll also understand how to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. Shows how to use SQL Azure from Silverlight, ASP.NET, and more Covers management, scalability, and troubleshooting Addresses the all-important issue of securing your data

Previously, SQL developers have been able to almost entirely ignore the SQLCLR and treat it as a peripheral technology—almost an extension to the main product. With the advent of LINQ and the Entity Framework, this is no longer the case, and the SQLCLR is moving to the center stage. It’s a powerful product but, for many, it is an entirely new way of working with data. Pro Entity Framework 4.0 will help readers understand the implications of the Entity Framework and how it can be used to change their development practices and make their databases more powerful and flexible. Since many readers will be encountering this subject for the first time, the book will create an inclusive environment in which the concepts of .NET development are approached from the perspective of the Relational T–SQL developer to foster a sense of shared–ownership in keeping with Microsoft’s latest best practices. Comprehensive coverage of the new greater and more challenging integration with .NET 3.5 Written from a real–world perspective and examines the features offered by LINQ and the Entity Framework that will help solve problems experienced by professional developers Contains insight, interpretation, analysis, and evangelism instead of just plain fact

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation