Uploading On-Premise data to Azure Blob Storage using SSIS

Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.

How to Back Up SQL Server to Azure Blob Storage

When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds.

Data Files on Azure

SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration

RE: Need to append a character onto end of data in a column

Okay - to cover every realm of possibility : UPDATE TableName SET SupplyName = LTRIM(RTRIM(SupplyName)) + '@' WHERE RIGHT(SupplyName,1) '@' AND LEN(SupplyName) < 32 Now, is there anything else we forgot about this simple update query?

RE: SQL Performance Q''''s

whoa, nice catch there Nicholas.

RE: Moving DTS packages from box to box

HiI plan to have the production SQL DB and the development SQL DB. The idea is to make any new development on the development machine and once tested and approved move it to the production SQL DB. Although the structure and all DTS will be identical (that is before changing something on the development SQL) the […]

RE: How to Handle "Wide" Tables?...

Assuming that (i) the average length of the data within the two wide fields are relatively large (ie occupying most of the 4000 varchar field and is a common occurrence for that table), and (ii) there are many records, then it would be wise to create a separate table for the two columns and join back to […]