Med-Mastodon

8 posts6 participants0 posts today

Data BenePostgreSQL, we've generally heard, is "good enough" for most intents and purposes. We'd love to know what YOU think. What's stopped you from using <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> in the past, and what solution did you choose instead? When have you opted for <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Postgres</a> where it turned out better than expected? 👂 💬 <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#tech</a> <a href="https://fosstodon.org/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://fosstodon.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#rdbms</a> <a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgres</a> <a href="https://fosstodon.org/tags/developers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#developers</a> <a href="https://fosstodon.org/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devcommunity</a> <a href="https://fosstodon.org/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dba</a> <a href="https://fosstodon.org/tags/developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#developer</a> <a href="https://fosstodon.org/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dev</a> <a href="https://fosstodon.org/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#programming</a> <a href="https://fosstodon.org/tags/coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#coding</a> <a href="https://fosstodon.org/tags/hacking" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#hacking</a> <a href="https://fosstodon.org/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#foss</a> <a href="https://fosstodon.org/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#oss</a> <a href="https://fosstodon.org/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#opensource</a> <a href="https://fosstodon.org/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://fosstodon.org/tags/cockroachdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cockroachdb</a> <a href="https://fosstodon.org/tags/snowflake" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#snowflake</a> <a href="https://fosstodon.org/tags/bigdata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#bigdata</a>

SQLAllFatherBerlin.October 10th.Data Moshpit is returning.<a href="https://techhub.social/tags/PowerBI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PowerBI</a> <a href="https://techhub.social/tags/MicrosoftFabric" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MicrosoftFabric</a> <a href="https://techhub.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://techhub.social/tags/DataCommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataCommunity</a> <a href="https://techhub.social/tags/SQLFamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLFamily</a> <a href="https://techhub.social/tags/Metal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Metal</a> <a href="https://www.data-moshpit.de/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.data-moshpit.de/</a>

Dave MasonI made some significant changes to STORED PROCEDURE dbo.GetTableAssessment 🔹 A couple of bug fixes. 🔹Added OPTION(RECOMPILE) to the dynamic sql statements so they don't flood the procedure cache. 🔹Added checks for data types FLOAT/REAL. 🔹Added checks for unused columns (not just the "string" data type columns). 🔹Added check for columns with only 1 distinct value across all rows. 🔹Added a single-row result set, which contains the assessment report.<a href="https://codeberg.org/DaveMasonDotMe/SQL-Server-Administration/src/branch/master/Stored%20Procedures/dbo.GetTableAssessment.sql" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://codeberg.org/DaveMasonDotMe/SQL-Server-Administration/src/branch/master/Stored%20Procedures/dbo.GetTableAssessment.sql</a><a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a>

Dave MasonNEW POST: ✍ Remove IDENTITY Property From a Column🔎 A (mostly) simple option that doesn't require any I/O...or the need for a large maintenance window.👤 Dave Mason<a href="https://www.davemason.me/2025/05/03/remove-identity-property-from-a-column" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://www.davemason.me/2025/05/03/remove-identity-property-from-a-column</a><a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a>

Dave MasonSigh. My SQL Servers often feel like NoSQL data dumpsters.<a href="https://mastodon.social/tags/RDBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RDBMS</a> <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a>

Alvin Ashcraft 🐿️Announcing the Release of SSMS 21 Preview 7.<a href="https://techcommunity.microsoft.com/blog/sqlserver/announcing-the-release-of-ssms-21-preview-7/4410222" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://techcommunity.microsoft.com/blog/sqlserver/announcing-the-release-of-ssms-21-preview-7/4410222</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/ssms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ssms</a> <a href="https://hachyderm.io/tags/azuresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#azuresql</a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a>

Alvin Ashcraft 🐿️Dew Drop Weekly Newsletter #430 - Week ending May 2, 2025.<a href="https://zc.vg/aySzo?m=0" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://zc.vg/aySzo?m=0</a> <a href="https://hachyderm.io/tags/dewdrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a href="https://hachyderm.io/tags/newsletter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a href="https://hachyderm.io/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://hachyderm.io/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://hachyderm.io/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#azure</a> <a href="https://hachyderm.io/tags/dotnetmaui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnetmaui</a> <a href="https://hachyderm.io/tags/aspnetcore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#aspnetcore</a> <a href="https://hachyderm.io/tags/m365" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://hachyderm.io/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://hachyderm.io/tags/podcasts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://hachyderm.io/tags/mobiledev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mobiledev</a> <a href="https://hachyderm.io/tags/windowsdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windowsdev</a>

