Showing results for SQL Server - Scripting Blog [archived]

Aug 21, 2019
0
0

PowerTip: Identify if SQL Servers are configured to best practices

Doctor Scripto
Doctor Scripto

Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers How can I easily check that my SQL Servers are all configured to meet best practices? You can use SQL Server Assessments – the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment on your SQL Server as ...

PowerTipPowerShellSQL Server
Aug 21, 2019
0
0

Executing SQL Server Assessments from PowerShell

Doctor Scripto
Doctor Scripto

Summary: Using the SQLServer module cmdlets to review and monitor SQL Server instance and database configuration Q: Hey, Doctor Scripto! I have loads of SQL Servers in my area of responsibility and I know they all need certain configuration settings but I'm never confident that they are all set just right so I spend a long time every month vi...

PowerShellSQL ServerDoctor Scripto
Jan 25, 2017
0
1

Nearly everything has changed for SQL Server PowerShell

Doctor Scripto
Doctor Scripto

2016 was the best year in SQL PowerShell history! I guess I should have mentioned that here sooner. Wired® Magazine recently said that Microsoft SQL Server was the surprise hit of the year. The primary cited reason is the SQL Server port to Linux, but there are several other reasons to be really excited about SQL Server and SQL Server PowerShell i...

communityPowerShellSQL Server
Jan 4, 2017
0
1

Where[-Object] clauses for people who use SQL Server

Doctor Scripto
Doctor Scripto

Summary: Learn about the power of the Where[-Object] cmdlet in PowerShell. Can I do a WHERE clause with an IN, in PowerShell?  Yes! Today’s post is from Aaron Nelson ( blog | twitter ), who is a Microsoft MVP for SQL Server (Data Platform), leads the PowerShell Virtual Chapters of PASS, volunteers for the local PASS Chapter AtlantaMDF, and helps o...

PowerShellSQL ServerGuestBlogger
Nov 18, 2013
0
0

The Admin’s First Steps: Capacity Planning Part 3

Doctor Scripto
Doctor Scripto

Summary: Richard Siddaway talks about using Windows PowerShell to create capacity planning reports.  Hey, Scripting Guy! I’ve just starting learning Windows PowerShell, and I understand how to use it as a scripting language and shell. I’ve been told to start performing capacity planning for my servers and was wondering how I can us...

Windows PowerShellOfficeMicrosoft Excel