By Ginger Daniel | Azure , Cloud , SQL Administration , SQL Server
In Part 1 of this series, we demonstrated how to copy a full SQL database table from a SQL Server database into an Azure Blob Storage account as a csv file. My client needed data moved from their on premise SQL Server database to Azure, and then needed the daily incremental data changes uploaded as […]
Continue readingBy Ginger Daniel | Azure , Cloud , SQL Administration , SQL Development , SQL Server
One of many options for Reporting and Power BI is to use Azure Blob Storage to access source data. Most of the documentation available online demonstrates moving data from SQL Server to an Azure Database, however my client needed data to land in Azure Blob Storage as a csv file, and needed incremental changes to […]
Continue readingBy Ginger Daniel | Cloud , SQL Administration , SQL Server , Stretch Database
Microsoft has added another cool feature in SQL Server 2016 – Stretch databases – that provides a cost effective way to store historical or ‘cold’ data. This feature is ideal for transactional databases with large amounts of cold data, typically stored in a small number of tables. Stretching is better than the traditional method […]
Continue readingBy Lisa Dominy | Advice , Cloud , Partners , SQL Server , SQLRX
Whether you currently host your SQL Server in the Cloud or are considering moving it to the cloud, here are a few guidelines that can lead you to select the right hosting provider for your specific requirements. Set the stage for a tech discussion. Familiarize yourself with your current technology profile so you can have […]
Continue reading