Dear Santa,

I wish for a IT remote job, so I can stop ruining my body as a laborer.

Thx a million

Yours Derek

Merry christmas to you all

#merrychristmas #santaclaus #remotejob #itjobs #msaccess #linux #vbnet #tsql #lowcode #noai

🐘 #tsql — A Modern #PostgreSQL Manager #TUI Built in #Rust #opensource #database #cli #devops

🖥️ Full-screen split-pane interface with query editor and scrollable results grid
⌨️ Vim-style keybindings for modal navigation and editing with customizable config
🎨 Syntax highlighting for #SQL and #JSON powered by tree-sitter
🧠 Schema-aware smart autocomplete for tables, columns, and keywords
✏️ Inline cell editing directly in results grid with automatic SQL generation

🧵 👇

How To: XML-config для хранимых процедур MS SQL — создание, разбор, развёртывание

Всем привет! Меня зовут Александр Гаврилов, я архитектор баз данных и аналитических систем в GRI. Если вы когда-нибудь пытались выполнить одну и ту же операцию с похожими таблицами в разных базах, да ещё и на разных серверах, то знаете, насколько это может быть мучительно. В этой статье я покажу один из рабочих вариантов, как упростить такую задачу, и заодно расскажу про интересную функцию XQuery, которая может неожиданно помочь.

https://habr.com/ru/companies/gri/articles/975938/

#mssql #tsql #xml #запросы #XQuery #PowerShell #HowTo #deploy

BobSQL

Based on tsqlparser, tgpiler, and dxp

https://github.com/ha1tch/tgpiler

https://github.com/ha1tch/tsqlparser

https://github.com/ha1tch/dxp

All the pieces are there, so why not?

#tsql #bobsql #database #db #foss #golang #sql #microsoft #mssql #mssqlserver #sqlite #postgres

Tgpiler is a transpiler based on Tsqlparser

Tgpiler is a T-SQL transpiler that targets the Go programming language.
https://github.com/ha1tch/tgpiler

That means: you write T-SQL stored procedures, Tgpiler transpiles them to Go. Which means that with a little more luck and some astute tweaking, your old logic now scales horizontally for free.

Tgpiler is a transpiler powered by tsqlparser that parses T-SQL stored procedures, interprets T-SQL DML and compiles to Go source code with two execution paths: static and dynamic. The dynamic pathway is a genuine T-SQL runtime that executes most dynamic T-SQL code as part of your Go microservice. Newer versions also support a dual backend: DML or gRPC. The DML backend targets Postgres, Mysql, SQLite, and MSSqlServer. The gRPC backend is based on gRPC protos and using voting heuristics it maps stored procedure code to gRPC execution.

Once the vision is fully realised, it will become not a compiler, not a transpiler, not a migration tool with Go as its target, but a different category of tool for which we don't have a name yet:

Its main use is the migration of vertically scalable business logic to horizontally scalable business logic.

It's licenced under the GPL 3.0 and if you have any cool ideas about what should be done about it, feel free to call me:
h@ual.fi

#golang #tgpiler #tsql #foss #tsqlparser #db #database #mssqlserver #mssql #microsoft #sql #sqlite #postgres

OH BTW

https://github.com/ha1tch/bobsql

#golang #foss #bobsql #db #database #microsoft #tsql #mssql #mssqlserver

This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).

And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi

https://github.com/ha1tch/tsqlparser

#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres

T-SQL Mastery: Variables, IF/ELSE & CASE in 15 Mins! @JangiTech #sqlserver #tsql #foryou #database

A clear walkthrough of how to declare variables, assign values, print output, and use IF, CASE and WHILE logic in SQL Server. source

https://quadexcel.com/wp/t-sql-mastery-variables-if-else-case-in-15-mins-jangitech-sqlserver-tsql-foryou-database/

NEW POST:
✍ SQL Server Collations and Index Operations

🔎 Specifying a collation in WHERE clause predicates can result in scan operations, even when there is an underlying index. Can we coerce SQL into using Index Seeks?

👤 Dave Mason

https://www.davemason.me/2025/11/10/sql-server-collations-and-index-operations

#SQLServer
#Performance
#TSQL
#SQL
#Database