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.

Yesterday I installed VSCodium on Debian Linux. But I couldn't get the mssql (SQL Server) extension to work.

Tonight I installed VSCode on Debian Linux. The mssql extension works just fine.

Why doesn't it work on VSCodium? IDK.

#Linux
#Debian
#SQLServer

You can apply for:
SQL Server 2025 preview
Copilot in SSMS 21 preview

Details
#Microsoft #SQLServer #Copilot #SSMS #msftadvocate

Once again my coworker and partner in crime appears to have come up with creative and not-Microsoft-sanctioned solution to a #SQLServer problem. It looks like it works better than MSFT's method.

The cumulative updates since CU11 or so trip a lengthy database consistency check that, with hundreds of databases per server, takes hours. MSFT's answer was to detach the dbs, update, and reattach. His solution was to stop the services, update, rename the data folder, and restart the services.

#SQLServer #OnPrem incremental #CopyJob to #MicrosoftFabric #Lakehouse This is huge!
#FabConEurope

I hate hate hate fucking SSIS.

So fucking much.

I am looking into options for migrating a MariaDB to SQL Sever. I can see that Microsoft SQL Server Migration Assistant (SSMA) for MySQL could be an option but as per the docs it does not support MariaDB. Anyone with any success with the same or other options for easy migration? p.s. Fairly new to this area so pardon the novice Q's #mariadb #sqlserver

#SQLServer CX_PACKET waits explained.

I'm feeling pretty good right now. We had an ultra-successful test run of failing all of our #SQLServer instances from the LAX LZ to the OR AZ in AWS. TBH, I just want to be done with all of this because next week we're having a cool onsite, and after that, there's lots of cool work to be done.

I guess my #PowerShell scripts for our #SQLServer migration might be something of a hit. We'll see how they fare with 50-ish failover clusters here in a bit, but the tests with 10 or so were smooth as silk twice earlier today. I know this doesn't sound complicated — it's just failovers amirite? — but there are stumbling blocks that have to be accounted for including network latency, SIOS mirroring, Windows pending reboots, AD, DNS...y'know all of the usual wrenches getting thrown in the gears.

New Coding Short: ".NET Aspire: Databases" is now available. I show you how Aspire can centralize configuration and manage database containers: #aspire #dotnet #sqlserver

https://youtu.be/_e6XJQOVgHs

Is there some tool that would allow me to "Describe" a database say with a config file (JSON, YML) and it create the scripts to both create or update an existing DB to match the latest scheme?

Thinking similar to say ruby on rails style ORM but to be a standalone tool for maintaining DBs used by various apps? I do need it to work with MS SQL Server

A refreshed #Introduction

Work for a #NonProfit leading a small team focused on #SQLServer, #DotNet, #CraftCMS, #ReactJS and now #Salesforce.

Love learning and posting about the #Fediverse - the people involved, the apps created.

I tinker with my #MastodonStarterKit, #HomeLab projects, and brush up on coding skills when I can.

Grew up closeted #LGBTQIA in the 80s rural south.
Married
#GenX, #Introvert, #Music lover.
Over-involved #DogDad.
#Kindness in all things.

I feel dirty AF.

#SQLServer
#TSQL
#SMO
#PowerShell
#DOS
#XML

https://github.com/BeginTry/SQL-Server-Administration/blob/master/TSQL%2C%20PoSh%2C%20SMO%2C%20DOS%20-%20Get%20CREATE%20TABLE%20DDL.sql

To the old IT folks here: I used to visit Oracle customers & give them this "Million Dollar Mug", promotional swag for SQL Server 7.0.

It endeared me to quite a few DBA groups cuz even back then Oracle was famous for auditing & threatening customers with legal action.

These days, we have better alternatives like OCI bridging w/ Azure allowing Oracle customers to continue to use Oracle apps & databases. Or there's other options like moving to Azure Postgres DB.
#sqlserver #Microsoft #oracle

Looking for a new gig, laid off from Disney after 25 years. My areas of expertise include #java and #postgres, as well as the Microsoft stack (#SQLServer). I have vast domain knowledge in the field of movie distribution. #OpenToWork #HireDisney

Easily translate your #SQLServer skills and experience to #AzureSQL—using familiar tools and techniques. Insiders walk you through configuring, monitoring & troubleshooting database security, performance & availability in this #Azure SQL video series.

Module 1: Introduction to Azure SQL (1 - 11)
Module 2: Deploy & Configure (12 - 20)
Module 3: Security (21 - 33)
Module 4: Performance (34 - 44)
Module 5: Availability (45 - 56)
Module 6: Putting It All Together (57 - 61)

https://m.youtube.com/playlist?list=PLlrxD0HtieHi5c9-i_Dnxw9vxBY-TqaeN&WT.mc_id=azuresql4beg_azuresql-ch9-niner