sigmoid.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A social space for people researching, working with, or just interested in AI!

Server stats:

574
active users

#tsql

2 posts2 participants0 posts today
Alvin Ashcraft 🐿️<p>Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio | by Erik EJ.</p><p><a href="https://erikej.github.io/sql/dacfx/visualstudio/2025/08/25/dacfx-visx-rules.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">erikej.github.io/sql/dacfx/vis</span><span class="invisible">ualstudio/2025/08/25/dacfx-visx-rules.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/visualstudio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudio</span></a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://hachyderm.io/tags/productivity" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>productivity</span></a></p>
Alvin Ashcraft<p>Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio | by Erik EJ. <a href="https://buff.ly/uryQcgx" rel="nofollow noopener" target="_blank">buff.ly/uryQcgx</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23sqlserver" target="_blank">#sqlserver</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=%23visualstudio" target="_blank">#visualstudio</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23database" target="_blank">#database</a> <a class="hashtag" rel="nofollow noopener" href="https://bsky.app/search?q=%23productivity" target="_blank">#productivity</a><br><br><a href="https://buff.ly/uryQcgx" rel="nofollow noopener" target="_blank">Presenting T-SQL Analyzer - li...</a></p>
Æ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>
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>
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>
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>
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>
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>
Alvin Ashcraft 🐿️<p>What’s New in SQL Server 2025.</p><p><a href="https://buff.ly/40WFLJz" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">buff.ly/40WFLJz</span><span class="invisible"></span></a> <br><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/sqlserver2025" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver2025</span></a> <a href="https://hachyderm.io/tags/msignite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>msignite</span></a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data</span></a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://hachyderm.io/tags/azuresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>azuresql</span></a> <a href="https://hachyderm.io/tags/ssms" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ssms</span></a> <a href="https://hachyderm.io/tags/tsql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tsql</span></a></p>
Alvin Ashcraft 🐿️<p>SQL Server (mssql) for Visual Studio Code - October release includes a connection dialog, table designer, new query results pane, query plan viewing, and object explorer filtering.</p><p><a href="https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">marketplace.visualstudio.com/i</span><span class="invisible">tems?itemName=ms-mssql.mssql</span></a></p><p><a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://hachyderm.io/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data</span></a> <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></p>
Alvin Ashcraft 🐿️<p>Debugging T-SQL using Visual Studio by Erin Stellato.</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/visualstudio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudio</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/debugging" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>debugging</span></a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://hachyderm.io/tags/queries" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>queries</span></a> <a href="https://hachyderm.io/tags/productivity" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>productivity</span></a> <br><a href="https://techcommunity.microsoft.com/t5/sql-server-blog/debugging-t-sql-using-visual-studio/ba-p/4232103" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">techcommunity.microsoft.com/t5</span><span class="invisible">/sql-server-blog/debugging-t-sql-using-visual-studio/ba-p/4232103</span></a></p>
Dave Mason<p>TSQL function GENERATE_SERIES is new to me. It looks like it arrived with SQL 2022. Here's a few examples:</p><p>SELECT * FROM GENERATE_SERIES(1, 10);<br>SELECT * FROM GENERATE_SERIES(1, 51, 3);<br>SELECT * FROM GENERATE_SERIES(1.0, 99.0, 2.5);<br>SELECT CHAR(value) AS UpperCaseAlpha FROM GENERATE_SERIES(65, 90);</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/TSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TSQL</span></a></p>
Alvin Ashcraft 🐿️<p>SQL Formatter for Visual Studio on Visual Studio Marketplace by Mads Kristensen.</p><p><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/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/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>data</span></a> <a href="https://hachyderm.io/tags/productivity" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>productivity</span></a> <br><a href="https://marketplace.visualstudio.com/items?itemName=MadsKristensen.SqlFormatter" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">marketplace.visualstudio.com/i</span><span class="invisible">tems?itemName=MadsKristensen.SqlFormatter</span></a></p>