This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# This is the code used to tell you | |
which databases are using up the RAM on | |
your SQL Server is great information to know | |
Queries are from https://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/ #> | |
$SQLInstance = 'localhost\SQL2016' | |
Invoke-Sqlcmd -ServerInstance $SQLInstance -Database master -Query " | |
DECLARE @total_buffer INT; | |
SELECT @total_buffer = cntr_value |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<#1#> | |
Get-Command -Module SqlServer -Noun SqlAgent* | |
<#2#> | |
Get-SqlAgentJobHistory -ServerInstance localhost, localhost\SQL2016 -Since Midnight -OutcomesType Failed | |
<#3#> | |
Get-SqlAgentJobHistory -ServerInstance localhost, localhost\SQL2016 -Since Midnight -OutcomesType Failed | | |
Out-GridView |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# This script is intented to help automate Steps 2-7 for downloading & installing the SQL Server Performance Dashboard Reports | |
https://blogs.msdn.microsoft.com/sql_server_team/sql-server-performance-dashboard-reports-unleashed-for-enterprise-monitoring/ #> | |
<# If the ReportingServicesTools is not present, download the ReportingServicesTools module from GitHib #> | |
try {Import-Module ReportingServicesTools -ErrorAction Stop} catch {Invoke-Expression (Invoke-WebRequest https://aka.ms/rstools)} finally {Import-Module ReportingServicesTools} | |
<# Setting our GitHub resources to variables #> | |
$ZipURL = "https://github.com/Microsoft/tigertoolbox/raw/master/SQL-performance-dashboard-reports/SQL%20Server%20Performance%20Dashboard%20Reporting%20Solution.zip" | |
$SQLURL = 'https://github.com/Microsoft/tigertoolbox/raw/master/SQL-performance-dashboard-reports/setup.sql' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Install-Module SqlServer | |
<# If you don't have admin #> | |
Install-Module SqlServer -Scope CurrentUser | |
<# Find the commands #> | |
Get-Command -Module SqlServer -CommandType Cmdlet | | |
Out-GridView | |
<# What if you need to install on a server behind a firewall #> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# | |
Let's go shopping in the PowerShell Store | |
Ok, it is not actually called the 'store' | |
it is called the PowerShell Gallery | |
#> | |
Start-Process http://PowerShellGallery.com | |
<# Use the Search #> | |
<# |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "Top15Palatte", | |
"dataColors": ["#887e6f","#295270","#e6942d","#d52c33","#9f9311","#9fc2dc","#ffc945","#665d3c","#54758D","#DD565C","#EBA957","#9f9f9f","#276B75","#b6749c","#9d9898" | |
], | |
"background":"#ffffff", | |
"foreground": "#003052", | |
"tableAccent": "#9fc2dc" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Function Get-DisksSpace | |
{ | |
<# | |
.SYNOPSIS | |
Grabs Hard Drive & Mount Point space information. | |
.DESCRIPTION | |
Grabs Hard Drive & Mount Point space information. | |
.PARAMETER serverName | |
Accepte 1 or more servernames, up to 50 at once. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# Literally one of the oldest SQL PowerShell examples, and it now works on PSCore. | |
I'm only doing this step to generate data to place in an Excel spreadsheet. | |
IMPORTANT: If you already have an Excel spreadsheet, skip this section! #> | |
ls 'SQLSERVER:\SQLRegistration\Database Engine Server Group' -Recurse | | |
WHERE {$_.Mode -ne 'd' } | | |
foreach { | |
Invoke-Sqlcmd -ServerInstance $_.Name -Database master -OutputAs DataTables -Query " | |
SELECT @@ServerName AS 'ServerName', | |
DB_NAME(dbid) AS 'DatabaseName', | |
name AS 'LogicalName', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$BakURL = "https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak" | |
$BakFile = "$($Home)\Downloads\AdventureWorks2016.bak" | |
Invoke-WebRequest -Uri $BakURL -OutFile $BakFile | |
mkdir C:\SQLData\Docker\SQLDev02 | |
#dir C:\SQLData\Docker\SQLDev02 | OGV -PassThru | Remove-Item | |
Copy-Item -Path "$($Home)\Downloads\AdventureWorks2016.bak" -Destination C:\SQLData\Docker\SQLDev02 | |
<# Create a Container with a volume mounted from the host #> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<# Get the Server SMO objects for ServerA & ServerB | |
The default output for this command will include the Instance name, version, Service Pack, & CU Update Level #> | |
Get-SqlInstance -ServerInstance ServerA, ServerB | |
<# Sample Output #> | |
Instance Name Version ProductLevel UpdateLevel | |
------------- ------- ------------ ----------- | |
ServerA 13.0.5233 SP2 CU4 | |
ServerB 14.0.3045 RTM CU12 | |
<# Get the Instance name, version, Service Pack, & CU Update Level, |
OlderNewer