mastodon.world is one of the many independent Mastodon servers you can use to participate in the fediverse.
Generic Mastodon server for anyone to use.

Server stats:

8.4K
active users

#tsql

2 posts2 participants1 post today
UbuntuAnnouncing Full Cross-Platform Support for the mssql-python Driver After the successful release of Public Preview of mssql-python driver, we’re thrilled to announce a major milestone for the mssq...<br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Python" target="_blank">#Python</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Azure" target="_blank">#Azure</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Client" target="_blank">#Client</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Driver" target="_blank">#Driver</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Server" target="_blank">#Server</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Server" target="_blank">#Server</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/2025" target="_blank">#2025</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a><br><br><a href="https://devblogs.microsoft.com/python/announcing-full-cross-platform-support-for-the-mssql-python-driver/" rel="nofollow noopener" target="_blank">Origin</a> | <a href="https://awakari.com/sub-details.html?id=Ubuntu" rel="nofollow noopener" target="_blank">Interest</a> | <a href="https://awakari.com/pub-msg.html?id=VMBCXy6gL91BBDEF2iA9a4uTY7k&amp;interestId=Ubuntu" rel="nofollow noopener" target="_blank">Match</a>
Ænðr E. Feldstraw<p>Who in the <a href="https://mastodon.social/tags/TSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TSQL</span></a> 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 <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> dialects do too?</p>
Habr<p>Анализ плана выполнения запроса с оконной функцией в SQL Server (+бонус)</p><p>В статье подробно разбирается план выполнения запроса с оконной функцией в MS SQL Server, проводится сравнительный тест производительности с альтернативным запросом. Статья будет полезна разработчикам, работающим с аналитическими запросами в SQL Server, а также всем, кто хочет глубже понять логику оптимизатора и влияние различных факоров на планы выполнения.</p><p><a href="https://habr.com/ru/articles/918210/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/918210/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://zhub.link/tags/ms_sql_server" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ms_sql_server</span></a> <a href="https://zhub.link/tags/%D0%BF%D0%BB%D0%B0%D0%BD_%D0%B2%D1%8B%D0%BF%D0%BE%D0%BB%D0%BD%D0%B5%D0%BD%D0%B8%D1%8F_%D0%B7%D0%B0%D0%BF%D1%80%D0%BE%D1%81%D0%BE%D0%B2" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>план_выполнения_запросов</span></a> <a href="https://zhub.link/tags/%D0%BE%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_%D0%B7%D0%B0%D0%BF%D1%80%D0%BE%D1%81%D0%BE%D0%B2" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>оптимизация_запросов</span></a></p>
Alvin Ashcraft 🐿️<p>SQL and NoSQL Query language support come to ReSharper | by Rachel Appel.</p><p><a href="https://blog.jetbrains.com/dotnet/2025/06/10/sql-and-nosql-query-langauge-support-come-to-resharper/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.jetbrains.com/dotnet/2025</span><span class="invisible">/06/10/sql-and-nosql-query-langauge-support-come-to-resharper/</span></a> </p><p><a href="https://hachyderm.io/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://hachyderm.io/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>nosql</span></a> <a href="https://hachyderm.io/tags/resharper" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>resharper</span></a> <a href="https://hachyderm.io/tags/visualstudio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudio</span></a> <a href="https://hachyderm.io/tags/jetbrains" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>jetbrains</span></a></p>
Alvin Ashcraft<p>SQL and NoSQL Query language support come to ReSharper | by Rachel Appel. <a href="https://buff.ly/JTGoMSI" rel="nofollow noopener" target="_blank">buff.ly/JTGoMSI</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23tsql" target="_blank">#tsql</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23nosql" target="_blank">#nosql</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23resharper" target="_blank">#resharper</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23visualstudio" target="_blank">#visualstudio</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23jetbrains" target="_blank">#jetbrains</a><br><br><a href="https://buff.ly/JTGoMSI" rel="nofollow noopener" target="_blank">SQL and NoSQL Query langauge s...</a></p>
Habr<p>T-SQL в .NET Core EF Core: Гибридный подход к производительности и гибкости (Переосмысление с учетом обсуждения)</p><p>Секретное оружие в .NET Core: Почему вы игнорируете мощь T-SQL? Ваши LINQ-запросы становятся громоздкими? Производительность упирается в потолок? Возможно, вы упускаете нечто важное. Эта статья — приглашение взглянуть на привычные инструменты под новым углом. Мы исследуем гибридный подход, который позволяет использовать весь потенциал Microsoft SQL Server, выходя за рамки стандартного взаимодействия через EF Core. Узнайте, как T-SQL может упростить сложные задачи, повысить производительность и сделать вашу архитектуру более гибкой. Это не просто технический трюк, а переосмысление роли СУБД в современном приложении. Готовы узнать, как использовать "скрытые" возможности MSSQL и почему это может быть именно то, что нужно вашему проекту? Читать об этом</p><p><a href="https://habr.com/ru/articles/914378/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/914378/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/net" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>net</span></a> <a href="https://zhub.link/tags/net_core" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>net_core</span></a> <a href="https://zhub.link/tags/ef" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ef</span></a> <a href="https://zhub.link/tags/entityframework" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>entityframework</span></a> <a href="https://zhub.link/tags/linq" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>linq</span></a> <a href="https://zhub.link/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://zhub.link/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://zhub.link/tags/database_development" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database_development</span></a></p>
FunctionalProgrammingTechniques to query Azure SQL’s new JSON Datatype The new JSON field type and new functions in ...<br><br><a href="https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/techniques-to-query-azure-sqls-new-json-datatype/" rel="nofollow noopener" target="_blank">https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/techniques-to-query-azure-sqls-new-json-datatype/</a><br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Featured" target="_blank">#Featured</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Programming" target="_blank">#Programming</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/JSON" target="_blank">#JSON</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/functions" target="_blank">#functions</a><br><br><a href="https://awakari.com/pub-msg.html?id=YX1xvkgeNd8qmYANrK3MUVLNUHo&amp;interestId=FunctionalProgramming" rel="nofollow noopener" target="_blank">Result Details</a>
Habr<p>T-SQL в .NET Core EF Core: Гибридный подход к производительности и гибкости</p><p>В мире .NET разработки, работа с базами данных – неотъемлемая часть. Entity Framework Core (EF Core) предоставляет удобный способ взаимодействия с данными, но при работе с SQL Server, особенно в сложных сценариях, LINQ запросы могут уступать в производительности и гибкости T-SQL. Статья рассматривает эту дилемму, предлагая гибридный подход. Мы погрузимся в проблему: как эффективно использовать мощь T-SQL, не отказываясь от преимуществ EF Core? Обсудим интеграцию T-SQL через Raw SQL, Views, UDF и Stored Procedures. Раскроем лучшие практики: разделение ответственности, оптимизацию запросов, безопасность и тестирование. Поймем, как сочетать удобство ORM с производительностью SQL Server, применяя Data-Driven Design и, при необходимости, Domain-Driven Design. Статья – руководство для .NET разработчиков, стремящихся к оптимальному балансу между производительностью, гибкостью и удобством разработки при работе с SQL Server и EF Core. Читать об этом</p><p><a href="https://habr.com/ru/articles/906522/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/906522/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/net" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>net</span></a> <a href="https://zhub.link/tags/net_core" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>net_core</span></a> <a href="https://zhub.link/tags/ef" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ef</span></a> <a href="https://zhub.link/tags/entityframework" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>entityframework</span></a> <a href="https://zhub.link/tags/linq" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>linq</span></a> <a href="https://zhub.link/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://zhub.link/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://zhub.link/tags/database_development" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database_development</span></a></p>
FunctionalProgrammingExploring the SQL Server CHOOSE Function I preface a lot of what I write with whether or not it i...<br><br><a href="https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/exploring-the-sql-server-choose-function/" rel="nofollow noopener" target="_blank">https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/exploring-the-sql-server-choose-function/</a><br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Programming" target="_blank">#Programming</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Choose" target="_blank">#Choose</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Server" target="_blank">#Server</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Syntax" target="_blank">#Syntax</a><br><br><a href="https://awakari.com/pub-msg.html?id=Abd7jIhMfyyL4jAvoG8aNDv8NLU&amp;interestId=FunctionalProgramming" rel="nofollow noopener" target="_blank">Result Details</a>
FunctionalProgrammingCreating a Date Dimension (Calendar Table) in SQL Server Learn how to create and populate a Date ...<br><br><a href="https://www.sqlservercentral.com/articles/understanding-date-dimension-calendar-table-in-sql-server" rel="nofollow noopener" target="_blank">https://www.sqlservercentral.com/articles/understanding-date-dimension-calendar-table-in-sql-server</a><br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/analytics" target="_blank">#analytics</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Business" target="_blank">#Business</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Intelligence" target="_blank">#Intelligence</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/data" target="_blank">#data</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/analysis" target="_blank">#analysis</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Date" target="_blank">#Date</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Calculations" target="_blank">#Calculations</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/date" target="_blank">#date</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/dimension" target="_blank">#dimension</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Date" target="_blank">#Date</a><br><br><a href="https://awakari.com/pub-msg.html?id=Q3oVdu8NvOKYEtAGNWgrV10vdOy" rel="nofollow noopener" target="_blank">Event Attributes</a>
Habr<p>Раскраска листинга процедуры T-SQL значениями метрик</p><p>Сразу покажу, о чем идет речь, чтобы вы решили, нужно вам это или нет. На текст процедуры мы отображаем данные о числе выполнений, cpu, duration, о числе чтений и записей и числе обработанных записей.</p><p><a href="https://habr.com/ru/articles/897282/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/897282/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://zhub.link/tags/markup" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>markup</span></a> <a href="https://zhub.link/tags/performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>performance</span></a> <a href="https://zhub.link/tags/profiler" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>profiler</span></a></p>
Dave Mason<p>Here's the TSQL thing I mentioned a day or two ago: a stored procedure that performs an assessment of an existing database table.</p><p>So far, it does the following:<br>Checks for the presence/absence of certain criteria:<br>🔹A Primary Key and/or Unique Key.<br>🔹A clustered index.<br>🔹Compression (if any).<br>🔹Total number of rows.<br>🔹Create date.<br>🔹Columns with deprecated data types.<br>🔹Columns with ambiguous names.</p><p><a href="https://codeberg.org/DaveMasonDotMe/SQL-Server-Administration/src/branch/master/Stored%20Procedures/dbo.GetTableAssessment.sql" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">codeberg.org/DaveMasonDotMe/SQ</span><span class="invisible">L-Server-Administration/src/branch/master/Stored%20Procedures/dbo.GetTableAssessment.sql</span></a></p><p><a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a><br><a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a><br><a href="https://mastodon.social/tags/RDBMS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RDBMS</span></a><br><a href="https://mastodon.social/tags/TSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TSQL</span></a></p>
Kerrick Long (code)<p>New blog post:</p><p>30,656 Pages of Books About the .NET Ecosystem: C#, Blazor, ASP.NET, &amp; T-SQL</p><p>When I learned lean software development, I abandoned year-long planning at work and at home. This year, I broke my rule...</p><p>Continue reading: <a href="https://kerrick.blog/articles/2025/thirty-thousand-pages-of-books-about-the-dotnet-ecosystem/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">kerrick.blog/articles/2025/thi</span><span class="invisible">rty-thousand-pages-of-books-about-the-dotnet-ecosystem/</span></a></p><p><a href="https://dotnet.social/tags/Books" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Books</span></a> <a href="https://dotnet.social/tags/Reading" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Reading</span></a> <a href="https://dotnet.social/tags/NewYearsResolution" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NewYearsResolution</span></a> <a href="https://dotnet.social/tags/DotNET" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DotNET</span></a> <a href="https://dotnet.social/tags/CSharp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CSharp</span></a> <a href="https://dotnet.social/tags/Blazor" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Blazor</span></a> <a href="https://dotnet.social/tags/ASPNET" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ASPNET</span></a> <a href="https://dotnet.social/tags/TSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TSQL</span></a> <a href="https://dotnet.social/tags/FullStack" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FullStack</span></a> <a href="https://dotnet.social/tags/SoftwareDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SoftwareDevelopment</span></a> <a href="https://dotnet.social/tags/ProgrammingBooks" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ProgrammingBooks</span></a> <a href="https://dotnet.social/tags/LearningToCode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LearningToCode</span></a> <a href="https://dotnet.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDevelopment</span></a> <a href="https://dotnet.social/tags/EnterpriseSoftware" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>EnterpriseSoftware</span></a> <a href="https://dotnet.social/tags/TechBooks" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechBooks</span></a> <a href="https://dotnet.social/tags/CodeNewbie" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CodeNewbie</span></a> <a href="https://dotnet.social/tags/CodingJourney" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CodingJourney</span></a> <a href="https://dotnet.social/tags/DeveloperLife" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DeveloperLife</span></a></p>
Habr<p>Рассмотрим нововведения SQL Server Data Tools, связанные со средствами разработки БД для Microsoft SQL Server</p><p>Привет, Хабр. Меня зовут Артём, я старший инженер в департаменте аналитических решений ЮMoney. Вас ждёт очень большая статья, в которой мы вместе: ✓ посмотрим на изменения формата файла проекта sqlproj; ✓ разберёмся с новой возможностью публикации dacpac в репозиторий артефактов (например, NuGet) с целью многократного переиспользования в других проектах sqlproj; ✓ напишем анализатор кода tsql на C#, опубликуем его в репозиторий и используем в проекте sqlproj. Приятного чтения! 😊</p><p><a href="https://habr.com/ru/companies/yoomoney/articles/883326/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/yoomoney</span><span class="invisible">/articles/883326/</span></a></p><p><a href="https://zhub.link/tags/microsoft_sql_server" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoft_sql_server</span></a> <a href="https://zhub.link/tags/nuget" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>nuget</span></a> <a href="https://zhub.link/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://zhub.link/tags/c" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>c</span></a># <a href="https://zhub.link/tags/ssdt" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ssdt</span></a></p>
Alvin Ashcraft 🐿️<p>Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules by Erik EJ.</p><p><a href="https://erikej.github.io/sql/dacfx/2025/02/17/sql-dacfx-analyzer.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">erikej.github.io/sql/dacfx/202</span><span class="invisible">5/02/17/sql-dacfx-analyzer.html</span></a> </p><p><a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://hachyderm.io/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://hachyderm.io/tags/cli" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>cli</span></a> <a href="https://hachyderm.io/tags/commandline" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>commandline</span></a> <a href="https://hachyderm.io/tags/scripting" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>scripting</span></a></p>
Sascha Stumpler<p>T-SQL Tuesday 161: Having Fun with SQL <a href="http://dlvr.it/TJ18wf" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">http://</span><span class="">dlvr.it/TJ18wf</span><span class="invisible"></span></a> via PlanetPowerShell <a href="https://hessen.social/tags/TSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TSQL</span></a> <a href="https://hessen.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://hessen.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataAnalysis</span></a> <a href="https://hessen.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a></p>
Kerrick Long (code)<p>I need to learn C# / .NET / T-SQL / Blazor for work.</p><p>Which of these books (in what order) should I read? I'm very much a book-learner when it comes to languages, frameworks, technologies, and platforms.</p><p>(list of books in thread)</p><p><a href="https://ruby.social/tags/csharp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>csharp</span></a> <a href="https://ruby.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dotnet</span></a> <a href="https://ruby.social/tags/blazor" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>blazor</span></a> <a href="https://ruby.social/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a> <a href="https://ruby.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
FunctionalProgrammingSQL Server BIT_COUNT and an Alternative I was editing an article the other day that uses the BIT_...<br><br><a href="https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-server-bit_count-and-an-alternative/" rel="nofollow noopener" target="_blank">https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-server-bit_count-and-an-alternative/</a><br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Programming" target="_blank">#Programming</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Server" target="_blank">#Server</a><br><br><a href="https://awakari.com/pub-msg.html?id=UcF0E7nILANhihVtufx3lVGRGkK" rel="nofollow noopener" target="_blank">Event Attributes</a>
FunctionalProgrammingExploring Scalar Solutions to Complex Data Math There are many functions and tools available to d...<br><br><a href="https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/exploring-scalar-solutions-to-complex-data-math/" rel="nofollow noopener" target="_blank">https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/exploring-scalar-solutions-to-complex-data-math/</a><br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Featured" target="_blank">#Featured</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Programming" target="_blank">#Programming</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Server" target="_blank">#Server</a><br><br><a href="https://awakari.com/pub-msg.html?id=J5Lu1nxcZHhZlX6SEOaAC5rKIuO" rel="nofollow noopener" target="_blank">Event Attributes</a>
FunctionalProgrammingSQL Server BIT_COUNT and an Alternative I was editing an article the other day that uses the BIT_...<br><br><a href="https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-server-bit_count-and-an-alternative/" rel="nofollow noopener" target="_blank">https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/sql-server-bit_count-and-an-alternative/</a><br><br><a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/T-SQL" target="_blank">#T-SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Programming" target="_blank">#Programming</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/SQL" target="_blank">#SQL</a> <a rel="nofollow noopener" class="mention hashtag" href="https://mastodon.social/tags/Server" target="_blank">#Server</a><br><br><a href="https://awakari.com/pub-msg.html?id=L9OZzSwTKDODdFz7I3CVbpE8Cv2" rel="nofollow noopener" target="_blank">Event Attributes</a>