(Side note: Excited to share that the audio version of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” is now accessible for those who prefer this format. The audio reader … Continue reading →
The big announcement at the PASS Data Community Summit 2022 was that SQL Server 2022 is now generally available. See the official announcement. My top 10 list of new features are: Integration with Azure SQL Database Managed Instance — the Microsoft-managed, cloud-based … Continue reading →
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and AI related announcements: SQL Server 2022: A new version of SQL … Continue reading →
There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use cases for syncing databases are to distribute reads (i.e. a second … Continue reading →
Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs): How … Continue reading →
If you are using SQL Server in an Azure VM (IaaS) you have a number of options of where to store the database files (.mdf, .ldf, and .ndf). Most customers use managed disks, available in a number of offerings: Standard HDD, Standard … Continue reading →
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 →
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 →
There are various Microsoft tools that you can use to help you migrate your database (updated 1/16/19): Data Migration Assistant (DMA) – enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality … Continue reading →
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 →
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 →
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 →
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 →
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 →
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 →
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 →
All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free. Check the session schedule for a complete list. Also, many of the PASS virtual chapters have recordings of their meetings online. Enjoy!
Continue reading →On February 5, 2014 business intelligence experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to deliver a series of one-hour webcasts, digging deep into the world of business analytics. All session recordings and slide presentations … Continue reading →
Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free! Some great videos on the latest products and versions. Check them out here. There are four videos on SQL Server 2014: Microsoft SQL Server … Continue reading →
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a great way to learn all about SQL Server 2012 and Business Intelligence (some sessions have hands-on labs). Check them out here. … Continue reading →