Lightnews — Scholar-powered news

Bob Pusateri

@bobp.bsky.social

540 followers 260 following 13K posts

Microsoft Certified Master. Senior Data Professional. International presenter, blogger, author, conference organizer. He/Him.

Posts Media Videos Starter Packs

Reposted by Bob Pusateri

Rie Merritt @justrie.bsky.social · 13d

Introducing the Azure SQL hub: A simpler, guided entry into #AzureSQL. Trying to decide what Azure service is the right fit for you? it's worth trying this out. Answer a few questions & you can do a side by side comparison, w/o leaving the portal.
techcommunity.microsoft.com/blog/azuresq...

Introducing the Azure SQL hub: A simpler, guided entry into Azure SQL | Microsoft Community Hub

Choosing the right Azure SQL service can be challenging. To make this easier, we built the Azure SQL hub, a new home for everything related to Azure SQL...

techcommunity.microsoft.com

Reposted by Bob Pusateri

EightKB @eightkb.online · Aug 21

We're not letting up, straight into demos in the 4th session of EightKB 2025!

The 4th session at EightKB, Sergey talking about "The Language of Databases: A Deep Dive into MySQL and PostgreSQL Wire Protocols"

Reposted by Bob Pusateri

EightKB @eightkb.online · Aug 21

Keeping the mind-meltiness going is our third session in flow!

EightKB 2025's third session on Transaction Log Internals by Vladimir Afanasev

Reposted by Bob Pusateri

EightKB @eightkb.online · Aug 21

And we're off with the second session at EightKB 2025!

The second session at EightKB 2025. Nader Sharara with Next-Gen High Availability with Contained Availability Groups

Reposted by Bob Pusateri

EightKB @eightkb.online · Aug 21

And we are off with the first session of this year's EightKB!

Erik's session on Fix your SQL database design with T-SQL static code analysis at EightKB 2025

Reposted by Bob Pusateri

EightKB @eightkb.online · Aug 21

It's one hour to go to this year's edition of EightKB!

All registered attendees should have the link to the conference now, if you don't...please do let us know in the #EightKB channel in the SQL community slack.

See you in an hour!

Bob Pusateri @bobp.bsky.social · Aug 11

Data Saturday Chicago 2026 call for speakers is now open! We'd love to have you present - submit your sessions!

sessionize.com/data-saturda...

Data Saturday Chicago 2026: Call for Speakers

Data Saturday Chicago is a community event for anyone interested in the Microsoft Data Platform. This event is for the data community, by the communit...

Bob Pusateri @bobp.bsky.social · Jul 8

Very excited to announce Data Saturday Chicago 2026 will be held on March 14, 2026!

bobpusateri.com/2025/07/data...

Data Saturday Chicago 2026!

Data community events in Chicago have returned!

bobpusateri.com

Bob Pusateri @bobp.bsky.social · May 16

Reading: Avoid #T-SQL anti-patterns with the free T-SQL analysis tool #AzureData #AzureSQL

Avoid T-SQL anti-patterns with the free T-SQL analysis tool - Azure SQL Devs’ Corner

T-SQL Analyzer is a free command line tool for identifying, and reporting the presence of anti-patterns in SQL Server T-SQL scripts.

devblogs.microsoft.com

Bob Pusateri @bobp.bsky.social · May 15

Reading: How to enable Auditing in Azure SQL Databases to Storage account and store logs in JSON format #AzureData #AzureSQL

How to enable Auditing in Azure SQL Databases to Storage account and store logs in JSON format | Microsoft Community Hub

In today's data-driven world, auditing is a crucial aspect of database management. It helps ensure compliance, security, and operational efficiency. Azure...

techcommunity.microsoft.com

Bob Pusateri @bobp.bsky.social · May 15

Smokers aged 75+ have on average 5.8 fewer teeth than their non-smoking counterparts. #BobFacts

Relationship between smoking and dental status in 35-, 50-, 65-, and 75-year-old individuals - PubMed

The aim of the present study was to examine the dental status and smoking habits in randomized samples of 35-, 50-, 65-, and 75-year-old subjects (n = 1093), recruited for a cross-sectional epidemiolo...

pubmed.ncbi.nlm.nih.gov

Bob Pusateri @bobp.bsky.social · May 14

Reading: One year of Phi: Small language models making big leaps in #AI

One year of Phi: Small language models making big leaps in AI | Microsoft Azure Blog

