Skip to content

Details

The Power in PowerShell and SQL can turn you into a Wizard!

There are two SQL Server PowerShell modules; SqlServer and SQLPS.

The SqlServer module is the current PowerShell module to use.

The SQLPS module is included with the SQL Server installation (for backward compatibility) but is no longer updated.

The SqlServer module contains updated versions of the cmdlets in SQLPS and includes new cmdlets to support the latest SQL features.

Previous versions of the SqlServer module were included with SQL Server Management Studio (SSMS), but only with the 16.x versions of SSMS.

Greg will show the power of PowerShell for both cloud and on prem servers.

CyberSecurity will be on everyone's mind, and Greg will discuss some SecOps Fundamentals when using Powershell in SQL

Currently, Greg Crossan is a Database Administrator at Coast Capital Savings. Greg has almost 25 years of experience in IT, with the last 10 years in database-related technologies, and is versed in all core SQL Server technologies.

Greg has an extensive background administering database systems and is particularly interested in SQL Server performance, security, administration, data warehousing, and SQL Server Reporting Services (SSRS).
https://www.linkedin.com/in/rgregcrossan/

Join Us

Related topics

Education & Technology
Information Technology
Software Development
Technology
PowerShell

Sponsors

Code Of Conduct

Code Of Conduct

Be Excellent to Each Other

Steeves and Associates

Steeves and Associates

Platform and refreshments

You may also like