CSV data format is an old format and very common for data tasks, like import, export or storing. And when it comes performance of creating CSV file, reading and writing CSV files, how does it still stand against some other formats. We will be looking at benchmarking the CRUD operations with different data formats; from… READ MORE
You can use Azure Database Migration Service to migrate the databases from an on-premises SQL Server instance to Azure SQL Database. In this example, we will move the SQL Server 2008 database on on-premises Windows Server 2008 R2 to Azure SQL. As seen in the image below, there is a database called “DCOInsurance” on SQL… READ MORE
You always think your environment is setup correctly and that you’re able to recover in case of a disaster. You make backups, test your backups, setup DR solutions and in the end test the DR plan (very important). But, is your SQL Server Backups usable? But have you ever considered a situation where all your… READ MORE
Since SQL Server 2012 SP1 you’ve been able to backup and restore SQL Server using Azure Blob storage. This can be useful to have offsite replicated backups or if you need to move data securely between sites, and now with Azure hosted SQL Server (of various stripes) it makes it easy to get data into… READ MORE
Before you can do anything with SharePoint 2019 you have to install SQL Server. You have a couple of options available as both SQL Server 2016 and 2017 can be used. I want to go with SQL Server 2017 (all the latest features right?). So in this post I will be demonstrating how to install… READ MORE
Just a very quick post with lots of pictures 🙂 SQL Server 2019 Big Data Clusters are still in private preview and I’m currently running with version CTP 2.1. However, I wanted to share some of the exciting new features we can expect from this latest big data tech in terms of tools, management and monitoring… READ MORE
This post I have targeted to the BI developers and system admins who are interested to configure and work with the SQL Server Analysis Services in Azure (Called Analysis Services in Azure) What is SQL Server Analysis Services? SQL Analysis Service is the PaaS instance of SQL Server Analysis Services. It’s an analytical data engine… READ MORE
Hi, I’m going to show you easily can export “any” SQL Server database from Microsoft Azure to an On-Premises platform. I don’t think this steps are valid for a SharePoint Infrastructure (as the Content as Configuration Databases are stored in SQL Server itself), but it’s always a nice to know. In the meantime we don’t know what the vNext of SharePoint Online is, so it’s always good to know an export procedure fromMicrosoft Azure!