Microsoft continues to add to the conversation by unveiling its newest models, Phi-4-reasoning, Phi-4-reasoning-plus, and Phi-4-mini-reasoning. Learn more.

azure.microsoft.com

Bob Pusateri @bobp.bsky.social · May 13

Reading: Efficiently and Elegantly Modeling Embeddings in #Azure #SQL and SQL Server #AzureData #AzureSQL #SQLServer

Efficiently and Elegantly Modeling Embeddings in Azure SQL and SQL Server - Azure SQL Devs’ Corner

Master best practices for azure SQL Server embeddings vectors to streamline your database operations and improve efficiency.

devblogs.microsoft.com

Bob Pusateri @bobp.bsky.social · May 13

Approximately 1 in 8 workers in the USA has been employed by McDonald's at some point. #BobFacts

Facts and ideas from anywhere

pmc.ncbi.nlm.nih.gov

Bob Pusateri @bobp.bsky.social · May 13

Wishing everyone a wonderful time at #SQLDay! I hope to join you all one of these years! #sqlfamily

Bob Pusateri @bobp.bsky.social · May 12

Reading: #Fabric Mirroring for #Azure #CosmosDB: Public Preview Refresh Now Live with New Features #AzureData

Fabric Mirroring for Azure Cosmos DB: Public Preview Refresh Now Live with New Features - Azure Cosmos DB Blog

Unlock the benefits of Microsoft Fabric's latest refresh, making Azure Cosmos DB data integration simpler and more secure.

devblogs.microsoft.com

Bob Pusateri @bobp.bsky.social · May 9

Reading: Predictable #LLM results with Structured Output and sp_invoke_external_rest_endpoint #AzureData #AzureSQL

Predictable LLM results with Structured Output and sp_invoke_external_rest_endpoint - Azure SQL Devs’ Corner

Transform your data handling with LLM structured output from Azure SQL and SQL Server using JSON Schema for precise responses.

devblogs.microsoft.com

Reposted by Bob Pusateri

Mike Golic Jr @mikegolicjr.bsky.social · May 8

the New Pope says he's from Chicago but he's *actually* from Naperville

Bob Pusateri @bobp.bsky.social · May 8

Reading: #Azure #CosmosDB Conf 2025 Recap: AI, Apps & Scale #AzureData

Azure Cosmos DB Conf 2025 Recap: AI, Apps & Scale - Azure Cosmos DB Blog

Discover how Azure Cosmos DB enables globally distributed applications at Azure Cosmos DB Conf 2025 with expert insights and demos.

devblogs.microsoft.com

Bob Pusateri @bobp.bsky.social · May 8

Brass and other copper-based alloys have an antimicrobial property known as the "oligodynamic effect." #BobFacts

Bob Pusateri @bobp.bsky.social · May 7

Reading: Recently released: Updates to the #SqlPackage and the #DacFx ecosystem #AzureData #AzureSQL #SQLServer

Recently released: Updates to the SqlPackage and the DacFx ecosystem | Microsoft Community Hub

The quarterly release cadence for SqlPackage and DacFx continues with the 170.0 release in mid-April 2025. Recent releases to SqlPackage and DacFx ecosystem...

techcommunity.microsoft.com

Bob Pusateri @bobp.bsky.social · May 6

Reading: #MSSQL Extension for #VSCode - Introducing Schema Compare (Preview) #AzureData #AzureSQL

MSSQL Extension for VS Code: Introducing Schema Compare (Preview) - Azure SQL Devs’ Corner

Explore the powerful schema compare feature in MSSQL for VS Code. Simplify database synchronization with clear visualizations.

devblogs.microsoft.com

Bob Pusateri @bobp.bsky.social · May 6

The Faroe Islands are one of the very few countries in Europe to have no McDonalds. There is, however, a Burger King. #BobFacts

20 things you didn't know about The Faroe Islands

Ahead of Northern Ireland's clash at Windsor Park tonight, Joanne Fleming uncovers interesting facts about the rivals.

www.belfasttelegraph.co.uk

Bob Pusateri @bobp.bsky.social · May 5

Reading: Using a Local Large Language Model (LLM): Interacting with Local LLMs Using #PowerShell #AI #LLM

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell - Anthony Nocentino's Blog

www.nocentino.com

Bob Pusateri @bobp.bsky.social · Apr 30

The land area of the Vatican City is 0.5km^2 (0.2 mi^2). Meaning it has a Popeulation density of 2 Popes per km^2, or 5 popes per mi^2. #BobFacts