Dave MasonThis looks really useful: sp_IndexCleanupIt's a stored procedure from Erik Darling that analyzes SQL Server indexes. It checks for things like unused indexes, uncompressed indexes, overlapping indexes, duplicated/nearly duplicated indexes, etc. And if I understood the video, if generates 'cleanup' scripts. Cool!<a href="https://erikdarling.com/introducing-sp_indexcleanup/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://erikdarling.com/introducing-sp_indexcleanup/</a><a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Database</a>

Alvin Ashcraft 🐿️Dew Drop Weekly Newsletter #429 - Two weeks ending April 25, 2025.<a href="https://zc.vg/uj2dt?m=0" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://zc.vg/uj2dt?m=0</a><a href="https://hachyderm.io/tags/dewdrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a href="https://hachyderm.io/tags/newsletter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a href="https://hachyderm.io/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://hachyderm.io/tags/csharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a href="https://hachyderm.io/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://hachyderm.io/tags/aspnetcore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#aspnetcore</a> <a href="https://hachyderm.io/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://hachyderm.io/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#azure</a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://hachyderm.io/tags/agile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a href="https://hachyderm.io/tags/podcasts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://hachyderm.io/tags/m365" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a>

Dave MasonA couple of nice database victories today. Two large tables each had one column storing DATETIME data and another column storing UNIQUEIDENTIFIER (aka GUID) data. Both columns were incorrectly using data type VARCHAR.Changing to the appropriate types dropped table sizes from 10.62GB to 4.91GB and from 8.56GB to 6.44GB.<a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mastodon.social/tags/Databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Databases</a>

Brendan HaywardI've been slowly chipping away at my site querydiff.com I got annoyed at <a href="https://fosstodon.org/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> management studio and made a website instead. You can now load an example pair of <a href="https://fosstodon.org/tags/query" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#query</a> plans to compare them. See what the site does if you don't have a query plan in a nice xml file ready to go. 1/2

MikeMaking some progress here getting Windows 2000 and SQL Server 200 onto AppleTalk and eventually GlobalTalk thanks to jrouter. This is new and exciting networking activity. <a href="https://mas.to/tags/Windows2000" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Windows2000</a> <a href="https://mas.to/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mas.to/tags/AppleTalk" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AppleTalk</a> <a href="https://mas.to/tags/GlobalTalk" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GlobalTalk</a> <a href="https://mas.to/tags/Apple" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Apple</a>

Alvin Ashcraft 🐿️Azure & DevOps Podcast Episode 345 - .NET Aspire and Databases with Jerry Nixon and host Jeffrey Palermo.<a href="http://feed.azuredevops.show/net-aspire-and-databases-with-jerry-nixon-episode-345" rel="nofollow noopener noreferrer" translate="no" target="_blank">http://feed.azuredevops.show/net-aspire-and-databases-with-jerry-nixon-episode-345</a> <a href="https://hachyderm.io/tags/podcast" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcast</a> <a href="https://hachyderm.io/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devcommunity</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://hachyderm.io/tags/aspire" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#aspire</a> <a href="https://hachyderm.io/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://hachyderm.io/tags/dotnetaspire" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnetaspire</a> <a href="https://hachyderm.io/tags/cloudnative" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cloudnative</a>

Dave MasonHeadline: All Eyes on the Wrong Problem: How Mitigations Distract from Real Performance PainMe: It's damn near impossible to hold any positive thoughts about Microsoft.<a href="https://kendralittle.com/2025/04/06/acclimating-users-bad-makes-miss-truly-terrible/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://kendralittle.com/2025/04/06/acclimating-users-bad-makes-miss-truly-terrible/</a><a href="https://mastodon.social/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Microsoft</a> <a href="https://mastodon.social/tags/Azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Azure</a> <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a>

