I spent some time writing up how to #unittest the creation and changing of #sql database components in #Microsoft #SqlServer 's #TSql . It's useful in restricted environments that won't allow other development tools that normally could conduct unit tests.
https://www.patreon.com/posts/148232620

#TodayILearned about table-valued scalar functions in Microsoft #TSql and why I should care.

These can be used in a view. If you need to run a procedure to calculate parts of the output, but use a middleware that is incapable of calling functions directly, scalar functions are your next best bet.

If they return their value as a table, you can "join" them to the main rowset in the view using the operations "cross apply" (which behaves like inner join) and "outer apply" (like outer join).

#TodayILearned that Microsoft #TSql does NOT automatically shave off the trailing spaces of a char-typed value when reading it from a data table and inserting it into a varchar-typed column of a different table. You have to trim it or convert it explicitly. Char data types aim to preserve their padding.

Do you write a lot of paper checks? (I don't--typically it's just one per month.) If so, do you screw up the year when writing in the date for the first few weeks/months of the new year?

This is my TSQL version of that. I'm off to a good start. 🙄

#TSQL
#SSMS
#NewYear

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

Resolving Write Conflicts in Microsoft Fabric Data Warehouse
#MicrosoftFabric #DataWarehouse #TSQL #DDL
https://blog.fabric.microsoft.com/en-US/blog/concurrency-control-and-conflict-resolution-in-microsoft-fabric-data-warehouse/?wt.mc_id=DP-MVP-4015656

🐘 #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

"SQL Formatter
Free extension for SSMS v22. It's technically for VS, but you can use it in SSMS, and SSMS will eventually have its own extensions store."

Note: SSMS v22 represents a preview release.

Link:
https://github.com/madskristensen/SqlFormatter

H/t Brent Ozar's weekly email links: https://www.brentozar.com/subscribe/

#SSMS #SQLFormatter #SQL #TSQL #SQLServerManagementStudio #Extension #Formatting #Format

Announcing the release of SSMS 22 Preview 1

https://techcommunity.microsoft.com/blog/sqlserver/announcing-the-release-of-ssms-22-preview-1/4452627

#ssms #sqlserver #database #itpro #tsql #azuresql

Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio | by Erik EJ.

https://erikej.github.io/sql/dacfx/visualstudio/2025/08/25/dacfx-visx-rules.html

#sqlserver #tsql #visualstudio #database #productivity

Ingest data into your Warehouse using Transact-SQL
#MicrosoftFabric #DataWarehouse #SQL #TSQL
https://learn.microsoft.com/en-us/fabric/data-warehouse/ingest-data-tsql?wt.mc_id=DP-MVP-4015656

Who in the #TSQL language implementation team at Microsoft thought it was a good idea to differentiate between INSERT INTO - SELECT and SELECT INTO? Who thought it would be reasonable to expect that us users of those statements would find it obvious that one of them creates a new table and the other doesn't, but the one that doesn't also can't be used to insert rows into an existing table? Is this a thing other #SQL dialects do too?

Анализ плана выполнения запроса с оконной функцией в SQL Server (+бонус)

В статье подробно разбирается план выполнения запроса с оконной функцией в MS SQL Server, проводится сравнительный тест производительности с альтернативным запросом. Статья будет полезна разработчикам, работающим с аналитическими запросами в SQL Server, а также всем, кто хочет глубже понять логику оптимизатора и влияние различных факоров на планы выполнения.

https://habr.com/ru/articles/918210/

#tsql #ms_sql_server #план_выполнения_запросов #оптимизация_запросов