Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
Learn how easy the new SQLServer module makes backups of SQL Server databases.
2017-01-12
35,182 reads
Aaron Nelson
Get-SqlLogin and Remove-SqlLogin Are Here
Learn how to use the login commands included with SSMS2016 from PowerShell.
2016-09-01
3,380 reads
The cmdlets Are Coming! The cmdlets Are Coming!
A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.
2016-07-01
1,207 reads
What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning
Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.
2016-04-19
1,651 reads
Day Zero with PowerShell
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
2012-01-02 (first published: 2011-05-10)
15,831 reads
Finding Free Space per Data File with PowerShell
Learn the easy way, and the hard way, to find the free space in each data file with Powershell expert Aaron Nelson.
2011-05-11
6,410 reads
Mid April Free Training from PASS VCs
Free training sessions brought to you by the AppDev and BI Virtual Chapters of PASS.
2011-04-12
953 reads
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-28
1,959 reads
Early December 2010 Free Training from PASS Virtual Chapters
The Performance, DBA, and B/I Virtual Chapters of PASS are back with free training.
2010-12-07
981 reads
End of October Free Training from PASS Virtual Chapters
This wraps up the last of the free training the PASS Virtual Chapters are providing in October.
2010-10-25
906 reads
Blogs
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers