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.5K
active users

#mssqlserver

2 posts1 participant0 posts today
Vlad :verified:<p>Blog post from the past:<br>In which I demo a few variations of basic SQL injection using PowerShell and SQL Server, while also showing how to address it.</p><p><a href="https://vladdba.com/2025/01/06/explaining-sql-injection-powershell-and-sql-server/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/01/06/explain</span><span class="invisible">ing-sql-injection-powershell-and-sql-server/</span></a></p><p><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/security" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>security</span></a> <a href="https://mastodon.cloud/tags/infosec" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>infosec</span></a></p>
Aljoscha Rittner (beandev)<p>Die Lawine rollt: Nächste Stadt in Europa schmeißt Microsoft Office raus</p><p><a href="https://winfuture.de/news,151881.html" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">winfuture.de/news,151881.html</span><span class="invisible"></span></a></p><p>&gt; So ist Lyon als die drittgrößte Stadt Frankreichs die nächste Kommune, die sich von Redmonder Software verabschiedet. Die Stadtverwaltung plant, statt Microsoft Office künftig die Open-Source-Alternative OnlyOffice einzusetzen. Auch die Microsoft-SQL-Datenbank soll durch PostgreSQL abgelöst werden.</p><p><a href="https://social.tchncs.de/tags/Windows" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Windows</span></a> <a href="https://social.tchncs.de/tags/Microsoft" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Microsoft</span></a> <a href="https://social.tchncs.de/tags/MSSqlServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MSSqlServer</span></a></p>
Vlad :verified:<p>New blog post:<br>In which I explore the impact of SQL Server 2025’s PBKDF2 hashing algorithm on password cracking and compare it with SQL Server 2022.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.cloud/tags/security" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>security</span></a> <a href="https://mastodon.cloud/tags/pbkdf2" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pbkdf2</span></a><br><a href="https://vladdba.com/2025/06/23/looking-into-sql-server-2025s-new-pbkdf2-hashing-algorithm/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/06/23/looking</span><span class="invisible">-into-sql-server-2025s-new-pbkdf2-hashing-algorithm/</span></a></p>
Vlad :verified:<p>Recently updated:<br>This blog post outlines ways to fix the access denied error you might encounter when attaching a database via SSMS in certain conditions.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powershell</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/dba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dba</span></a> <br><a href="https://vladdba.com/2022/09/29/fix-access-denied-when-attaching-a-database-via-ssms/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2022/09/29/fix-acc</span><span class="invisible">ess-denied-when-attaching-a-database-via-ssms/</span></a></p>
Vlad :verified:<p>SQL Server Management Studio 21.2.5 is out.</p><p>Fans of maintenance plans and SSIS will be happy to know the two features have been reinstated as part of this update.</p><p>Release notes: <a href="https://learn.microsoft.com/en-us/ssms/release-notes-21#21.2.5" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">learn.microsoft.com/en-us/ssms</span><span class="invisible">/release-notes-21#21.2.5</span></a><br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.cloud/tags/ssms" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ssms</span></a></p>
Vlad :verified:<p>New blog post:<br>In which I cover a fairly common VM CPU configuration mistake that may end up hurting your SQL Server’s performance and wasting licensing money.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a><br><a href="https://vladdba.com/2025/06/08/vm-cpu-configuration-sql-server-performance-licensing/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/06/08/vm-cpu-</span><span class="invisible">configuration-sql-server-performance-licensing/</span></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>
Vlad :verified:<p>New blog post:<br>Which covers creating SQL Server 2025 containers in <a href="https://mastodon.cloud/tags/Podman" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Podman</span></a>, <a href="https://mastodon.cloud/tags/Qnap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Qnap</span></a> Container Station, <a href="https://mastodon.cloud/tags/sqlcmd" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlcmd</span></a>, and restoring a sample database to test the new version.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.cloud/tags/container" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>container</span></a> <a href="https://mastodon.cloud/tags/docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>docker</span></a><br><a href="https://vladdba.com/2025/05/30/sql-server-2025-container/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/05/30/sql-ser</span><span class="invisible">ver-2025-container/</span></a></p>
Vlad :verified:<p>New blog post:<br>Which covers a potentially breaking change that comes with the version of sqlcmd shipped with SQL Server 2025.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a><br><a href="https://vladdba.com/2025/05/25/breaking-change-sqlcmd-version-sql-server-2025/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/05/25/breakin</span><span class="invisible">g-change-sqlcmd-version-sql-server-2025/</span></a></p>
Vlad :verified:<p>New blog post:<br>Covering system object changes in SQL Server 2025 versus 2022, as well as differences in the install kit.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a><br><a href="https://vladdba.com/2025/05/25/system-object-changes-sql-server-2025-2022/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/05/25/system-</span><span class="invisible">object-changes-sql-server-2025-2022/</span></a></p>
Vlad :verified:<p>New blog post:<br>In which I demo 3 methods to get SQL Server system objects' definitions.</p><p><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a><br><a href="https://vladdba.com/2025/05/22/view-sql-server-system-objects-definitions/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/05/22/view-sq</span><span class="invisible">l-server-system-objects-definitions/</span></a></p>
Vlad :verified:<p>New blog post:<br>Covering the install process of SQL Server 2025 Preview and some first impressions, especially on the new Standard Developer Edition<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a><br><a href="https://vladdba.com/2025/05/22/sql-server-2025-preview-installation-first-impressions/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/05/22/sql-ser</span><span class="invisible">ver-2025-preview-installation-first-impressions/</span></a></p>
Jordi Cabot<p>⚙️Are you looking for an <a href="https://fediscience.org/tags/online" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>online</span></a> <a href="https://fediscience.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://fediscience.org/tags/modeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>modeling</span></a> <a href="https://fediscience.org/tags/tool" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tool</span></a> with <a href="https://fediscience.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> generation?</p><p>With the latest updates (e.g. modeling of <a href="https://fediscience.org/tags/association" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>association</span></a> <a href="https://fediscience.org/tags/classes" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>classes</span></a>), BESSER is your ideal tool to <a href="https://fediscience.org/tags/design" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>design</span></a> and <a href="https://fediscience.org/tags/generate" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>generate</span></a> your databases in many different "flavours" : </p><p>☑️ <a href="https://fediscience.org/tags/SQLLite" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLLite</span></a></p><p>☑️ <a href="https://fediscience.org/tags/PostgresQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgresQL</span></a></p><p>☑️ <a href="https://fediscience.org/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a></p><p>☑️ <a href="https://fediscience.org/tags/MariaDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MariaDB</span></a></p><p>☑️ <a href="https://fediscience.org/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MSSQLServer</span></a></p><p>☑️ and even <a href="https://fediscience.org/tags/SQLAlchemy" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLAlchemy</span></a></p><p>Ready to give it a try? No installation required! ➡️ <a href="https://editor.besser-pearl.org/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">editor.besser-pearl.org/</span><span class="invisible"></span></a> </p><p>Did I already mention is completely 🆓 and <a href="https://fediscience.org/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>opensource</span></a>?</p>
Vlad :verified:<p>The latest release of PSBlitz brings an improved look and feel of the HTML report along with other small enhancements and bug fixes.<br><a href="https://github.com/VladDBA/PSBlitz" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">github.com/VladDBA/PSBlitz</span><span class="invisible"></span></a><br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powershell</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
Vlad :verified:<p>New blog post:<br>Which outlines a list of feedback items for SSMS 21 that I believe should be addressed before it goes GA.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.cloud/tags/ssms" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ssms</span></a><br><a href="https://vladdba.com/2025/05/07/my-wish-list-for-ssms-21/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/05/07/my-wish</span><span class="invisible">-list-for-ssms-21/</span></a></p>
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>
Vlad :verified:<p>Recently updated blog post:<br>Which contains a script that I’ve written and used a few times when I’ve needed to search for a string in an entire SQL Server database.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a><br><a href="https://vladdba.com/2023/12/13/script-to-search-for-a-string-in-an-entire-sql-server-database/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2023/12/13/script-</span><span class="invisible">to-search-for-a-string-in-an-entire-sql-server-database/</span></a></p>
Vlad :verified:<p>New blog post:<br>In which I demo a query that lists object dependencies in SQL Server for either a specific object or for the entire database.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <br><a href="https://vladdba.com/2025/04/15/query-object-dependencies-sql-server/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/04/15/query-o</span><span class="invisible">bject-dependencies-sql-server/</span></a></p>
Vlad :verified:<p>New blog post:<br>In which I demo a query to get connection information in SQL Server aggregated by database, host, client and login name.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>microsoftsqlserver</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqldba</span></a> <a href="https://mastodon.cloud/tags/AzureSQLDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AzureSQLDB</span></a> <a href="https://mastodon.cloud/tags/Azure" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Azure</span></a> <br><a href="https://vladdba.com/2025/04/13/query-connection-information-in-sql-server/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/04/13/query-c</span><span class="invisible">onnection-information-in-sql-server/</span></a></p>
Vlad :verified:<p>The latest release of PSBlitz:<br>- adds file IO stats to the database files info table<br>- includes sessions by state and newest connection time as part of the client connections table in the Instance Overview page<br>- increases the connection timeout to accommodate Azure connection approval prompts<br>- fixes a bug where the database info check would fail on Azure SQL MI<br>- addresses a bug in the CSS of the Azure SQL DB Info page<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqldba</span></a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powershell</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mssql</span></a><br><a href="https://github.com/VladDBA/PSBlitz" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="">github.com/VladDBA/PSBlitz</span><span class="invisible"></span></a></p>