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…
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…
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…
SQL server 2008 has PowerShell and at the end of this article, I speak of this topic but to use correctly Powershell, you must have a basic notion about this technologie.
In microsoft Techdays in Basel, Marc van Orsouw presents Powershell.
I think it was a nice opportunity to presents you an overview of Powershell based on this
presentation with
…
