Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
Workaround: SQL Server 2012 – OPENROWSET on sp_help_job throws "The metadata could not be determined"
https://blogs.msdn.microsoft.com/sqlagent/2012/07/12/workaround-sql-server-2012-openrowset-on-sp_help_job-throws-the-metadata-could-not-be-determined/
https://dba.stackexchange.com/questions/177861/ … more
-
Hamachi LogMeIn Find VPN Host IP Address
https://secure.logmein.com/central/Central.aspx
select Computers from left menu
then select properties for the host in question
The IP address will be shown (this corresponds to the Instance IP … more
-
VPN Ports
https://blogs.technet.microsoft.com/rrasblog/2006/06/14/which-ports-to-unblock-for-vpn-traffic-to-pass-through/
https://www.youtube.com/watch?v=m_wwqspLJSM more
-
Find Credentials in Windows
rundll32.exe keymgr.dll,KRShowKeyMgr
-
Autonomous Transactions in SQL Server
https://www.dbbest.com/blog/autonomous-transactions-sql-server/
https://stackoverflow.com/questions/45731207/commit-transaction-outside-the-current-transaction-like-autonomous-transaction
-
The target principal name is incorrect. Cannot generate SSPI context
https://blogs.msdn.microsoft.com/meer_alam/2015/05/10/the-target-principal-name-is-incorrect-cannot-generate-sspi-context/ more
-
Securing Web Services
http://www.c-sharpcorner.com/UploadFile/8ef97c/web-service-in-Asp-Net-security-by-soap-authentication-pa/
https://forums.asp.net/t/2111585.aspx?How+to+secure+a+web+service+
https://www.asp.net/web- … more
-
Importing XML into SQL Server
https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/
https://docs.microsoft.com/en-us/sql/relational-databases/import-export/examples-of- … more
-
The server network address “TCP://SQLServer:5023” can not be reached or does not exist.
The server network address “TCP://SQLServer:5023” can not be reached or does not exist. more
-
How to use REPLACE() within NTEXT columns in SQL Server
select cast(replace(cast(myntext as nvarchar(max)),'find','replace') as ntext)from myntexttable more
-
Create Hard Link in Windows at Operating System Level to Point to a Different Hard Drive
mklink /J c:\ProgramData e:\ProgramData2 more
-
How To Set Up FTP on Windows Azure
How To Set Up FTP on Windows Azure more
-
Purge Cloudflare Cache
https://support.cloudflare.com/hc/en-us/articles/200169246-How-do-I-purge-my-cache- more
-
Reset Password for Orchard CMS
1) In the table [Orchard_Users_UserPartRecord], change the Password field to a new password of your choosing and then PasswordFormat to Clear.
2) Do the same for the related record in the table [ … more
-
Disable Windows 2016 Automatic Updates
This can be controlled via command line: sconfig.cmd
Or by hacking the registry:
https://www.reddit.com/r/sysadmin/comments/57e184/windows_server_2016_updates_and_automatic_reboots/?st=j4rz0i6n&sh=0 … more
-
Creating a WIMP Stack (Windows Server, IIS, MySQL, PHP) on Windows Azure
Creating a WIMP Stack (Windows Server, IIS, MySQL, PHP) on Windows Azure more
-
Multiple Web Servers on Same Machine
https://www.devside.net/wamp-server/running-iis-and-apache-together-on-the-same-server-at-the-same-time more
-
Set Default Document on IIS
On IIS Manager select your page in the Sites tree.
Double click on configuration editor.
Select system.webServer/defaultDocument in the drop-down at the top of the page.
Change the "default.aspx" … more
-
Install PHP on Windows and IIS
https://www.itnota.com/install-php-windows-web-platform-installer/
http://www.ryadel.com/en/how-to-install-php-manager-for-iis-on-windows-server-or-windows-10/ more
-
.Net Core Downloads
https://www.microsoft.com/net/download/core more