#tsql — Public Fediverse posts

Запах SELECT'а. Обнаружение CODE SMELL до отправки T-SQL кода на прод

Взгляд на экосистему SQL-разработки под MS SQL SERVER через призму контроля качества кода. Обзор существующих инструментов, описание самостоятельной наработки для линтинга T-SQL кода.

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

#tsql #code_smell #static_analysis #opensource #db #sqlproj #ssdt #dacfx #scriptdom #codesmell

Запах SELECT'а. Обнаружение CODE SMELL до отправки T-SQL кода на прод

Взгляд на экосистему SQL-разработки под MS SQL SERVER через призму контроля качества кода. Обзор существующих инструментов, описание самостоятельной наработки для линтинга T-SQL кода.

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

#tsql #code_smell #static_analysis #opensource #db #sqlproj #ssdt #dacfx #scriptdom #codesmell

Запах SELECT'а. Обнаружение CODE SMELL до отправки T-SQL кода на прод

Взгляд на экосистему SQL-разработки под MS SQL SERVER через призму контроля качества кода. Обзор существующих инструментов, описание самостоятельной наработки для линтинга T-SQL кода.

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

#tsql #code_smell #static_analysis #opensource #db #sqlproj #ssdt #dacfx #scriptdom #codesmell

Запах SELECT'а. Обнаружение CODE SMELL до отправки T-SQL кода на прод

Взгляд на экосистему SQL-разработки под MS SQL SERVER через призму контроля качества кода. Обзор существующих инструментов, описание самостоятельной наработки для линтинга T-SQL кода.

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

#tsql #code_smell #static_analysis #opensource #db #sqlproj #ssdt #dacfx #scriptdom #codesmell

No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric
#AI #ArtificialIntelligence #MicrosoftFabric #Azure #VSCode $SSMS #TSQL #GitHHubCopilot #SQLDatabase #CloudDatabases
https://blog.fabric.microsoft.com/en-US/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/?wt.mc_id=DP-MVP-4015656

No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric
#AI #ArtificialIntelligence #MicrosoftFabric #Azure #VSCode $SSMS #TSQL #GitHHubCopilot #SQLDatabase #CloudDatabases
https://blog.fabric.microsoft.com/en-US/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/?wt.mc_id=DP-MVP-4015656

No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric
#AI #ArtificialIntelligence #MicrosoftFabric #Azure #VSCode $SSMS #TSQL #GitHHubCopilot #SQLDatabase #CloudDatabases
https://blog.fabric.microsoft.com/en-US/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/?wt.mc_id=DP-MVP-4015656

No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric
#AI #ArtificialIntelligence #MicrosoftFabric #Azure #VSCode $SSMS #TSQL #GitHHubCopilot #SQLDatabase #CloudDatabases
https://blog.fabric.microsoft.com/en-US/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/?wt.mc_id=DP-MVP-4015656

No more excuses: AI-powered assistants are in SSMS, VS Code, and Fabric
#AI #ArtificialIntelligence #MicrosoftFabric #Azure #VSCode $SSMS #TSQL #GitHHubCopilot #SQLDatabase #CloudDatabases
https://blog.fabric.microsoft.com/en-US/blog/no-more-excuses-ai-powered-assistants-are-in-ssms-vs-code-and-fabric/?wt.mc_id=DP-MVP-4015656

Use database instructions with GitHub Copilot in SQL Server Management Studio
#ArtificialIntelligence #AI #GithHubCopilot #SSMS #SQLServer #TSQL
https://learn.microsoft.com/en-us/ssms/github-copilot/database-instructions?wt.mc_id=DP-MVP-4015656

Use database instructions with GitHub Copilot in SQL Server Management Studio
#ArtificialIntelligence #AI #GithHubCopilot #SSMS #SQLServer #TSQL
https://learn.microsoft.com/en-us/ssms/github-copilot/database-instructions?wt.mc_id=DP-MVP-4015656

Use database instructions with GitHub Copilot in SQL Server Management Studio
#ArtificialIntelligence #AI #GithHubCopilot #SSMS #SQLServer #TSQL
https://learn.microsoft.com/en-us/ssms/github-copilot/database-instructions?wt.mc_id=DP-MVP-4015656

Use database instructions with GitHub Copilot in SQL Server Management Studio
#ArtificialIntelligence #AI #GithHubCopilot #SSMS #SQLServer #TSQL
https://learn.microsoft.com/en-us/ssms/github-copilot/database-instructions?wt.mc_id=DP-MVP-4015656

Use database instructions with GitHub Copilot in SQL Server Management Studio
#ArtificialIntelligence #AI #GithHubCopilot #SSMS #SQLServer #TSQL
https://learn.microsoft.com/en-us/ssms/github-copilot/database-instructions?wt.mc_id=DP-MVP-4015656

TSQL Problem:
Let's say you've got one or more scalar values that are VARCHAR 'strings' and you want to determine if they can be typed more appropriately.

For example '16:16:34.6733333' is data type TIME. It's easy to examine the value manually to make that determination. But how would you do it programatically (via TSQL)?

I've tried casting the VARCHAR as different types. TRY_CAST is successful for some data types. How would I know which one is 'right'?

#SQLHelp
#SQLServer
#SQL
#TSQL

