Marcin Policht

Deployment of cloud-based technologies introduces a wide range of challenges; however few of them are subjected to the same degree of scrutiny, concern, and public debate as security. In order to properly analyze security related challenges, it is important to note that they encompass several distinct but interrelated concepts, such as data integrity and confidentiality, […]

In our most recent article published on this forum, we have presented a procedure for uploading content of an arbitrarily chosen table from an on-premise SQL Server database to an Azure PaaS-based SQL Database. We have accomplished this by implementing a custom SQL Server Integration Services-based project (created by using SQL Server Data Tools – […]

In our most recent article published on this forum, we have presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance that leveraged BACPAC formatted files, while operating under the assumption that our on-premise data store is already cloud-compliant. Now we will describe an alternative method of […]

So far, we have been operating under the assumption that our existing schema and data are not fully compatible with the requirements imposed by the Azure Software as a Service (SaaS) platform. We have described methods that can be used to identify and remediate such incompatibilities and illustrated how they can be applied to a […]

In our articles published on this forum, we have been discussing challenges associated with deployments of data services in Windows Azure, focusing in particular on SQL Database. As we have pointed out, a transition from existing, on-premise SQL Server installations is likely to necessitate changes to their structure and content, primarily due to limitations inherent […]

In our recent articles published on this forum, we have been discussing the process of implementing data services in Windows Azure, focusing in particular on SQL Database (formerly referred to as SQL Azure Database). While creating new databases in such scenarios is straightforward, migration of existing ones tends to be a non-trivial undertaking. This is […]

In our most recent article published on this forum, we have presented general support options for data-oriented services in Windows Azure, focusing in particular on SQL Database (formerly referred to as SQL Azure Database). We also have described the process of setting up a new cloud-based SQL Server instance, connecting to it via SQL Server […]

Throughout our coverage of SQL Server 2012 Integration Services published on this forum, we have been dealing mainly with the traditional data management model, where the entire SQL Server environment resides on-premise. This once predominant paradigm is obviously changing, with hosted solutions (in the form of both private and public clouds) becoming increasingly common. In […]

In our recent articles published on this forum, we have been discussing different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format. While in a majority of cases the process we have described works as […]

In our most recent article published on this forum, we presented a PowerShell script that allows you to execute SQL Server 2012 Integration Services packages deployed by using the traditional Package Deployment Model. The approach we have described can be applied to packages stored in any of the formats available in such a scenario – […]

SQL Server 2012 Integration Services introduces an innovative approach to deploying SSIS projects, known as Project Deployment Model. This is the currently recommended (and the default) deployment technique, due to a number of benefits it delivers (such as the ability to centralize management of package properties across all deployed projects, as well as to monitor […]

In the recent articles published on this forum, we have been discussing how to leverage the capabilities of PowerShell to automate the most common SQL Server Integration Services administrative task, focusing in particular on the project deployment model introduced in SQL Server 2012. We started with sample scripts, illustrating the process of loading the required […]