Viewing 15 posts - 1 through 15 (of 22 total)
I have an opinion and obviously I have a biased view as Gianluca and I were the ones who put Data Saturdays together. We turned it around quickly as there...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
February 1, 2021 at 9:56 pm
Of course if I read the question carefully and see SQL and not Server then what you can do is
$Instance = 'DAVE'
$Server = ''
if($Instance -eq 'MSSQLSERVER'...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
July 18, 2017 at 7:40 am
You can use PowerShell for the machine
Get-EventLog -LogName system | where {$_.eventid -eq 6006}
will show the Event Log Service was stopped
Get-EventLog -LogName system |...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
July 18, 2017 at 7:02 am
Hi,
assuming you have the latest SSMS installed https://sqlps.io/dl then you will have the SQLServer module. (if you don't you probably have the SQLPS module which will work...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
April 12, 2017 at 9:28 am
Awesome, have you considered joining the SQL Community Collaborative on Github?
https://github.com/sqlcollaborative
or in the dbatools dbareports channel in the SQL Community Slack
That's what we do 🙂
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
October 27, 2016 at 4:50 am
Hi,
This is how I would achieve this in straight SMO
Rob
# Load the assembly
[void][reflection.assembly]::LoadWithPartialName( "Microsoft.SqlServer.Smo" );
foreach($Server in $Servers)
{
## Create a Server SMO Object
...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
October 27, 2016 at 3:57 am
Blog posts describing the process can be found here
http://sqldbawithabeard.com/2014/02/25/rationalisation-of-database-with-powershell-and-t-sql-part-one/%5B/url%5D
http://sqldbawithabeard.com/2014/03/03/rationalisation-of-database-with-powershell-and-t-sql-part-two-2/%5B/url%5D
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
March 25, 2014 at 7:31 am
We follow the same as several comments, we set the sysadmins to master and everyone else to tempdb on all servers in all environments from Dev to Live.
We reasoned...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
November 14, 2013 at 2:39 pm
Hi
You are probably best of using the Out-Datatable and Write-DataTable functions to do this.
Google will give you plenty of examples
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 22, 2013 at 1:10 am
It's probably best for a new question, So create a new thread
If
$Server = CLusterNode
that will show you if SQL is running on that node but there will be...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 16, 2013 at 9:37 am
$SQL = Get-Service -ComputerName $server -name *sql* if i run this not returning anything, can you suggest me what i would need to change.
That is setting the services whose name...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 16, 2013 at 9:17 am
HI
As you don't explain the errors or the code you are running you are getting I can't really be of much use.............
You need to find the name of the service...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 16, 2013 at 6:04 am
It's called POwerDoc it's very good
http://sqlpowerdoc.codeplex.com/%5B/url%5D
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 14, 2013 at 9:13 am
Take a look at the posts here if you want an excellent series on using Powershell to backup and restore
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 14, 2013 at 9:09 am
Ah now I understand
This should do the trick
$SSRS = Get-Service -ComputerName $server -name *report*
$SSIS = Get-Service -ComputerName $server -name *Integra*
If ($SSRS -eq $null)
{
Write-Host SSRS Not Installed on $server
}
else
{
$SSRS
}
If ($SSIS -eq...
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
September 13, 2013 at 11:34 am
Viewing 15 posts - 1 through 15 (of 22 total)