techhub.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A hub primarily for passionate technologists, but everyone is welcome

Administered by:

Server stats:

4.7K
active users

#dbatools

0 posts0 participants0 posts today
Vlad :verified:<p>This post demos a script I put together to help move SQL Server database files to another drive and folder by generating PowerShell and T-SQL commands.<br>This is an alternative for when you might not be allowed to install <a href="https://mastodon.cloud/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</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/PowerShell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PowerShell</span></a><br><a href="https://vladdba.com/2025/02/06/move-sql-server-database-files-another-drive-folder/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2025/02/06/move-sq</span><span class="invisible">l-server-database-files-another-drive-folder/</span></a></p>
Sascha Stumpler<p>PowerShell Universal + dbatools! <a href="http://dlvr.it/THb09b" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">http://</span><span class="">dlvr.it/THb09b</span><span class="invisible"></span></a> via PlanetPowerShell <a href="https://hessen.social/tags/PowerShell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PowerShell</span></a> <a href="https://hessen.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> <a href="https://hessen.social/tags/APIs" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>APIs</span></a> <a href="https://hessen.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a></p>
Andreas Jordan (ORDIX AG)<p>To all the <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a> DBAs out there: A new release of the PowerShell module <a href="https://mastodon.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> has been published today.<br>Most of the changes were made on a rainy Sunday in France. So this is the official France release...</p><p><a href="https://github.com/dataplat/dbatools/releases/tag/V2.1.13" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/dataplat/dbatools/r</span><span class="invisible">eleases/tag/V2.1.13</span></a></p>
Vlad :verified:<p>In this post I cover two ways to export and import multiple SQL Server tables to and from CSV in one go with the help of a little PowerShell magic and tools like <span class="h-card"><a href="https://dataplatform.social/@dbatools" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>dbatools</span></a></span> or bcp.</p><p><a href="https://vladdba.com/2023/11/16/export-multiple-sql-server-tables-to-csv-files" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2023/11/16/export-</span><span class="invisible">multiple-sql-server-tables-to-csv-files</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/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> <a href="https://mastodon.cloud/tags/powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powershell</span></a></p>
Andy Levy<p>Join me at <a href="https://techhub.social/tags/sqlsatboston" class="mention hashtag" rel="tag">#<span>sqlsatboston</span></a> next Saturday, October 14 for “Answering the Auditor’s Call with Automation” featuring <a href="https://techhub.social/tags/dbatools" class="mention hashtag" rel="tag">#<span>dbatools</span></a> <a href="https://techhub.social/tags/sqlfamily" class="mention hashtag" rel="tag">#<span>sqlfamily</span></a> <a href="https://techhub.social/tags/sqlserver" class="mention hashtag" rel="tag">#<span>sqlserver</span></a></p><p><a href="https://flxsql.com/2023/10/02/sql-saturday-boston-2023/" target="_blank" rel="nofollow noopener" translate="no"><span class="invisible">https://</span><span class="ellipsis">flxsql.com/2023/10/02/sql-satu</span><span class="invisible">rday-boston-2023/</span></a></p>
Andreas Jordan (ORDIX AG)<p>Version 2.1.0 der <a href="https://mastodon.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> – Ein Update mit Hindernissen | Die wichtigsten Änderungen sowie die Stolpersteine beim Update auf diese Version habe ich in meinem aktuellen Blog-Artikel zusammengestellt.<br><a href="https://blog.ordix.de/version-2-1-0-der-dbatools-ein-update-mit-hindernissen" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.ordix.de/version-2-1-0-de</span><span class="invisible">r-dbatools-ein-update-mit-hindernissen</span></a></p>
Dirk Hondong<p>ICYMI: There will be an awesome talk in a couple of minutes. <br><span class="h-card"><a href="https://tech.lgbt/@Jpomfret" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>Jpomfret</span></a></span> will talk about <a href="https://nrw.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> and how to manage <a href="https://nrw.social/tags/replication" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>replication</span></a> with them.<br>Make your <a href="https://nrw.social/tags/DBA" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBA</span></a> life easier</p><p><a href="https://www.meetup.com/de-DE/data-tgif/events/294744117" rel="nofollow noopener" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">meetup.com/de-DE/data-tgif/eve</span><span class="invisible">nts/294744117</span></a></p><p><a href="https://nrw.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a> <a href="https://nrw.social/tags/PowerShell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PowerShell</span></a> </p><p>/cc <span class="h-card"><a href="https://dataplatform.social/@dbatools" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>dbatools</span></a></span></p>
Frank Henninger<p>What's your favorite method to install <a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> Standard gui? Command line with config file? <a href="https://dataplatform.social/tags/powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powershell</span></a> Dsc? <a href="https://dataplatform.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a>. What's your weirdest? My favorite is <a href="https://dataplatform.social/tags/ansible" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ansible</span></a>.</p>
mbourgon<p><a href="https://dataplatform.social/tags/DBATools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBATools</span></a> Does anybody know if you can use applicationintent=readonly with Copy-DbaDbTableData? It looks like you'd have to use invoke-dbaquery and write it, but it's multi-gb of data so I'd rather not buffer it. Doesn't look like the sqlinstance param can use connection strings but I'm not positive <a href="https://dataplatform.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a></p>
David Wiseman<p>New version of DBA Dash is available 🚀<br><a href="https://dbadash.com/blog/whats-new-in-2.44.0/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dbadash.com/blog/whats-new-in-</span><span class="invisible">2.44.0/</span></a><br>Making use of the build reference provided by <a href="https://dataplatform.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> to display patching status in relation to the current builds that are available.<br><a href="https://dataplatform.social/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>opensource</span></a> monitoring tool for <a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a></p>
Vlad :verified:<p>This is a brief post about how to fix "The certificate chain was issued by an authority that is not trusted" error when using <span class="h-card"><a href="https://dataplatform.social/@dbatools" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>dbatools</span></a></span> </p><p><a href="https://vladdba.com/2023/07/29/fix-certificate-authority-that-is-not-trusted-when-using-dbatools" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2023/07/29/fix-cer</span><span class="invisible">tificate-authority-that-is-not-trusted-when-using-dbatools</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/dba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dba</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/sqlserverdba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserverdba</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/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a></p>
Jeff Edmunds<p>Recently installed and configured multiple dev, test, and prod <a href="https://techhub.social/tags/sqlserver" class="mention hashtag" rel="tag">#<span>sqlserver</span></a> environments, including SQL 2016, 2019, and 2022 boxes, all using almost nothing but <a href="https://techhub.social/tags/dbatools" class="mention hashtag" rel="tag">#<span>dbatools</span></a> scripting. Seems like there&#39;s almost nothing that <a href="https://techhub.social/tags/powershell" class="mention hashtag" rel="tag">#<span>powershell</span></a> module can&#39;t do. </p><p><span class="h-card" translate="no"><a href="https://tech.lgbt/@cl" class="u-url mention">@<span>cl</span></a></span> and the rest of the <span class="h-card" translate="no"><a href="https://dataplatform.social/@dbatools" class="u-url mention">@<span>dbatools</span></a></span> team are legends.</p>
matty of salisbury<p>One day I will remember that if you're doing veeam backups then this doesn't work:</p><p>get-dbaDbBackupHistory -sqlinstance $SqlInstance -lastlog -DeviceType 'Virtual Device'</p><p>....because, under the covers, Veeam actually does a local disk backup of the transaction logs, so you have to do</p><p>-DeviceType 'Disk'</p><p>Anyway, today was not that day</p><p><a href="https://mastodonapp.uk/tags/Powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Powershell</span></a> <a href="https://mastodonapp.uk/tags/Dba" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Dba</span></a> <a href="https://mastodonapp.uk/tags/SqlServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SqlServer</span></a> <a href="https://mastodonapp.uk/tags/DbaTools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DbaTools</span></a></p>
Andreas Jordan (ORDIX AG)<p>Very good presentation about cool use cases for <a href="https://mastodon.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> by <span class="h-card" translate="no"><a href="https://techhub.social/@nocentino" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>nocentino</span></a></span> just arrived on YouTube: <a href="https://www.youtube.com/watch?v=3Qow5br8Hzo&amp;t=565s&amp;ab_channel=PowerShell.org" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=3Qow5br8Hz</span><span class="invisible">o&amp;t=565s&amp;ab_channel=PowerShell.org</span></a></p>
Andreas Jordan (ORDIX AG)<p>Here is the list of changes that are waiting to be released in the next version of <a href="https://mastodon.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a>: <a href="https://github.com/dataplat/dbatools/compare/master...development" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/dataplat/dbatools/c</span><span class="invisible">ompare/master...development</span></a></p>
Andreas Jordan (ORDIX AG)<p>On my way to the Data Saturday Rheinland. If you are there as well and would like to talk about the <a href="https://mastodon.social/tags/PowerShell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PowerShell</span></a> module <a href="https://mastodon.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> for <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a> - feel free to contact me.<br><a href="https://datasaturdays.com/2023-06-17-datasaturday0034/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">datasaturdays.com/2023-06-17-d</span><span class="invisible">atasaturday0034/</span></a></p>
dbatools<p>Install-DbaMaintenanceSolution now supports auto-scheduling Ola Hallengren's agent jobs! Read more on <span class="h-card"><a href="https://tech.lgbt/@cl" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>cl</span></a></span>'s blog <a href="https://dataplatform.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> <a href="https://dataplatform.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://dataplatform.social/tags/powershell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>powershell</span></a> <a href="https://blog.netnerds.net/2023/05/install-dbamaintenancesolution-now-supports-auto-scheduling/" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.netnerds.net/2023/05/inst</span><span class="invisible">all-dbamaintenancesolution-now-supports-auto-scheduling/</span></a></p>
Andrew Notarian<p>I could not have done the work I did today so fast if <span class="h-card"><a href="https://tech.lgbt/@cl" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>cl</span></a></span> had not written all the scripts for me. <a href="https://dataplatform.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a></p>
dbatools<p>After 5 months of hard work, <a href="https://dataplatform.social/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> 2.0 is finally here! Tons of improvements (and a few breaking changes). You can read more on GitHub <a href="https://dataplatform.social/tags/PowerShell" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PowerShell</span></a> <a href="https://dataplatform.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLServer</span></a></p><p><a href="https://github.com/dataplat/dbatools/releases/tag/v2.0.0" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/dataplat/dbatools/r</span><span class="invisible">eleases/tag/v2.0.0</span></a></p>
Chrissy LeMaire :thonkpad:<p>After 5 months of hard work, <a href="https://tech.lgbt/tags/dbatools" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dbatools</span></a> 2.0 is finally here! Tons of improvements (and a few breaking changes).</p><p><a href="https://github.com/dataplat/dbatools/releases/tag/v2.0.0" rel="nofollow noopener" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/dataplat/dbatools/r</span><span class="invisible">eleases/tag/v2.0.0</span></a></p>