Record Display for the EPA National Library Catalog


Main Title Microsoft Azure SQL Database step by step /
Author Lobel, Leonard,
Other Authors
Author Title of a Work
Boyd, Eric,
Publisher Microsoft Press, a division of Microsoft Corporation,
Year Published 2014
OCLC Number 862759081
ISBN 9780735679429; 0735679428; 0133989364; 9780133989366; 0133989372; 9780133989373; 0133989380; 9780133989380
Subjects Online databases ; Cloud computing
Library Call Number Additional Info Location Last
ELBM  QA76.9.D32L63 2014 AWBERC Library/Cincinnati,OH 05/04/2021
Collation xxv, 370 pages : illustrations ; 23 cm.
Includes index.
Contents Notes
Machine generated contents note: ch. 1 Getting started with Microsoft Azure SQL Database -- Cloud computing: The concept -- Instant dynamic provisioning -- The Microsoft Azure cloud -- Getting signed up for SQL Database -- Creating a Microsoft account -- Creating a Microsoft Azure subscription -- Creating a server -- Creating a SQL Database instance -- Using the SQL Database management portal -- Designing tables and relationships -- Inserting data -- Querying the database -- Exploring additional portal capabilities -- Summary -- ch. 2 Configuration and pricing -- Using the Microsoft Azure platform management portal -- Creating a new database -- Setting firewall rules -- Obtaining connection strings -- Deleting a database -- Using SQL Server Management Studio -- Connecting to SQL Database -- Creating a new database -- Changing the database edition and maximum size -- Deleting a database -- Using PowerShell -- Installing the Microsoft Azure PowerShell cmdlets -- Using the PowerShell Integrated Scripting Environment -- Configuring PowerShell for your Microsoft account -- Creating a new server -- Creating a new database -- Deleting a database -- Budgeting for SQL Database -- SQL-storage -- Client bandwidth -- Backup storage space -- Backup storage bandwidth -- Support -- Optimizing your costs -- Configuring the database edition and size -- Summary -- ch. 3 Differences between SQL Server and Microsoft Azure SQL Database -- Size limitations -- Connection limitations -- Unsupported features -- Summary -- ch. 4 Migrating databases -- Making the case for data migration -- Migrating data using Transact-SQL scripts -- Setting up a local SQL Server database -- Creating the T-SQL scripts -- Generating T-SQL scripts -- SQL Data-Tier Applications -- Creating a Microsoft Azure Storage account -- Exporting a BACPAC to Microsoft Azure Storage -- Importing a BACPAC to Microsoft Azure SQL Database -- SQL Server Bulk Copy (bcp) -- Migrating Schema -- Exporting data -- Importing data -- SQL Database Migration Wizard -- Downloading the tool -- Migrating a database -- Summary -- ch. 5 Security and backup -- Addressing major cloud concerns -- Security responsibilities of the public cloud vendor -- Shared security responsibilities -- Security in Microsoft Azure -- Securing SQL Database -- Creating a SQL Database -- Configuring SQL Database Firewall -- Authenticating and authorizing users -- Backing up SQL Database -- Copying a database -- Monitoring the progress of a database copy operation -- Exporting a BACPAC -- Importing a BACPAC -- Scheduling BACPAC exports -- Summary -- ch. 6 Cloud reporting -- Creating a SQL Server Reporting services virtual machine -- Creating the virtual machine from the image gallery -- Configuring SSRS in the virtual machine -- Opening firewall access to the report server -- Creating the sample database -- Using Report Builder -- Installing Report Builder -- Creating a report using Report Builder -- Using Visual Studio Report Server projects -- Installing AdventureWorks2012 for SQL Database -- Installing SSDT Business Intelligence for Visual Studio 2012 -- Creating a report using Visual Studio -- Implementing report security -- Shutting down the SSRS virtual machine -- Summary -- ch. 7 Microsoft-Azure SQL Data Sync -- Getting to know SQL Data Sync -- Exporting data from SQL Server to SQL Database -- Importing data from SQL Database to SQL Server -- Sharing data between multiple locations -- Scaling out -- Creating the SQL Database -- Working with SQL Data Sync -- Creating a sync group -- Creating sync rules -- Running a manual sync -- Establishing conflict resolution -- Creating an automated sync schedule -- Creating a local SQL Server database -- Creating a sync agent -- Pitfalls and best practices -- Summary -- ch. 8 Designing and tuning for scalability and high performance -- Achieving high performance in the cloud -- Creating a RESTful web API -- Creating the sample database -- Creating a new solution -- Creating an ASP.NET Web API project -- Adding an Entity Framework Code First Web API controller -- Testing the Wine Web API -- Adding an ADO.NET Web API controller -- Testing the Customer Web API -- Managing SQL Database connections -- Opening late, closing early -- Pooling connections -- Recovering from connection faults -- Adding the Transient Fault Handling Application Block -- Using the Transient Fault Handling Application Block with ADO.NET -- Using the Transient Fault Handling Application Block with Entity Framework -- Reducing network latency -- Keeping services close -- Minimizing round trips -- Effectively using SQL Database -- Using the best storage service -- Optimizing queries -- Scaling up SQL Database -- Partitioning data -- Scaling out with functional partitions -- Scaling out with shards -- Summary -- ch. 9 Monitoring and management -- Creating the sample database -- Monitoring -- Using the management portal -- Microsoft Azure Service Dashboard -- SQL Database management portal -- Dynamic management views and functions -- Programming the Service Management REST API -- Summary -- ch. 10 Building cloud solutions -- Creating the SQL Database -- Extending the SQL Database -- Creating a new solution -- Creating a SQL Server Database project -- Setting the target platform -- Importing from SQL Database into the project -- Adding a new column to the Wine table -- Deploying the project to Microsoft Azure SQL Database -- Creating the Order table -- Creating stored procedures for the Order table -- Creating the data access layer -- Introducing the Entity Data Model -- Creating the Data Access Layer project -- Creating an Entity Data Model -- Creating the website -- Creating an ASP.NET web application project -- Referencing the data access layer -- Creating the user interface -- Testing the website locally -- Deploying the website to Microsoft Azure -- Creating the ASP.NET Web API services -- Adding a Web API controller -- Testing the Web API -- Deploying the Web API -- Creating the Windows Phone application -- Installing the Windows Phone SDK 8.0 -- Creating the Windows Phone Project -- Adding Json.NET -- Creating the App's main page -- Testing the Windows Phone application.