Azure

You were asked by your manager to investigate the new functionality released with SQL Server 2016 this past June. How can you accomplish this task without installing the new software onto a development machine?

Learn about three useful features in Azure-SQL for growing environments including scaling SQL Azure, restoring from SQL Azure to SQL Server and alerting.

I have a SQL Server instance installed on an Azure Virtual Machine (VM) and I want to access this instance using SQL Server Management Studio (SSMS) on my local desktop. Read this tip for the steps on how to setup.

This tip will demonstrate how to secure SQL Server in Azure using a real, deployed virtual machine by configuring the endpoint ports and Access Control Lists (ACLs) on each endpoint.

Learn about the options for SQL Azure Geo Replication as well as the steps to complete the configuration and testing.

Learn how to configure and customize SQL Azure Dynamic Data Masking for common data such as credit cards, social security numbers, etc. and custom fields.

Learn how to Troubleshoot SQL Azure Bacpac Import Failures including Data plan execution failed with message One or more errors occurred and An error occurred during deployment plan generation. Deployment cannot continue.

This tip includes PowerShell scripts and examples to help you automate Azure file uploads and file deletes as well as options to enhance the scripts.

We have moved some of our SQL Server databases to Azure and we want to do periodic checks to make sure the databases are responsive. We want to setup a scheduled heartbeat check against the Azure databases. Check out this tip to learn more.

Microsoft released the preview version of Azure SQL Database V12 in December of 2014. The main purpose of this version is to narrow the syntactical differences between the on-premises and in-cloud database engines. The hope is that more companies will mig

Microsoft release the preview version of Azure SQL Database V12 in December of 2014. The main purpose of this version is to narrow the syntactical differences between the on-premise and in-cloud database engines. In this tip we look at how to easily trans

Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. In this tip we show you how.

Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. How do I get started? In this tip we cover several PowerShel

SQL Data Sync is a feature of Windows Azure SQL Database which synchronizes data across multiple SQL Server and Windows Azure SQL Database instances without writing any code. In this tip we show how to setup a synchronization of two databases one on Azure

Windows Azure SQL Database has a feature called SQL Data Sync which synchronizes data across multiple SQL Server and Windows Azure SQL Database instances. In this tip we cover how it works and what consideration to take when using it.

Learn how to deploy a database to SQL Azure using the wizard in SSMS.

I’ve introduced my manager to SQL Server’s cloud based platform, SQL Azure and Windows Azure Virtual Machine. He wants to test functionality with some of our applications, which would require me to move my on premise databases to the Azure Virtual Machine

With SQL Azure, your server and databases are hosted in the cloud and you use SQL Server Management Studio (SSMS) to connect to your SQL Azure database. Do you really need to install the SQL Server client tools to be able to connect to SQL Azure database?

As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you

SQL Azure provides relational database capability in the cloud. One of the features that is missing is a way to move databases up or down from your in-house SQL server. So how do you move a database schema and data up to the cloud? In this tip I will w

We know that SQL Azure is the database offering on the Windows Azure cloud computing platform, and it goes without saying that all the technologies that plug-in to databases need to start exercising and adapting to this flavor of databases along with the

SQL Azure and cloud computing brings a new paradigm of database development and implementation strategy. SSIS is one of the technologies that would be used to move data in and out of SQL Azure in any Microsoft Business Intelligence (BI) solution built on

If you were unhappy with the capabilities of SQL Server Management Studio (SSMS) while working with SQL Azure, then there is good news Microsoft has announced the November CTP for Microsoft SQL Server 2008 R2. The SSMS of this version allows you to work w

There has been lots of buzz about cloud computing lately and looking at the benefits it provides (in terms of cost savings, high availability, scalability (scale up/down) etc.) it is now evident that cloud computing is the future for next generation appli