How to check what features are installed on your SQL environment

When you need to know more information about your SQL environment or cluster, you can check every SQL server separate from each other. This is time consuming to do, definitely if you have a big SQL cluster or environment.

You can use also automate this steps, to use this very simple command!

Go to your SQL environment and browse to the following directory (it depends per SQL version)
* SQL Server 2012 (110)
* SQL Server 2014 (120)
* SQL Server 2016 (130)
* SQL Server 2017 (140)
* SQL Server 2019 (150)
’%programfiles%\Microsoft SQL Server\110\Setup Bootstrap\SQL2012” from the command prompt. Run the command:
’setup.exe /ACTION=RunDiscovery’

By default, there will be created a new file called ‘Summary.txt’, with the configuration of your SQL environment, cluster or AOAG if you’re using Always-On Availability Groups.. Not very usefull and readable. Not very readable, so now Powershell comes in!

Start Powershell and run the following command:
Get-Content “<location of your summary.txt file>. Now you get a report!!

2021-02-26_10h06_15   2021-02-26_10h07_262021-02-26_10h07_50   2021-02-26_10h09_15

Free ebook ‘Azure for Architects’

Do you want to know all the ins and outs about cloud computing. What is the cloud? What is Azure? What kind of functionalities and concepts are available within this cloud?

cloud_1220

You’ll find all  the answers in this great free ebook ‘Azure for Architecs’.

Download the free ebook here.

SysAdmin Horror Stories – FREE eBook

clip_image002

Last year’s ebook, SysAdmin Horror Stories Vol1 by Altaro, highlighted some of SysAdmins’ funniest and most horrifying stories. It proved so successful, that Altaro decided to produce a second edition this year: they’ve gathered some more real-life stories to share with you, that are both funny and horrific!

We all know that a SysAdmin’s job is no easy task, and apart from constantly having systems to update, bugs to fix and users to please, SysAdmins encounter all sorts of situations throughout their careers. From tech situations to funny anecdotes, terrible mishaps or incidents with colleagues, this eBook includes real stories of what SysAdmins go through on a daily basis.

It’s very easy to download as no registration is required. Click on Download and it’s yours. It includes more than 20 short stories but this one is my personal favourite .

clip_image002[5]

Download your FREE copy today & Happy Halloween!clip_image004

Microsoft Ignite 2020 Digital Swag Kit

During the Microsoft events, especially Microsoft Ignite, we’ all collect as much as possible swag. Like t-shirts, stickers and other things. During this online Microsoft Ignite event, we can’t collect some swag.

BUT….Microsoft has created a digital swag kit, including cool wallpapers, Teams background, social media stickers, your digital badge and even some great things for the kids.

You can download the digital swag kit here.

MS Ignite_Teams background1    MS Ignite_Teams background2

MS Ignite_Teams background3    MS Ignite_Teams background6

2020-09-23_19h39_43

2020-09-23_19h40_32

Microsoft Ignite 2020 ‘Book of news’

Yesterday, the biggest Microsoft event in the world has started, Microsoft Ignite 2020! This year, it’s completely digital and online!

If you’re not going to watch all the sessions, but you only want to know all the new announcements, start reading the ‘Book of news’. This document will give you an overview of all the new stuff. Happy reading!

Download the Book of news.

Microsoft Ignite 2020 Keynote

Enable Accelerated Networking using Azure Cloud Shell

What is Accelerated Networking?

Accelerated Networking provides consistent ultra-low network latency via Azure’s in-house programmable hardware and technologies such as SR-IOV. By moving much of Azure’s software-defined networking stack off the CPUs and into FPGA-based SmartNICs, compute cycles are reclaimed by end user applications, putting less load on the VM, decreasing jitter and inconsistency in latency.

Please double check the supported operating systems and VM sizes in the following documentation links to check the availability of this feature.

In 3 simple steps, we will learn to enable accelerated networking to an existing VM using Azure Cloud Shell (within the Azure Portal). Execute the following steps.

  1. First stop/deallocate the VM

    • az vm deallocate –resource-group myRG –name myVM
  2. Once stopped, enable Accelerated Networking on the NIC of your VM:

    • az network nic update –name myNic –resource-group myRG –accelerated-networking true
  3. Restart your VM. It’s that simple, isn’t it?

    • az vm start –resource-group myRG –name myVM