Category Archives: SQL Server

What’s new in SQL Server 2017 presentation

I just uploaded a new presentation called “What’s new in SQL Server 2017”.  It covers all the new features in SQL Server 2017 (which went GA this past Monday), as well as details on upgrading and migrating to SQL Server … Continue reading

Posted in SQL Server, SQL Server 2017, SQLServerPedia Syndication | Leave a comment

Distributed Writes

In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out writes.  So what are your options when you have a tremendous amount of writes that scaling up will not handle, … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | 9 Comments

Microsoft database migration tools

There are various Microsoft tools that you can use to help you migrate your database (updated 8/9/17): Data Migration Assistant (DMA) – enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | 3 Comments

Microsoft Connect(); announcements

Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made.  Here is a summary of the data platform related announcements: Azure Data Lake Analytics is generally available in two datacenters in US (EMEA coming in Feb). … Continue reading

Posted in Data Lake, HDInsight, SQL Server, SQLServerPedia Syndication | Comments Off on Microsoft Connect(); announcements

PASS Summit Announcements: DMA/DEA

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  My next few blogs will cover the major announcements.  This first one is about the Data Migration Assistant (DMA) tool v 2.0 general availability and … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | Comments Off on PASS Summit Announcements: DMA/DEA

Data Warehouse Fast Track for SQL Server 2016

Microsoft Data Warehouse Fast Track for SQL Server 2016 is a joint effort between Microsoft and its hardware partners to deliver validated, pre-configured solutions that reduce the complexity of implementing a data warehouse on SQL Server Enterprise Edition.  The Data … Continue reading

Posted in Appliance, Data warehouse, Fast Track, PDW/APS, SQL Server, SQLServerPedia Syndication | 5 Comments

Migrate from on-prem SQL server to Azure VM IaaS

Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an Azure VM and are convinced to move your databases to the cloud.  If you are going to migrate to Azure … Continue reading

Posted in Azure, SQL Server, SQLServerPedia Syndication | 1 Comment

SQL Server on Linux!

Looks outside: pigs are flying! In an announcement yesterday, SQL Server will be made available on Linux.  The private preview of SQL Server on Linux is available now, and Microsoft is targeting availability in mid-2017.  Microsoft will offer both on-premises and cloud versions … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | 1 Comment

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database. In this migration process you migrate both your schema and your data from the SQL Server database in your current … Continue reading

Posted in Azure SQL Database, SQL Server, SQLServerPedia Syndication | 2 Comments

SQL Server 2016 public preview arriving this summer

SQL Server 2016 was recently announced.  Top new features include: Always Encrypted protects data at rest and in motion.  With Always Encrypted, SQL Server can perform operations on encrypted data and best of all, the encryption key resides with the … Continue reading

Posted in SQL Server, SQL Server 2016, SQLServerPedia Syndication | 1 Comment