Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Database
Tagged Content List

  • Wiki Page: Windows Azure SQL Reporting Samples

    Sample reports and a Windows Azure web role with a ReportViewer control that points to the sample reports, is available for download for Windows Azure SQL Reporting. In this article: Download samples Prerequisites Sample Data for Reports Report Samples SQL Reporting application samples...
    on10 Mar 2013

  • Wiki Page: Windows Azure SQL Database Billing Numbers Directly From Transact-SQL

    Windows Azure SQL Database exposes two Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage that show you the activity for your account. These can queried to understand your account usage from a billing perspective. Table of Contents Disclaimer Database Usage Summary Disclaimer...
    on7 Mar 2013

  • Wiki Page: Tutorial: Creating and Deploying a WCF Sync Service to Windows Azure

    The walkthroughs in this tutorial provide steps to create a sync service by using Windows Azure Tools for Microsoft Visual Studio (see the Windows Azure MSDN site ) and deploy the service to Windows Azure. This section contains the following sub-sections. Section Description ...
    on21 Feb 2013

  • Wiki Page: Windows Azure SQL Reporting Release Notes

    For known issues related to Windows Azure SQL Reporting, see Known Issues (Windows Azure SQL Reporting) . See Also Troubleshooting Windows Azure SQL Reporting Windows Azure SQL Reporting Overview Windows Azure SQL Database Resources
    on15 Feb 2013

  • Wiki Page: Versioning Windows Azure SQL Database Schemas by Using Federations

    Table of Contents Sample Scenarios Scenario: Adding New Features to a Multi-Tenant Application Application Layer Changes Implementation Steps Scenario: Single Tenant Application Layer Changes Implementation Steps Traditionally database schema upgrades have been an “all or nothing” affair. A production...
    on15 Feb 2013

  • Wiki Page: Windows Azure SQL Database: Glossary of Terms

    client layer: The layer that resides closest to your application, and that your application uses to communicate directly with Windows Azure SQL Database. The client layer can reside on-premises in your data center, or it can be hosted in Windows Azure. infrastructure layer: The layer that represents...
    on15 Feb 2013

  • Wiki Page: Windows Azure SQL Database SQL Authentication

    Windows Azure SQL Database supports only SQL Server authentication. Windows authentication (integrated security) is not supported. You must provide credentials every time when you connect to SQL Database. The SQL Database provisioning process gives you a SQL Database server, a master database...
    on14 Feb 2013

  • Wiki Page: Windows Azure SQL Database Connection Encryption

    Regardless of the client library chosen, data is transferred using tabular data stream (TDS) over a secure sockets layer (SSL). Windows Azure SQL Database doesn’t support unencrypted connections. This will ensure data transmission is secure and can help prevent man-in-the-middle attacks. The handshake...
    on14 Feb 2013

  • Wiki Page: How to Create a Windows Azure SQL Database Server

    Table of Contents Introduction To create a SQL Database Server See Also Introduction This article walks you the steps for creating a Windows Azure SQL Database Server using Windows Azure Platform Management Portal. Before you can create a SQL Database server, you must create and activate your Windows...
    on7 Feb 2013

  • Wiki Page: Sync Framework: SQL Server to Windows Azure SQL Database Synchronization

    In this article I will show how to use the 2.1 version of the Sync Framework to write a console application to synchronize Windows Azure SQL Database with on-premises SQL Servers. The Sync Framework takes care of all the messy details for you, leaving you just tying the pieces together in very few lines...
    on7 Feb 2013

  • Wiki Page: Move Access Data to the Cloud

    Microsoft SQL Server Migration Assistant for Access allows you to move your Microsoft Access tables and queries to Windows Azure SQL Database. This article will walk through how to use the tool to move the NorthWind database to SQL Database. Table of Contents Using the Migration Wizard Summary...
    on6 Feb 2013

  • Wiki Page: Overview of Security in Windows Azure SQL Database

    Windows Azure SQL Database has two types of access control: SQL Authentication and a server-side firewall that restricts access by IP address. Along with access control SQL Database always maintains a secure connection to your database via SQL Server’s protocol encryption. Transparent Data Encryption...
    on5 Feb 2013

  • Wiki Page: Windows Azure SQL Database Connection Security

    Summary This article provides information on the security fundamentals and best practices when working with Windows Azure SQL Database. This article is primarily concerned with writing secure connection strings for SQL Database. Author: Selcin Turkarslan Reviewers: Evan Basalik, Larry Franks...
    on5 Feb 2013

  • Wiki Page: Gaining Performance Insight into Windows Azure SQL Database

    Understanding query performance in Windows Azure SQL Database can be accomplished by utilizing SQL Server Management Studio or the SET STATISTICS Transact-SQL commands. Since SQL Server Profiler isn’t currently supported with SQL Database, this article will discuss some alternatives the provide...
    on1 Feb 2013

  • Wiki Page: SQL Server and SQL Database Resource Center for PASS Summit 2012

    If you attended the Professional Association for SQL Server (PASS) Summit this year, you saw the Resource Center. It had lots of information about SQL Server, SQL Database, and their communities. The links to all that info are in this article. Please enjoy the info, share an e-book of your own to...
    on12 Nov 2012

  • Wiki Page: SQL Server and SQL Database Resource Center for PASS Summit 2012 Survey Privacy Statement

    SQL Server and SQL Database Resource Center for PASS Summit 2012 Survey Privacy Statement (last updated: November 02, 2012 ) Microsoft is committed to protecting your privacy. Survey responses are collected by Instant.ly , a market research company commissioned by Microsoft to conduct this...
    on2 Nov 2012

  • Wiki Page: Current Options for Backing up Data with Windows Azure SQL Database

    Backups are performed for a number of reasons including: security against hardware failure and protection against user error. Windows Azure SQL Database provides good options for handling both these scenarios. This white paper will cover the current backup operations for SQL Database. For the latest...
    on18 Sep 2012

  • Wiki Page: Windows Azure SQL Database Backup and Restore Strategy

    Windows Azure SQL Database requires its own backup and restore strategy because of the environment and tools available. In many ways the risks have been mediated by the database being in the Microsoft data centers. The tools that we have today cover the other risk factors, however better tools are coming...
    on18 Sep 2012

  • Wiki Page: Windows Azure SQL Reporting FAQ

    Windows Azure SQL Reporting is a cloud-based reporting service you add to your existing Windows Azure subscription. This article contains FAQs for SQL Reporting. In this article: Scenarios Comparison Getting Started Connectivity and Security Managing Report Servers Looking...
    on3 Jul 2012

  • Wiki Page: Windows Azure SQL Reporting Overview

    This page contains resources and information that will help you learn more about Windows Azure SQL Reporting. If you are already familiar with SQL Reporting and are looking for product documentation, news and events, or a list of additional resources, please visit the following sites: SQL Reporting...
    on3 Jul 2012

  • Wiki Page: Sync Framework - SQL Database to SQL Database Synchronization

    I have blogged in the past about SQL Database to SQL Database synchronization using Data Sync Service for SQL Database ( Introduction to Data Sync Service for Windows Azure SQL Database ). However what if Data Sync Service doesn’t do exactly what you want? It stands to reason that the Service will...
    on3 Jul 2012

  • Wiki Page: SQL Data Sync - Supported Windows Azure SQL Database Data Types

    Each column, local variable, parameter, and expression has a data type. The data type specifies the kind of data that the column, variable, parameter, or expression can contain. The data type informs the system how to interpret bit patterns. SQL Data Sync supports a subset of Windows Azure SQL Database...
    on2 Jul 2012

  • Wiki Page: SQL Data Sync - Glossary of Terms

    This topic defines terms you need to know and understand when working with SQL Data Sync. Important! This wiki topic may be obsolete. This wiki topic is no longer updated by Microsoft. We moved the content to the MSDN Library where we keep it current...
    on2 Jul 2012

  • Wiki Page: SQL Data Sync - Backing Up Your Data

    While it is possible to use SQL Data Sync to create a backup of your data it is not recommended. SQL Data Sync Does not version synchronizations. Therefore, you cannot backup and restore to a specific point in time. Does not backup other SQL objects, like stored procedures. Does not "restore"...
    on2 Jul 2012

  • Wiki Page: SQL Data Sync Scenario: SQL Server-to-SQL Database Synchronization

    SQL Data Sync Preview introduces a completely new UI. The new UI is designed to be task oriented and thus make you more efficient. With the new UI this article is replaced by SQL Data Sync Create a Sync Group which walks you through the steps to create a sync group of any supported topology. ...
    on2 Jul 2012
Page 2 of 3 (56 items) 123
Can't find it? Write it!

Post an Article