Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
0000_Installing_the_Modules.ps1
000_Providers.ps1
00_Using_Get-SqlInstance.ps1
0A_Set-SqlErrorLog-ErrorLogSizeKb.ps1
1_Invoke-SqlVulnerabilityAssessmentScan.ps1
2A_Import-Excel.ps1
2B_Export-Excel.ps1
README.md

README.md

Achieve more in less time using the new SQL PowerShell - THR2114

These are the scripts used in my presentation at the Ignite conference in 2018. You can find the video for these scripts here on YouTube.

Abstract

Microsoft's official PowerShell module for SQL Server offers faster ways to manage your entire data-loving world. See the best of the new features in the new SQL Server module, and why every data professional will find it useful. The SQL Server team has already delivered new cmdlets to help you manage SQL Agent Jobs, SQL Error Logs, and Add & Remove Logins. You can now query multiple sources (SQL, csv files, etc.) and combine the results easily; leveraging .NET DataTables, you can insert those results into SQL Server in a streamlined way.

New versions of the SQL Server module are being released every month or two with more new features. See all the new capabilities in SQL PowerShell, and get a cheat-sheet to remember what you learned.

Demos

Make SQL PowerShell Better!

Go to aka.ms/SQLFeedback to submit your ideas and Up-Vote ideas other customers ideas.

You can’t perform that action at this time.