Mastodon

0 posts0 participants0 posts today

Vlad :verified:Blog post from the past:In which I go through my SQL Server Management Studio configuration. <a href="https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration/" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration/</a><a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dba</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/sqlserverdba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserverdba</a>

Vlad :verified:The latest release of PSBlitz:- is now code-signed with a Certum open source code signing certificate - retains CRLF in query text so that line comments (--) are no longer a problem - now prompts for advanced options when ran in interactive mode - logs sub-step status and timing when -DebugInfo is used - has a new report page for database objects with dangerous SET options - other bug fixes and minor improvements <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldba</a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#powershell</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://github.com/VladDBA/PSBlitz" rel="nofollow noopener noreferrer" target="_blank">https://github.com/VladDBA/PSBlitz</a>

Vlad :verified:In this post I’ll go over the steps to repair a SQL Server instance, via both GUI and <a href="https://mastodon.cloud/tags/PowerShell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PowerShell</a>, as well as explain when you might need to do it. <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldba</a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#microsoftsqlserver</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqldba</a> <a href="https://mastodon.cloud/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dba</a> <a href="https://vladdba.com/2025/01/22/repair-a-sql-server-instance/" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2025/01/22/repair-a-sql-server-instance/</a>

Martin<a href="https://social.saarland/@slesa" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@slesa</a> It's running Ubuntu:PRETTY_NAME="Ubuntu 22.04.5 LTS" NAME="Ubuntu" VERSION_ID="22.04" VERSION="22.04.5 LTS (Jammy Jellyfish)"<a href="https://dresden.network/tags/docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#docker</a> <a href="https://dresden.network/tags/compose" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#compose</a> <a href="https://dresden.network/tags/docker_compose" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#docker_compose</a> <a href="https://dresden.network/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://dresden.network/tags/MSSqlServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSqlServer</a> <a href="https://dresden.network/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLServer</a>

Vlad :verified:Blog post from the past:In which I test and compare the insert speeds in various combinations of scenarios, including table types, recovery models, and hints. <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldba</a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#microsoftsqlserver</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqldba</a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://vladdba.com/2023/06/22/testing-large-insert-speeds-in-sql-server/" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2023/06/22/testing-large-insert-speeds-in-sql-server/</a>

Martin<a href="https://blog.martinscloud.com/ms-sql-server-use-docker-compose-for-microsoft-sql-server/" rel="nofollow noopener noreferrer" translate="no" target="_blank">https://blog.martinscloud.com/ms-sql-server-use-docker-compose-for-microsoft-sql-server/</a> <a href="https://dresden.network/tags/docker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#docker</a> <a href="https://dresden.network/tags/compose" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#compose</a> <a href="https://dresden.network/tags/docker_compose" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#docker_compose</a> <a href="https://dresden.network/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://dresden.network/tags/MSSqlServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSqlServer</a> <a href="https://dresden.network/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a>

Vlad :verified:In this post I demo and explain a few variations of basic SQL injection using <a href="https://mastodon.cloud/tags/PowerShell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PowerShell</a> and SQL Server. <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldba</a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#microsoftsqlserver</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqldba</a> <a href="https://mastodon.cloud/tags/security" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#security</a> <a href="https://mastodon.cloud/tags/SQLinjection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQLinjection</a> <a href="https://vladdba.com/2025/01/06/explaining-sql-injection-powershell-and-sql-server/" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2025/01/06/explaining-sql-injection-powershell-and-sql-server/</a>

Vlad :verified:The latest release of PSBlitz has: - Refactored code for improved error handling, performance, readability, and reduced repetitive code. - Moved query execution, HTML and Excel result set conversion and file writing to dedicated functions. - Removed unnecessary columns from key checks/report pages to enhance stability and reduce report file size. - Slimmed down PS script to 4313 lines of code from 6553.<a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldba</a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#powershell</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a><a href="https://github.com/VladDBA/PSBlitz" rel="nofollow noopener noreferrer" target="_blank">https://github.com/VladDBA/PSBlitz</a>

Vlad :verified:In this post I demo how to export XML files from SQL Server via <a href="https://mastodon.cloud/tags/PowerShell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PowerShell</a>, using <a href="https://dataplatform.social/@dbatools" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@dbatools</a>, Invoke-Sqlcmd and .NET to retrieve the data. <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#microsoftsqlserver</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqldba</a> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> <a href="https://vladdba.com/2024/06/30/export-xml-files-from-sql-server/" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2024/06/30/export-xml-files-from-sql-server/</a>

