Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
Python vs Powershell
https://www.sqlshack.com/overview-python-vs-powershell-sql-server-database-administration/
https://ridicurious.com/2018/03/30/powershell-scripting-guide-to-python-part1/
https://www.sqlshack.com/ … more
-
Sending Email with Python
http://naelshiab.com/tutorial-send-email-python/
https://docs.python.org/2/library/email-examples.html
-
SQL Server And Python
https://www.mssqltips.com/sqlservertutorial/9073/sql-server-2017-and-python-basics/
https://www.sqlshack.com/get-python-sql-server-2017/
https://wiki.python.org/moin/SQL%20Server
https://blogs. … more
-
SQL Server Autonomous Transaction Within View
/* create a function that inserts to a table via xp_cmdshell */
CREATE FUNCTION dbo.fn_write_to_table()
RETURNS int
AS
BEGIN
DECLARE @sql varchar(MAX), @cmd varchar(4000)
SELECT @sql = ' … more
-
SQL Server 2016: Natively Compiled User-Defined Functions (UDFs)
https://blog.learningtree.com/sql-server-2016-natively-compiled-user-defined-functions-udfs/
-
SQL Server: Show Row Number
select ROW_NUMBER() over (order by (select 1)) as rownum, * from sys.all_objects
-
Creating Native Web Services in SQL Server (Now Deprecated)
https://www.codeproject.com/Articles/195508/Consuming-a-Web-Service-created-through-Sql-Server
https://dba.stackexchange.com/questions/159755/how-to-create-soap-endpoint-in-sql-server-2016
https:// … more
-
Web Service Testing
https://www.getpostman.com/
https://www.wireshark.org/
https://archive.codeplex.com/?p=webservicestudio
http://blog.getpostman.com/2014/03/07/writing-automated-tests-for-apis-using-postman/
https: … more
-
Windows Server 2016: Reset Filesystem Permissions on a Folder
Open a command window, and Run As Administrator:
takeown /F "Full Path of Folder or File"
takeown /F "Full Path of Folder or File" /r /d y
icacls "Full Path of Folder or File" /grant … more
-
Python Copy File Command
from shutil import copyfile
copyfile('C:\\mydirectory\\myfile.txt','F:\\myfile.txt') more
-
Python Programming with .Net
http://ironpython.net/
-
Backup Up SVN Repositories
SVN hotcopy or dump can be used:
svnadmin hotcopy C:\dev\svn-1.6.6\repository \\SEQUOIA\svn-ultor-backup\repo1\hotcopy\repository-backup
svnadmin dump C:\dev\svn-1.6.6\repository > C:\dev\svn-1.6. … more
-
GDPR Protection Module for Orchard CMS
https://github.com/Lombiq/Orchard-Privacy
-
Outlook.com Customization
https://www.howto-outlook.com/howto/outlookcompersonaladdress.htm
-
Office 365 External Guest Users
https://blogs.technet.microsoft.com/projectsupport/2017/12/29/project-online-assigning-licenses-to-guest-users-with-powershell/
https://www.petri.com/adding-subscription-external-office-365-user … more
-
Sharepoint Templates
https://www.linkedin.com/pulse/20141024162836-208008284-templates-needed-for-sharepoint-2013-foundation
https://blogs.technet.microsoft.com/praveenh/2010/12/17/fantastic-40-application-templates-for- … more
-
Install SharePoint Foundation 2013 on Windows Server 2016 Solution
http://roger.dilsner.com/install-sharepoint-foundation-2013-windows-server-2016-solution/
-
SoftEther VPN Automatic Connection on Restart
https://www.softether.org/4-docs/1-manual/4._SoftEther_VPN_Client_Manual/4.4_Making_Connection_to_VPN_Server#4.4.19_Startup_Connection
-
Windows Azure and Transferring Data with Azcopy
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy
https://docs.microsoft.com/en-us/azure/storage/common/storage-moving-data
-
Optimize network throughput for Azure virtual machines
https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-optimize-network-bandwidth