Alvin Ashcraft 🐿️Dew Drop Weekly Newsletter #428 - Week ending April 11, 2025.<a href="https://zc.vg/yissD?m=0" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://zc.vg/yissD?m=0</a><a href="https://hachyderm.io/tags/dewdrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a href="https://hachyderm.io/tags/newsletter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a href="https://hachyderm.io/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://hachyderm.io/tags/aspnetcore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#aspnetcore</a> <a href="https://hachyderm.io/tags/windev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windev</a> <a href="https://hachyderm.io/tags/xaml" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#xaml</a> <a href="https://hachyderm.io/tags/csharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a href="https://hachyderm.io/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://hachyderm.io/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://hachyderm.io/tags/agile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a href="https://hachyderm.io/tags/podcasts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://hachyderm.io/tags/mobiledev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mobiledev</a> <a href="https://hachyderm.io/tags/m365" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/windows" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windows</a>

Ænðr E. FeldstrawYo, <a href="https://mastodon.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> tuners and optimizers, I have a question: under what circumstances would a <a href="https://mastodon.social/tags/queryplan" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#queryplan</a> prefer a scan of a clustered index rather than a seek of a non-clustered index with the same predicate and output fields? I've been pouring over query plans lately, trying to reduce pressure of processes in an environment that sees thousands of processes running, with hundreds at the same time, contending for data access, CPU time, and file locks.

MikeI'm installing SQL Server 2000 and I noticed an interesting option: it supports AppleTalk. Do I need to be setting up a GlobalTalk router and adding SQL Server 2000 to the mix? It's so enterprise.<a href="https://mas.to/tags/Windows2000" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Windows2000</a> <a href="https://mas.to/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a> <a href="https://mas.to/tags/GlobalTalk" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#GlobalTalk</a>

Alvin Ashcraft 🐿️Dew Drop Weekly Newsletter #427 - Week ending April 4, 2025.<a href="https://zc.vg/fcOgF?m=0" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://zc.vg/fcOgF?m=0</a><a href="https://hachyderm.io/tags/dewdrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a href="https://hachyderm.io/tags/newsletter" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a href="https://hachyderm.io/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://hachyderm.io/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#azure</a> <a href="https://hachyderm.io/tags/cloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#cloud</a> <a href="https://hachyderm.io/tags/windowsdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windowsdev</a> <a href="https://hachyderm.io/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://hachyderm.io/tags/csharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a href="https://hachyderm.io/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://hachyderm.io/tags/agile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a href="https://hachyderm.io/tags/copilot" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#copilot</a> <a href="https://hachyderm.io/tags/mobiledev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mobiledev</a> <a href="https://hachyderm.io/tags/dotnetmaui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnetmaui</a> <a href="https://hachyderm.io/tags/podcasts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://hachyderm.io/tags/m365" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/windows" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windows</a>

mbourgonHey <a href="https://dataplatform.social/tags/sqlfamily" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlfamily</a> , curious how everybody is doing Ci/CD. I want to do it. I’ve checked in everything in prod into GitHub. I have access to GitHub Actions. But what do people do to get from dev to prod? If I change a table and add a permission, what scripts out the changes from my dev DB? Looks like Sqlpackage and Flyway? If I can’t have the database look like prod (because of extra audit triggers, etc), how should I handle that? Is there a Recommended Best Practice somewhere? <a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a>

Alvin Ashcraft 🐿️Dew Drop Weekly Newsletter #426 - Week ending March 28, 2025.<a href="https://zc.vg/vwFe8?m=0" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://zc.vg/vwFe8?m=0</a> <a href="https://hachyderm.io/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://hachyderm.io/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://hachyderm.io/tags/csharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a href="https://hachyderm.io/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://hachyderm.io/tags/dotnetmaui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dotnetmaui</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/podcasts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://hachyderm.io/tags/windev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#windev</a> <a href="https://hachyderm.io/tags/xaml" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#xaml</a> <a href="https://hachyderm.io/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://hachyderm.io/tags/IoT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#IoT</a> <a href="https://hachyderm.io/tags/agile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a href="https://hachyderm.io/tags/m365" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#m365</a>

Recent searches

Search options

Administered by:

Server stats:

#sqlserver