Jax Data

1.2K posts

Jax Data banner
Jax Data

Jax Data

@jax_data

The official Twitter account for JaxData - (Formally Jacksonville SQL Server User Group, JSSUG)

Jacksonville, FL Katılım Mayıs 2010
175 Takip Edilen331 Takipçiler
Jax Data retweetledi
Jeff Taylor
Jeff Taylor@ReviewMyDB·
Fabric has CICD built in, but try a real schema change (drop a column, shorten one, remove a table with data), and the deployment fails. Fabric blocks it, and you're stuck. My new post shows a simple way to deploy databases in Fabric: SqlPackage and Azure DevOps. A build pipeline extracts the schema to a DACPAC, a release pipeline ships it through QA and Production, and you get the publish switches Fabric won't give you. The best part: it works the same for Fabric SQL and Azure SQL. Only the connection string changes. A QA deploy ran in about 3 minutes, wrapped in a transaction so it rolls back if anything breaks. Full walkthrough: jefftaylor.io/post/how-to-de… If you give it a try, let me know how it goes. #MicrosoftFabric #FabricSQL #AzureSQL #AzureDevOps #SQLPackage #DACPAC #DevOps #CICD #DataEngineering #SQLServer #DatabaseDeployment #Azure #PowerShell #TSQL #DBA #Redgate
Jeff Taylor tweet mediaJeff Taylor tweet mediaJeff Taylor tweet media
English
0
2
2
59
Jax Data retweetledi
Jeff Taylor
Jeff Taylor@ReviewMyDB·
I'm honored and looking forward to speaking at @dayofdata of Data Baton Rouge next weekend. SQL Database in Microsoft Fabric introduces an interesting approach for teams that need both transactional processing and analytics. Data is automatically mirrored into OneLake, providing a SQL analytics endpoint that can be queried without adding reporting overhead to the operational database. In my session, I'll walk through how Fabric SQL Database works, how it compares to Azure SQL Database, and where it makes sense within the Microsoft data platform. We'll cover: ✅ Automatic mirroring into OneLake for near real-time analytics ✅ SQL analytics endpoints ✅ Cross-database queries ✅ Development with familiar SQL tools ✅ Intelligent performance capabilities ✅ Live demos of database creation, connectivity, and analytics endpoints ✅ Tradeoffs and limitations compared to Azure SQL Database If you're attending, I hope you'll join me. 🎤 Fabric SQL Database: Simplifying OLTP and Real-Time Analytics 📅 July 18, 2026 🕝 2:35 PM – 3:35 PM 📍 BEC 1409 (Cloud) 🔗 dayofdata.org/2026-07-18-sql… #DayOfDataBR #MicrosoftFabric #FabricSQLDatabase #AzureSQL #SQLServer #PowerBI #OneLake #DataEngineering #DataPlatform #DataArchitecture #CloudData #Analytics #SQLCommunity #MicrosoftData
Jeff Taylor tweet media
English
0
3
3
103
Jax Data retweetledi
Jeff Taylor
Jeff Taylor@ReviewMyDB·
Happening now! Come join us! Open-source DocumentDB, vector search, and a live .NET RAG build — led by Santosh Hari, Microsoft Azure engineer and former Azure MVP. All at iR Garage in Jacksonville. Food's provided, doors at 5:45 PM. If you write C# or run SQL Server and you've been meaning to understand embeddings and semantic search, this is the one to show up for. See you there 👇 meetu.ps/e/Q8sqV/hr6DK/i #DotNet #CSharp #VectorSearch #VectorDatabase #PostgreSQL #DocumentDB #RAG #AI #MachineLearning #SoftwareDevelopment #Database #Azure #MongoDB #DeveloperCommunity #Jacksonville
Jeff Taylor tweet mediaJeff Taylor tweet media
English
0
2
4
80
Jax Data retweetledi
Jeff Taylor
Jeff Taylor@ReviewMyDB·
🚀 I just finished testing Microsoft's new Automatic Index Compaction feature in Azure SQL Database, Azure SQL Managed Instance, and Microsoft Fabric SQL Database. For years, DBAs have focused on fragmentation and scheduled index rebuilds, reorganizations, and maintenance windows. But with modern flash storage, page density is often the metric that matters most for I/O performance. In my test: ✅ Starting state • 99.5% page density • 962 pages • 25 logical reads ✅ After workload churn • 52.7% page density • 4,394 pages • 1,610 logical reads ✅ After Automatic Index Compaction • 96.1% page density • 1,065 pages • 35 logical reads That's roughly a 98% reduction in logical reads without running a rebuild, reorganize, or maintenance job. The most interesting part? I turned on the feature with a single line of T-SQL and simply waited while the engine compacted partially filled pages in the background. My full hands-on test, scripts, screenshots, and observations are here: 🔗 jefftaylor.io/post/automatic… Are nightly index maintenance jobs becoming less relevant in cloud-first SQL environments? I'd love to hear what others are seeing. #AzureSQL #SQLServer #MicrosoftFabric #DataPlatform #DBA #DatabaseAdministration #PerformanceTuning #AzureData #CloudDatabase #AzureSQLMI #IndexMaintenance #SQLCommunity
Jeff Taylor tweet mediaJeff Taylor tweet mediaJeff Taylor tweet media
English
0
1
2
33
Jax Data retweetledi
Jeff Taylor
Jeff Taylor@ReviewMyDB·
Happening right now! There is still plenty of time to join us, come on down after work if you can't make it earlier...! MS Build // localhost: Jacksonville is happening now at @IR_talent Interactive Resources - iR Garage. Looking forward to a great Build 2026 recap with the Jax community. 👉 meetup.com/jaxdug/events/… Come for the breakouts and hands-on labs! #MSBuild #Buildlocalhost #JaxDUG #JaxData #JaxTech @TheJaxDUG @jax_data @AndyLech42 Julian Radacz #MVPBuzz
Jeff Taylor tweet mediaJeff Taylor tweet media
English
0
2
2
68
Jax Data retweetledi
Jeff Taylor
Jeff Taylor@ReviewMyDB·
Day of Data Jacksonville 2026 Recap! 🎉 This was our first year under the Day of Data name, continuing the evolution from SQL Saturday into a broader event for the modern data community. The numbers: ✅ 534 registrations ✅ 371 attendees ✅ 48 speakers ✅ 49 volunteers ✅ 200+ submitted sessions ✅ 12 tracks Sessions covered SQL Server, Microsoft Fabric, Power BI, AI, APIs, analytics, data engineering, and modern data platforms. Huge thank you to our speakers, sponsors, volunteers, attendees, organizers, and the broader data community who helped make this event happen. Full recap: jefftaylor.io/post/day-of-da… #dayofdatajax #DayofData #DayOfDataJax #SQLSatJax #SQLSaturday #Data #Analytics #MicrosoftFabric #Fabric #PowerBI #SQLServer #AzureSQL #Azure #AI #DataEngineering #BusinessIntelligence #BI #DataCommunity #MVPBuzz #DevOps #Jacksonville @jax_data @dayofdata @swheelerSQL @ofortun
Jeff Taylor tweet mediaJeff Taylor tweet mediaJeff Taylor tweet media
English
0
3
3
70