Tag: SQL Server

Migrate SQL Server Database to an Azure SQL Database
Migrate SQL Server Database to an Azure SQL Database
Blog Posts

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

Use Azure to Store SQL Server Backups Offsit
Use Azure to Store SQL Server Backups Offsit
Blog Posts

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 have you ever considered a situation where all your data is unusable? If you get infected… READ MORE

Interacting with SQL Server 2019 Big Data Clusters
Interacting with SQL Server 2019 Big Data Clusters
Blog Posts

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

Exporting an Azure Database to On-Premises SQL Server
Exporting an Azure Database to On-Premises SQL Server
Blog Posts

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!

SQL Server 2012 File Tables feature and the Benefit With SharePoint
SQL Server 2012 File Tables feature and the Benefit With SharePoint
Blog Posts

SQL Server 2012 comes with an amazing new feature called “File Tables”.That means that you can use a file system folder as a database table with all the fun and of cause nearly all the function of a database table. You have to enable the prerequisites for FileTable (as described here:) and the result is a new table in your database with the following properties: