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!!
Microsoft released an update in the Windows App Store for their Server Posterpedia App, including the new Hyper-V 2012 R2 posters and some design changes.
Server Posterpedia is an interactive app that uses technical posters as a reference for understanding Microsoft technologies. This app includes all the reference posters from different Microsoft Server Technologies such as Windows Server 2012 Hyper-V, Exchange or Windows Azure. The great thing about this App, you can not only checkout the different posters and zoom in, if you click on a specific topic for you get directly linked to the right TechNet article. This can help find some TechNet references really easy and fast.
Download the Posterpedia App in the Windows Store.
Today I want to edit an task sequence within SCCM 2012 and I received the following error message: “Cannot edit the object, which is in use by site P01”. Mmmm….that’s strange!! I’m the only Sysadmin with an ConfigMgr 2012 Management Console. To unlock this object, I’ve used an query within SQL.
1.) Open the SQL Management Console and navigate to the ConfigMgr database
2.) Open a new query
3.) To view all the locked objects, type the following query:
select * from SEDO_LockState
Execute the query and watch te results
4.) We see one object that is locked
5.) Note the ID of this specific object
6.) To unlock this object, type the following query:
delete from SEDO_LockState where ID=’ID of the object’
Execute the query and watch the results
7.) Now the object is succesfully unlocked and you’re able to edit the task sequence
Yesterday and today I passed the 70-246 and 70-247 exams! Right now I’m officially Microsoft Certified Solutions Expert 2012 Private Cloud (MSCE 2012). After a couple of months preperation, reading books, reading blogpost and building, building and again building some lab environments, the big day was there!! After two hours, I hit the the final button….YES, passed the first exam! Today I also passed the second exam!
With the upcoming TechEd Europe 2013 event in Madrid, it’s a great timing to have the MSCE 2012 Private Cloud status in the pocket. Do you know where I’m going to dream about this night….right, my own private cloud!! 😉
A new feature within Windows 8 is Client Hyper-V. So within our Client OS you can run Hyper-V, that’s cool!! When you want to copy and paste some text, for example a script, this is not that easy as drag and drop or copy/paste! Is it possible? Yes, absolutely!!
The thing you need to do is copy the text on your local system, navigate back to your quest machine (VM), select the clipboard tab and hit Type clipboard text. Now you text is copied from the local machine into your quest machine!
A copple of months ago I have configured a new Citrix XenApp 6.5 with RES Workspace Manager 2012 environment. Within this environment I have configured mandatory profiles, added to Workspace Manager as a custom resource.
When the user are opening some documents, the Recent Files folder is filled up with the last opened document. The save location is C:\Users\%username%\AppData\Roaming\Microsoft\Windows\Recent.
I’ve created a new User Setting to save the content within this folder. Now there is something strange happening!! The content is saved within a UPF (User Preference File) correctly, but its not vissible in the user session from the start menu.
When I open a commandline and browse to my user profile, the content is there! Huh…?!? After some troubleshooting, I have figured out that I had to change one setting within my custom resource. The folder AppData\Microsoft\Windows\Recent was marked as Read-Only. That’s the problem! After disabling the Read-Only, the recent files are vissible from my start menu.