paas

Migrating an on premise SQL Server Database to Azure

• by Arun Sirpal

• SQLServerCentral.com

• SQL Server

• Article

For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.5 (12)

Log in or register to rate

You rated this post out of 5. Change rating

2016-04-21

1,571 reads

• Discuss

Introduction to SQL Server in Microsoft Azure

• by Additional Articles

• Database Journal

• Azure

• Article

The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features. These limitations can be eliminated by taking advantage of the Microsoft Azure IaaS capabilities and installing a SQL Server instance in an Azure-hosted VM.

2014-06-23

5,979 reads

Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues

• by Additional Articles

• Database Journal

• Windows Azure SQL Database

• Article

In this series on implementing data services in Azure, Marcin Policht turns his attention to the remediation of incompatibilities resulting from of limitations inherent to Platform as a Service (PaaS) based deployments, which will need to be addressed as part of the migration process.

2013-11-21

3,052 reads

Windows Azure from a Data Perspective

• by Additional Articles

• SimpleTalk

• Azure

• Article

Before creating a data application in Windows Azure, it is important to make choices based on the type of data you have, as well as the security and the business requirements. There are a wide range of options, because Windows Azure has intrinsic data storage, completely separate from SQL Azure, that is highly available and replicated. Your data requirements are likely to dictate the type of data storage options you choose.

2012-05-22

2,650 reads

RE: Slow performance on large inserts

• by Douglas-De-Ivey

• SQLServerCentral.com

• Reply

Yes,  SQL Profiler is the right tool to use next. The easiest way to use is start with the default options and add bits and pieces to it until you get the effect that you want.  Then set run the trace for a while.  If you get a lot of data or you want to keep it, […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-10-06

RE: Not an OLAP Admin on my own machine?

• by Alex Marsh

• SQLServerCentral.com

• Reply

Had the same problem. Reinstalling service pack 3a fixed the issue.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-10-05

EXEC SP from SP

• by pkrieg

• Database Journal

• Topic

Help.  I am calling this EXEC from inside a SP. See Below.My problem is this.  When I script out my SPs and reload it is giving me an error that it can't find GetPatientHL7Data.  I am sure because the SPs that it is erroring on are loading before GetPatientHL7Data.If this is the problem, I prefer […]

2004-04-20

2 reads

RE: Passing stored procedure param to UDF for a parameterized view

• by camlern

• Database Journal

• Reply

This is the script I am using to run the function: -- This just runs forever DECLARE @dtDateEnd datetime SELECT @dtDateEnd = '03/05/04' SELECT * FROM [dbo].[fnCMStatsMTD_Summary](@dtDateEnd) --- This work fine SELECT * FROM [dbo].[fnCMStatsMTD_Summary]('03/05/04')--If I hard code the date in the procedure it runs fine (50sec)ALTER PROCEDURE usp_CMStats_MTDTest @dtDateEnd datetime ASSELECT  fnAdmissionsMTD_CR_CM.Agency,  fnAdmissionsMTD_CR_CM.Team_Number, fnAdmissionsMTD_CR_CM.Case_Number, […]

2004-03-05

RE: How to backup database onto network shared drives

• by jxflagg

• SimpleTalk

• Reply

quote: Also any network "drives" you have need to be mapped permanently WHILE YOU ARE LOGGED in as the MSSQLSERVER account. Not using your account. Or you can use xp_cmdshell to map the drive as a step in your backup job.

2003-12-22