Infrastructure at your Service

PowerShell Archives - Page 2 of 3 - Blog dbi services

Georges Grey

Control-M Application Integrator verwaltet Microsoft PowerShell Code & Credentials

By | Application integration & Middleware, Operation systems | No Comments

Welche Vorteile hat “Control-M Application Integrator”? Bei einem Kunden, der Control-M im Einsatz hat, habe ich auf einem Windows Server ganz viele Windows und PowerShell Scripts angetroffen. Unter diesen Scripts waren einige die nach einem bestimmten Keyword in einem Log-File suchten. Alle diese Scripts hatten einen festen CIFS Path im Script. Damit das klappt, wurde ein Share auf dem Windows Server gemappt, das File nach dem Keyword durchsucht und der Share wieder abgehängt. Dazu wurden…

Read More
Nathan Courtine

Get the main information from SQL Server databases with PowerShell

By | Database management | One Comment

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments! Retrieve SQL Server databases information I use the SMO objects to access the instance…

Read More
Nathan Courtine

Get SQL Server Network Configuration with PowerShell

By | Database management | One Comment

This blog is part of a set which try to automate the SQL Server administration with PowerShell. It explains how to retrieve the network configuration of a SQL Server instance with PowerShell. I will refer to my previous blog Get SQL Server services with PowerShell. I presented how to get the SQL Server Engine service. I will assume the service has already been retrieved. Disclaimer: I am not a developer but a SQL Server dba….

Read More
Nathan Courtine

Get the main Administration Information from SQL Server with PowerShell

By | Database management | No Comments

In my previous blog Get SQL Server services with PowerShell, I presented you the first step of the SQL Server administration through an automated process. This blog is a follow-up of the previous one, and it will focus on retrieving information of a SQL Server instance with PowerShell Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your…

Read More
Nathan Courtine

Get SQL Server services with PowerShell

By | Database management | 2 Comments

SQL Server Configuration Manager and SQL Server Management Studio are the main tools to administrate the components of SQL Server. They are very convenient to use and pretty complete. But as soon as you wish an automated process, these tools have their limitations. Nevertheless, there is still the solution: PowerShell! This blog introduces a first step towards an automation process of SQL Server administration. I will retrieve all SQL Server services related to a specific…

Read More
Stéphane Haby

SQL Server – Change Management: list all updates

By | Database management | One Comment

I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this blog to remind you in a little introduction the different types of patches for SQL Server: Service Pack Service Pack, known as SP is big set of Hotfixes. The particularity is that the regression is fully tested and sometimes…

Read More
Stéphane Savorgnano

How to avoid Failover Cluster with PowerShell scripting

By | Application integration & Middleware | No Comments

One of my colleague asked me some days ago if I could create a PowerShell script to get rid from Windows Server Failover Cluster. The reason is that it has, in some specific cases, the bad habit to failover a resource or a service even when we don’t want it. To be honest, I use a lot the Failover Cluster feature of Windows Server without any problems as a SQL Server DBA, but for this specific…

Read More
Stéphane Haby

SQL Server 2012: Configuring your TCP Port via Powershell

By | Database management | 10 Comments

Changing the default TCP port 1433 for SQL Server is an important step for securing your SQL Server. I have written a script in PowerShell to modify the port number that helps me perform this task. This blog posting will show you how to do it. Please note that the code in this article is for SQL Server 2012 on Windows Server 2012. Initialization Run SQLPS to launch the SQL PowerShell in a command prompt. First…

Read More