Krzysztof Dmowski @xaphanpl

**Urs Enzler** @UrsEnzler@tooting.ch · 1d

Have you ever restored a SQL Server bacpac file and wished that indices were disabled for a faster restore?
I have a script that does exactly this: https://www.planetgeek.ch/2025/05/14/disabling-indices-in-a-bacpac-file-sql-server/

planetgeek.ch · 1dDisabling Indices in a -bacpac file (Sql Server)We store most of our application's data in an SQL server database. Sometimes, we need to transfer the data locally to debug defects related to production data. The database grows daily, and restoring the database locally takes more and more time. So we had the idea to disable indices because they are not needed for...

#SqlServer #FSharp #Script

**Data Bene** @data_bene@fosstodon.org · May 6

May 6

Data Bene @data_bene@fosstodon.org

PostgreSQL, 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 #PostgreSQL in the past, and what solution did you choose instead? When have you opted for #Postgres where it turned out better than expected?

#tech #data #sql

**Dave Mason** @DaveMasonDotMe@mastodon.social · May 3 *

May 3 *

Dave Mason @DaveMasonDotMe@mastodon.social

NEW 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

https://www.davemason.me/2025/05/03/remove-identity-property-from-a-column

#SQLServer
#Database

It's All Just ElectronsRemove IDENTITY Property From a ColumnA (mostly) simple option that doesn't require any I/O...or the need for a large maintenance window.

**Upscene Productions** @upscene@mstdn.business · Apr 28

Apr 28

Upscene Productions @upscene@mstdn.business

ANN: Database Workbench 6.7.0 released

- ability to view vector embeddings in PostgreSQL
- quick CSV import/export
- faster foreign key creation
- bugfixes in PostgreSQL, Firebird, InterBase and SQLite modules

https://www.upscene.com/news/item/20250425

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Screenshot of Database Workbench displaying vector embeddings in PostgreSQL

**Mike** @mroach@mas.to · Apr 16

Apr 16

Mike @mroach@mas.to

Making 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.

Screenshot of Windows 2000 joined-up to an AppleTalk zone and SQL Server's network utility configured for AppleTalk.

#Windows2000 #SQLServer #AppleTalk

**Ænðr E. Feldstraw** @aeveltstra@mastodon.social · Apr 9

Apr 9

Ænðr E. Feldstraw @aeveltstra@mastodon.social

Yo, #sqlserver tuners and optimizers, I have a question: under what circumstances would a #queryplan 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.

**Mike** @mroach@mas.to · Apr 9 *

Apr 9 *

Mike @mroach@mas.to

I'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.

Screenshot of the SQL Server 2000 installer with the option to enable "AppleTalk ADSP"

#Windows2000 #SQLServer #GlobalTalk

**Upscene Productions** @upscene@mstdn.business · Apr 2

Apr 2

Upscene Productions @upscene@mstdn.business

Video: Adding a foreign key constraint to an existing #SQLite table using Database Workbench.

https://www.youtube.com/watch?v=ZnFf4sj8jro

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

YouTubeDatabase Workbench - Add foreign key constraint to existing SQLite tableBy Upscene

**mbourgon** @mbourgon@dataplatform.social · Apr 1

Apr 1

mbourgon @mbourgon@dataplatform.social

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

**Upscene Productions** @upscene@mstdn.business · Apr 1

Apr 1

Upscene Productions @upscene@mstdn.business

Video: Convert a #MySQL database to #PosgreSQL using Database Workbench.

https://youtu.be/L4nOo26CIdU

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

youtu.be- YouTubeEnjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

**zartom** @zartom@mastodon.social · Mar 29

Mar 29

zartom @zartom@mastodon.social

SQL Server String Aggregation: SQL Server 2016 vs. 2017
Master SQL Server String Aggregation across versions (2016+). Learn dynamic SQL, best practices, & secure techniques to prevent SQL injection. #SQLServer #DynamicSQL #StringAggregation #Database #SQLInjection #Programming
https://tech-champion.com/general/sql-server-string-aggregation-sql-server-2016-vs-2017/
...

**zartom** @zartom@mastodon.social · Mar 29

Mar 29

zartom @zartom@mastodon.social

SQL JSON Conversion: Efficiently Converting SQL Query Results to JSON
Master SQL JSON conversion for efficient database development! Learn techniques for transforming SQL query results into JSON, improving code readability & security. #SQLJSONConversion #JSONData #DatabaseDevelopment #SQLServer #DataTransformation #Programming
https://tech-champion.com/database/sql-server/sql-json-conversion-efficiently-converting-sql-query-results-to-json/
...

**zartom** @zartom@mastodon.social · Mar 29

Mar 29

zartom @zartom@mastodon.social

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
https://tech-champion.com/database/sql-server/reverse-substrings-in-sql-server-four-efficient-methods/
...

**zartom** @zartom@mastodon.social · Mar 29

Mar 29

zartom @zartom@mastodon.social

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
https://tech-champion.com/database/sql-server/conditional-sql-inserts-how-to-add-rows-based-on-status/
...

TECH CHAMPION · Feb 25Conditional SQL Inserts: How to Add Rows Based on StatusMaster conditional SQL inserts! Learn to add rows based on status checks avoiding unwanted entries. Efficiently manage your database with conditional SQL inserts.

**zartom** @zartom@mastodon.social · Mar 29

Mar 29

zartom @zartom@mastodon.social

**zartom** @zartom@mastodon.social · Mar 29

Mar 29

zartom @zartom@mastodon.social

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...