PierreUne question <a href="https://piaille.fr/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a> Select toto, max(tata) from titi<a href="https://piaille.fr/tags/msSqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#msSqlserver</a> n'accepte pas, il manque le group by. <a href="https://piaille.fr/tags/Sqlite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Sqlite</a> accepte et renvoie une seule ligne, correspondant à la ligne pour lequel on attend le max.En vrai ça doit faire quoi ? Et sur d'autres <a href="https://piaille.fr/tags/sgbd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sgbd</a> ?Le repouet est doux et ralentit les invasions aliens.

Northstar TexSaw a post like this and I guess I should give it a shot.Recently my position got shut down because my workplace lost a business partnership.I primarily work in <a href="https://kind.social/tags/CSharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CSharp</a> in <a href="https://kind.social/tags/DotNet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DotNet</a> and <a href="https://kind.social/tags/DotNetCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DotNetCore</a> along with strong <a href="https://kind.social/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQLServer</a> skill. A lot of my time has been dedicated to back end development along. My more recent experience in <a href="https://kind.social/tags/AspDotNet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AspDotNet</a> and <a href="https://kind.social/tags/AspDotNetCore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#AspDotNetCore</a> and <a href="https://kind.social/tags/RestApi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RestApi</a> development. I also developed front end skills w/ <a href="https://kind.social/tags/Blazor" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Blazor</a> and <a href="https://kind.social/tags/VueJS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#VueJS</a><a href="https://kind.social/tags/lookingForAJob" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#lookingForAJob</a> <a href="https://kind.social/tags/getfedihired" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#getfedihired</a>

Vlad :verified:This is a brief post about how to fix "The certificate chain was issued by an authority that is not trusted" error when using <a href="https://dataplatform.social/@dbatools" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@dbatools</a> <a href="https://vladdba.com/2023/07/29/fix-certificate-authority-that-is-not-trusted-when-using-dbatools" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2023/07/29/fix-certificate-authority-that-is-not-trusted-when-using-dbatools</a><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dba</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/sqlserverdba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserverdba</a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#powershell</a> <a href="https://mastodon.cloud/tags/dbatools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dbatools</a>

daniel s.losing my mind. i can connect to a remote SQL server from SQL management studio no problem. but if i try to connect to the same server using powershell, same machine, same network, i get an error saying the server can't be found -- whether i use its IP, netbios, or FQDN. remote connections, named pipes, and IP are all on. nothing i try works. <a href="https://kibitz.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://kibitz.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sql</a>

Federico Campoli :postgresql:This Friday there will be the <a href="https://fosstodon.org/tags/dbaday" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dbaday</a> 2023. The 7th July 2023 say thank you to your <a href="https://fosstodon.org/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#dba</a> for keeping your data safe and sound. <a href="https://fosstodon.org/tags/thankyou" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#thankyou</a> <a href="https://fosstodon.org/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> <a href="https://fosstodon.org/tags/administrators" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#administrators</a> <a href="https://fosstodon.org/tags/appreciation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#appreciation</a> <a href="https://fosstodon.org/tags/day" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#day</a> <a href="https://fosstodon.org/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#postgresql</a> <a href="https://fosstodon.org/tags/mysql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mysql</a> <a href="https://fosstodon.org/tags/oracle" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#oracle</a> <a href="https://fosstodon.org/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://fosstodon.org/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://dbaday.org/" rel="nofollow noopener noreferrer" target="_blank">https://dbaday.org/</a>

Thor Rapid<a href="https://social.tchncs.de/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Microsoft</a> == unnötig Nerven aufreibendHab heute Stunden damit zugebracht von einem in <a href="https://social.tchncs.de/tags/Rust" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Rust</a> Code geschriebenen Programm auf einen <a href="https://social.tchncs.de/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQLServer</a> per <a href="https://social.tchncs.de/tags/ODBC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ODBC</a> zuzugreifen. Hab es zwischendurch auch in <a href="https://social.tchncs.de/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> mit <a href="https://social.tchncs.de/tags/sqlalchemy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlalchemy</a> versucht. Mit <a href="https://social.tchncs.de/tags/DBeaver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DBeaver</a> ging's, mit <a href="https://social.tchncs.de/tags/beekeeper" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#beekeeper</a> ging's, per Ping ging's. Bis ich mir endlich einen passenden <a href="https://social.tchncs.de/tags/ADO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ADO</a> String gebaut hatte der dem Server genehm war. 🙄 Sowas passiert mir bei <a href="https://social.tchncs.de/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> nie und auch sonst kenne ich keine solche Diva DB.

