Viewing 15 posts - 1 through 15 (of 21 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...
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'...
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 |...
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...
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 🙂
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
...
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/[/url]
http://sqldbawithabeard.com/2014/03/03/rationalisation-of-database-with-powershell-and-t-sql-part-two-2/[/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...
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
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...
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...
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...
September 16, 2013 at 6:04 am
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
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...
September 13, 2013 at 11:34 am
Viewing 15 posts - 1 through 15 (of 21 total)