Login

Recent searches

No recent searches

Search options

Only available when logged in.
social.coop is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Fediverse instance for people interested in cooperative and collective projects. If you are interested in joining our community, please apply at https://join.social.coop/registration-form.html.

Administered by:

Server stats:

487
active users

social.coop: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.4

#sqlserver

9 posts4 participants1 post today
Public
mbourgon

Hey #sqlfamily , 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? #sqlserver

Public
zartom

Reverse Substrings in SQL Server: Four Efficient Methods
Master Reverse SQL Substrings in SQL Server! Learn efficient methods to reverse substring order, transforming "apple-banana-cherry" into "cherry-banana-apple". Explore modern techniques using STRING_SPLIT & STRING_AGG for optimal performance. #SQLServer #stringmanipulation #ReverseSubstring #SQLtips #programming #database
tech-champion.com/database/sql
...

TECH CHAMPION · Reverse Substrings in SQL Server: Four Efficient MethodsReverse the order of substrings within a SQL Server string using four efficient methods: CTEs JSON UDFs or STRING_SPLIT/STRING_AGG. Reverse SQL Substrings easily.
Public
zartom

Conditional SQL Inserts: How to Add Rows Based on Status
Master Conditional SQL Inserts for robust database management & data integrity! Learn various techniques, from IF EXISTS to MERGE statements & stored procedures. #SQLinserts #DatabaseManagement #DataIntegrity #SQLServer #ConditionalLogic #Programming

Learn how to perform conditional SQL inserts to add new rows only if a specific condition is met such as checking the shipment status before insertion. Conditional SQL Inserts are expla...

Public
Dave Mason

This is probably a long shot, but I'll ask anyway: do any MS SQL Server folks use Machine Learning services?

And more specifically, does the "SQL Server Launchpad" service ever unexpectedly stop?

The "Recovery" configuration for SQL Server-related services (pictured) is usually good enough to ensure they don't have to be restarted manually.

But not in this case for the Launchpad service.

#SQLServer
#SQLHelp

The Properties dialogue for a Windows NT service. There are four tabs--the "Recovery" table is selected.
Public
Dave Mason

Headline: AI will eliminate DBA Jobs faster than you think.

Me: I don't use ChatGPT, Copilot, Gemini, or any other chat bots. In fact, I don't consciously choose to use any "AI" tools. So it's hard for me to comment on the predictions in this article. (Cont'd)

kendralittle.com/2025/03/02/ai

#DBA
#SQL
#SQLServer
#AI

KendraLittle.com · AI will eliminate DBA Jobs faster than you thinkKendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.
ExploreLive feeds
About