sql server

I wrote a blog post inspired by Stephen Vakil's excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data?

My thoughts:
* When you don't actually need a database
* When you're not using structured data
* When you want pure analytics, or something other than a workload involving OLTP
* When you need to write to multiple nodes for a single database
* When your team wants a PAAS solution (lil pedantic on this, the hosted versions are slightly different)
* When your team needs a cheap solution

What do you think?

This podcast is available in blog post form: https://littlekendra.com/2023/06/21/when-not-to-choose-sql-server/

Improve hybrid workloads with updates to SQL Server 2022, now generally available. Link local SQL Servers to Azure SQL Managed Instances for bidirectional disaster recovery, achieve massive speedups with differential snapshot-based backup and restore, as well as anywhere management of your SQL Servers with Azure Arc-enabled SQL provisioning, and new pay-as-you-go licensing. For raw performance, we'll demonstrate intelligent Degree of Parallelism feedback where SQL optimizes the thread count of queries automatically.

Bob Ward, Principal Architect for Microsoft SQL Server, joins Jeremy Chapman to share improvements to query performance, Azure integration, and costs for both licensing and compute, local or in the cloud.

► QUICK LINKS:

00:00 - Introduction

01:01 - Backup and disaster recovery

02:31 - Failover between SQL Server and Managed Instance

05:24 - Snapshot backups

07:57 - Restore a snapshot backup

08:59 - SQL Server management: Pay-as-you-go

10:40 - SQL Server performance: Query optimizations

13:21 - Wrap up

► Link References:

Start a free version of SQL Server 2022 at https://aka.ms/getsqlserver2022

Check out our free online workshop at https://aka.ms/sql2022workshop

► Unfamiliar with Microsoft Mechanics?

As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.

• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries

• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog

• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast

► Keep getting this insider knowledge, join us on social:

• Follow us on Twitter: https://twitter.com/MSFTMechanics

• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/

• Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics 

Build, test, and deploy scalable apps quickly with Azure SQL updates for developers. Check out platform enhancements for modern, cloud-based apps:

-Create apps locally with Azure SQL Database emulator
-Initiate serverless operations with SQL trigger in Azure Functions
-Build simple and secure API connections to data with Data API Builder, coming soon

Principal Architect from the SQL engineering team at Microsoft, Bob Ward, joins Jeremy Chapman to share recent updates for the developer experience.

► QUICK LINKS:

00:00 - Introduction

01:41 - Highlights of solutions for developers

03:13 - Built-in query intelligence

05:56 - Azure SQL Database emulator

07:44 - SQL trigger in Azure Functions

10:44 - Data API Builder

12:32 - Wrap up

► Link References:

Get published code for assigning work orders based on geolocation at https://aka.ms/sqlgeocodesample

► Unfamiliar with Microsoft Mechanics?
As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.

• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1

• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog

• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/website

• To get the newest tech for IT in your inbox, subscribe to our newsletter: https://www.getrevue.co/profile/msftmechanics

► Keep getting this insider knowledge, join us on social:

• Follow us on Twitter: https://twitter.com/MSFTMechanics

• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/

• Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics

 

Build highly scalable applications using the distributed Postgres relational database in Azure Cosmos DB for PostgreSQL. See how it works with current Postgres tools, how to scale out with distributed tables and nodes to keep apps responsive, and how to eliminate latency with geo-replication capabilities for globally distributed apps.

Cosmos DB has a variety of APIs, including native NoSQL and compatible APIs, targeted at NoSQL workloads. With the introduction of Postgres, Cosmos DB offers relational capabilities— a key cornerstone for application developers.

With distributed Postgres in Cosmos DB, you can build highly scalable, cloud native apps using NoSQL and relational capabilities within a single managed service. Principal Group Program Manager, Charles Feddersen, from the Cosmos DB team joins Jeremy Chapman to walk you through the process.

Join the Azure Cosmos DB team for all our announcements from Ignite 2022. Visit https://aka.ms/azurecosmosdbliftoff

► QUICK LINKS:
00:00 - Introduction
00:51 - Relational capabilities and scalability
01:46 - See it in action
02:48 - Connect code to cluster
05:20 - Scaling your application
07:49 - SaaS application example
11:05 - Geo-replication
13:21 - Wrap up

► Link References:

Get started at https://aka.ms/trycosmosdb

► Unfamiliar with Microsoft Mechanics? As Microsoft's official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.

• Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1

• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog

• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/website

• To get the newest tech for IT in your inbox, subscribe to our newsletter: https://www.getrevue.co/profile/msftmechanics

► Keep getting this insider knowledge, join us on social:

• Follow us on Twitter: https://twitter.com/MSFTMechanics

• Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

• Enjoy us on Instagram: https://www.instagram.com/msftmechanics/

• Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics

Nikola is a data and BI professional with experience from very large data projects. He is a vibrant part of the Power BI Community and just a wonderful human beeing.