Vlad :verified:SSMS 19 was released last week, so I figured I'd take this opportunity to go through my usual SSMS configuration preferences. <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#sqldba</a> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#microsoftsqlserver</a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqlserver</a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssql</a> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#mssqldba</a> <a href="https://mastodon.cloud/tags/ssms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#ssms</a> <a href="https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration" rel="nofollow noopener noreferrer" target="_blank">https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration</a>

Gerald Leppert, PhD :verified:Bitte teilen! Neue Stellenausschreibung: Das deutsche <a href="https://bonn.social/tags/Evaluierungsinstitut" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Evaluierungsinstitut</a> der <a href="https://bonn.social/tags/Entwicklungszusammenarbeit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Entwicklungszusammenarbeit</a> (<a href="https://bonn.social/tags/DEval" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DEval</a>) sucht für das <a href="https://bonn.social/tags/Kompetenzzentrum" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Kompetenzzentrum</a> <a href="https://bonn.social/tags/Methoden" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Methoden</a>:• Projektleitung Management von Evaluierungsdaten / Forschungsdaten<a href="http://www.deval.org/de/stellenausschreibung/projektleitung-management-von-evaluierungsdaten-forschungsdaten.html" rel="nofollow noopener noreferrer" target="_blank">http://www.deval.org/de/stellenausschreibung/projektleitung-management-von-evaluierungsdaten-forschungsdaten.html</a> Bewerbungsfrist: 25.04.2021<a href="https://bonn.social/tags/Forschungsdaten" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Forschungsdaten</a> <a href="https://bonn.social/tags/Survey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Survey</a> <a href="https://bonn.social/tags/Geodata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Geodata</a> <a href="https://bonn.social/tags/Datenmanagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Datenmanagement</a> <a href="https://bonn.social/tags/DSGVO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DSGVO</a> <a href="https://bonn.social/tags/Evaluierung" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Evaluierung</a> <a href="https://bonn.social/tags/DataManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DataManagement</a> <a href="https://bonn.social/tags/DMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#DMS</a> <a href="https://bonn.social/tags/OpenData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#OpenData</a> <a href="https://bonn.social/tags/Wissensmanagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Wissensmanagement</a> <a href="https://bonn.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> <a href="https://bonn.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PostgreSQL</a> <a href="https://bonn.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MySQL</a> <a href="https://bonn.social/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MariaDB</a> <a href="https://bonn.social/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQLServer</a> <a href="https://bonn.social/tags/RStats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#RStats</a> <a href="https://bonn.social/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Python</a> <a href="https://bonn.social/tags/Dataverse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Dataverse</a> <a href="https://bonn.social/tags/Stata" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#Stata</a> <a href="https://bonn.social/tags/SPSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SPSS</a> <a href="https://bonn.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#PHP</a>

Ænðr E. Feldstraw<a href="https://mastodon.social/tags/TIL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TIL</a> that <a href="https://mastodon.social/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQLServer</a> can encode and decode <a href="https://mastodon.social/tags/BASE64" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#BASE64</a> data inside an <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> statement, Decoding something stored as Base64 works like this: ```SQL CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:column("field_name"))', 'VARBINARY(MAX)') AS VARCHAR(MAX)) ``` <a href="https://mastodon.social/tags/TodayILearned" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TodayILearned</a>

Ænðr E. Feldstraw<a href="https://mastodon.social/tags/TIL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TIL</a> To convert into multiple rows, multiple elements from an <a href="https://mastodon.social/tags/XML" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#XML</a> document stored an XML field in an <a href="https://mastodon.social/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQLServer</a> data table, you can use the <a href="https://mastodon.social/tags/CROSSAPPLY" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#CROSSAPPLY</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> statement. <a href="https://mastodon.social/tags/TodayILearned" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#TodayILearned</a>. Cross Apply has been part of SQLServer since several years. I never had a use for it: we just stored the data and never needed to extract anything from it.

Ænðr E. FeldstrawSearching for a way to make sense of a growing collection of customized <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#database</a> views, I decided I could use schemas / users dedicated to subsections. Did you know moving views to different schemas is as easy as drop and create? That <a href="https://mastodon.social/tags/MSSQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#MSSQLServer</a> fails to let us drag and drop between schemas? And that it won't let us proliferate user privileges across schemas without coding applied liberally? This is going to be "fun". <a href="https://mastodon.social/tags/UX" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#UX</a>

Recent searches

Search options

Administered by:

Server stats:

#mssqlserver