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:
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!!
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?
You’ll find all the answers in this great free ebook ‘Azure for Architecs’.
Download the free ebook here.
Microsoft Ignite 2012 wil be held on 2-4 March 2021. Just like last year, this event will be fully digital!!
I’m really looking forward to visit this digital event.
MyIgnite – Your home for Microsoft MyIgnite
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 .
Download your FREE copy today & Happy Halloween!
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.
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.
Today, MIcrosoft Ignite 2020 is started. This year it is a completely digital event. One cool thing to do every Microsoft Ignite event, is taking the selfie. This year available also the digital way! Check it out!
Always cool to make a selfie!!
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.
First stop/deallocate the VM
- az vm deallocate –resource-group myRG –name myVM
Once stopped, enable Accelerated Networking on the NIC of your VM:
- az network nic update –name myNic –resource-group myRG –accelerated-networking true
Restart your VM. It’s that simple, isn’t it?
- az vm start –resource-group myRG –name myVM