Grant access to Azure SQL PaaS
When you need to grant access to Azure SQL PaaS database, you can use following T-SQL scripts.
- Hits: 13490
Executable or batch-file as service in Windows with Powershell DSC
In case if you ever need to create Windows service from an executable or even bat-file, please feel free to use the following configuration in Powershell DSC.
The solution based on the NSSM software which is very similar to srvany.exe (from Windows 2003 Kit). The main difference NSSM from srvany - is that srvany does not close the underlying process if the service is stopped. And NSSM does close it. Download NSSM.
- Hits: 6470
How to unzip big archives in Powershell DSC configurations
If you ever need to unzip BIG archive files in Powershell DSC configurations (during deployment some software), you will possibly get stuck, because using Archive resource is not suitable for this task as it is very slow. xArchive also will not help.
One possible solution is to unzip it with 7zip or some other command line utility using WindowsProcess resource, but be warned that WindowsProcess will just start the process and then will go to the next instruction in your configuration. See the example:
- Hits: 5764
Save Powershell-console output to text file
Sometime it's very difficult to find error in Powershell script, especially if script is running in some dedicated session, for example, under SYSTEM account. There will be errors but you'll never know about them.
That's why I started to search a way to log output from Powershell-console to file. Here is the solution.
- Hits: 14882
Error "Get-PowerCLIVersion : The term 'Get-PowerCLIVersion' is not recognized as the name of a cmdlet, function, script file, or operable program." while starting VMware vSphere PowerCLI
Sometimes the following error appear while starting VMware vSphere PowerCLI:
Get-PowerCLIVersion : The term 'Get-PowerCLIVersion' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1:38 char:12 + $version = Get-PowerCLIVersion + ~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (Get-PowerCLIVersion:String) , CommandNotFoundExce ption + FullyQualifiedErrorId : CommandNotFoundException
- Hits: 16749
Search and\or delete messages in mailboxes in Exchange 2010/2013/2016
As soon as all messages of Exchange users are stored in database, we can perform search and, if needed, delete operations against messages. It is needed in some cases for example, when employee sent message with confidentional information to the wrong recipient or you just need to find some message and look into it... there can be a lot of options.
What Exchange 2010/2013/2016 can offer to us in such cases? We can search mailboxes (all or any specific) in database and copy search results into some other mailbox. If needed, we also can delete search results from the source mailboxes.
- Hits: 5032
Windows 7/2008/R2/8/8.1 continuously loading into Recovery Mode
Not so long ago I have rebooted one of my Windows 2008 R2 servers, and after that it no longer booted. I used I think all ways to boot it (Last known good configuration, Safe mode, Disable signed drivers check) - server everytime booted into Recovery mode.
Here is the list of commands that could help you in such cases.
- Hits: 2268
More Articles …
Page 3 of 13