| Main Title |
Microsoft Azure SQL Database step by step / |
| Author |
Lobel, Leonard,
|
| Other Authors |
|
| 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
|
| Holdings |
| Library |
Call Number |
Additional Info |
Location |
Last
Modified |
Checkout
Status |
| ELBM |
QA76.9.D32L63 2014 |
|
AWBERC Library/Cincinnati,OH |
05/04/2021 |
|
| Collation |
xxv, 370 pages : illustrations ; 23 cm. |
| Notes |
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. |
| Place Published |
Redmond, Washington |
| Title Ser Add Ent |
Step by step (Redmond, Wash.) |
| PUB Date Free Form |
2014 |
| Series Title Untraced |
Step by step |
| BIB Level |
m |
| Medium |
unmediated |
| Content |
text |
| Carrier |
volume |
| Cataloging Source |
RDA |
| LCCN |
2014940679 |
| Merged OCLC records |
844460893; 891555337 |
| OCLC Time Stamp |
20210423063650 |
| Language |
eng |
| Origin |
OCLC |
| Type |
CAT |
| OCLC Rec Leader |
08004cam 22005417i 45010 |
