SQL Server

Data SQL Server

How to Use Citus to Shard Postgres, for Performance & Scale | Data Exposed

If you’re looking to scale your Postgres database, the Citus open-source extension to Postgres makes sharding simple. And Citus is available on Azure as a managed service, too. Join Claire Giordano on the Citus team to learn about how Citus uses the Postgres extension APIs to shard Postgres—and the best way to get started with […]

Read More
SQL Server

Brent Ozar Answers Your Questions About SQL Server from Reykjavik Harbor

The one and only Brent Ozar answers your SQL Server questions about SQL Server from Reykjavik Harbor.

Read More
Linux SQL Server

SQL Server on Linux Storage Secrets

SQL Server object disks on Windows Server can be expanded at any time with no issues, but Linux doesn’t quite work like that by default. In a situation where you run out of space, you’re out of luck, unless you know some secrets about Linux. The mysterious Linux Logical Volume Manager must be used before […]

Read More
Data SQL Server

Understanding the Benefits of Intelligent Query Processing

In this episode of Data Exposed, Kate Smith will take you through the basics of why query processing matters, what it does, and how Intelligent Query Processing makes your workloads faster and more efficient. Resources: The Positive Impact of Intelligent Query Processing – Microsoft Tech Community Intelligent query processing in SQL databases

Read More
Azure SQL SQL Server

Storage 101 for Azure SQL and SQL Server Engineers

Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, go over the basics of I/O, what the different access patterns are for the database engine and how to tell when there is an issue with underlying storage for your database. Resources: Argenis’ blog on IO Block Size […]

Read More
SQL Server

Granular Permissions for Azure SQL Dynamic Data Masking

In this episode of Data Exposed with David Trigano and David Brookler, learn how you can leverage new capabilities in Dynamic Data Masking, help your organization prevent unauthorized access to sensitive data, and gain control by masking it to a non-privileged user at different levels of your database. 

Read More
Data SQL Server

Easy Ways to Refresh Tabular Models

In this episode with Gaston Cruz, he’ll show you the options to process Azure Analysis Services models (Semantic Layer) connecting to an Azure SQL DB as a data source (using SSDT), and then create an architecture using a Service Principal account to process the model (DB, Tables, Partitions) in an automatic way deploying an Azure […]

Read More
Azure SQL Server

How to Create Operational Analytics with Window Functions in Azure SQL – Part 3

Running complex aggregations and analytical functions on real-time operational databases is a powerful capability in Azure SQL. In the last part of this three-part series with Silvano Coriani, we will see how Window Functions can be a great tool to express analytical calculations on real-time data sets. More episodes in this Operational Analytics Series: How […]

Read More
Azure SQL SQL Server

A Tour of SQL Workshops

Join Anna Hoffman and Buck Woody as they take a tour of the incredible learning resource the Microsoft Engineering team has put together. From labs to full hands-on workshops and much more, you’ll find a wealth of high-quality, free-cost training. You’ll also learn about many of the other valuable references and assets you can find […]

Read More
SQL Server

Live Coding T-SQL in the First Responder Kit

The one and only Brent Ozar where he writes & tests T-SQL scripts in Microsoft SQL Server on a livestream. Github repo: http://FirstResponderKit.org  

Read More