TSQL Problem:
Let's say you've got one or more scalar values that are VARCHAR 'strings' and you want to determine if they can be typed more appropriately.

For example '16:16:34.6733333' is data type TIME. It's easy to examine the value manually to make that determination. But how would you do it programatically (via TSQL)?

I've tried casting the VARCHAR as different types. TRY_CAST is successful for some data types. How would I know which one is 'right'?

#SQLHelp
#SQLServer
#SQL
#TSQL

TSQL Problem:
Let's say you've got one or more scalar values that are VARCHAR 'strings' and you want to determine if they can be typed more appropriately.

For example '16:16:34.6733333' is data type TIME. It's easy to examine the value manually to make that determination. But how would you do it programatically (via TSQL)?

I've tried casting the VARCHAR as different types. TRY_CAST is successful for some data types. How would I know which one is 'right'?

#SQLHelp
#SQLServer
#SQL
#TSQL

TSQL Problem:
Let's say you've got one or more scalar values that are VARCHAR 'strings' and you want to determine if they can be typed more appropriately.

For example '16:16:34.6733333' is data type TIME. It's easy to examine the value manually to make that determination. But how would you do it programatically (via TSQL)?

I've tried casting the VARCHAR as different types. TRY_CAST is successful for some data types. How would I know which one is 'right'?

#SQLHelp
#SQLServer
#SQL
#TSQL

TSQL Problem:
Let's say you've got one or more scalar values that are VARCHAR 'strings' and you want to determine if they can be typed more appropriately.

For example '16:16:34.6733333' is data type TIME. It's easy to examine the value manually to make that determination. But how would you do it programatically (via TSQL)?

I've tried casting the VARCHAR as different types. TRY_CAST is successful for some data types. How would I know which one is 'right'?

#SQLHelp
#SQLServer
#SQL
#TSQL

Строковые константы в MS SQL

Строковые константы в MS SQL кажутся очень простыми в использовании. Но эта простота не всегда очевидна и порой приводит к тяжело выявляемым ошибкам в коде. По этой причине данная статья может оказаться полезной не только новичкам, но и тем, кто уже использует T-SQL в своей работе. Документация явно описывает два типа констант: обычные строковые и юникодные. Но на самом деле ситуация несколько сложнее, что и будет рассмотрено ниже.

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

#sql_server #sql #tsql

Строковые константы в MS SQL

Строковые константы в MS SQL кажутся очень простыми в использовании. Но эта простота не всегда очевидна и порой приводит к тяжело выявляемым ошибкам в коде. По этой причине данная статья может оказаться полезной не только новичкам, но и тем, кто уже использует T-SQL в своей работе. Документация явно описывает два типа констант: обычные строковые и юникодные. Но на самом деле ситуация несколько сложнее, что и будет рассмотрено ниже.

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

#sql_server #sql #tsql

Строковые константы в MS SQL

Строковые константы в MS SQL кажутся очень простыми в использовании. Но эта простота не всегда очевидна и порой приводит к тяжело выявляемым ошибкам в коде. По этой причине данная статья может оказаться полезной не только новичкам, но и тем, кто уже использует T-SQL в своей работе. Документация явно описывает два типа констант: обычные строковые и юникодные. Но на самом деле ситуация несколько сложнее, что и будет рассмотрено ниже.

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

#sql_server #sql #tsql

Строковые константы в MS SQL

Строковые константы в MS SQL кажутся очень простыми в использовании. Но эта простота не всегда очевидна и порой приводит к тяжело выявляемым ошибкам в коде. По этой причине данная статья может оказаться полезной не только новичкам, но и тем, кто уже использует T-SQL в своей работе. Документация явно описывает два типа констант: обычные строковые и юникодные. Но на самом деле ситуация несколько сложнее, что и будет рассмотрено ниже.

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

#sql_server #sql #tsql

OPENROWSET and External Tables for Fabric SQL Databases
#SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake

https://blog.fabric.microsoft.com/en-US/blog/openrowset-and-external-tables-for-fabric-sql-databases/?wt.mc_id=DP-MVP-4015656

OPENROWSET and External Tables for Fabric SQL Databases
#SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake

https://blog.fabric.microsoft.com/en-US/blog/openrowset-and-external-tables-for-fabric-sql-databases/?wt.mc_id=DP-MVP-4015656

OPENROWSET and External Tables for Fabric SQL Databases
#SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake

https://blog.fabric.microsoft.com/en-US/blog/openrowset-and-external-tables-for-fabric-sql-databases/?wt.mc_id=DP-MVP-4015656

OPENROWSET and External Tables for Fabric SQL Databases
#SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake

https://blog.fabric.microsoft.com/en-US/blog/openrowset-and-external-tables-for-fabric-sql-databases/?wt.mc_id=DP-MVP-4015656

OPENROWSET and External Tables for Fabric SQL Databases
#SQL #SQLDatabase #MicrosoftFabric #DataVirtualization #Analytics #TSQL #OneLake

https://blog.fabric.microsoft.com/en-US/blog/openrowset-and-external-tables-for-fabric-sql-databases/?wt.mc_id=DP-MVP-4015656

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

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

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

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

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

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

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

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

#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

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

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

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

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

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

🧵 👇