Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
Email Smarthost with Office 365
https://docs.microsoft.com/en-us/exchange/mail-flow-best-practices/use-connectors-to-configure-mail-flow/set-up-connectors-to-route-mail
-
SQL Server vs SQL Azure
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
https://docs.microsoft.com/en-au/azure/sql-database/sql-database-transact-sql-information
https://ballardchalmers.com/2018/0 … more
-
Code Generation Tools
https://en.wikipedia.org/wiki/Comparison_of_code_generation_tools
-
Azure Powershell From Azure Portal
https://www.red-gate.com/simple-talk/sysadmin/powershell/azure-and-windows-powershell-getting-information/
-
Microsoft Azure Run Command (run command line or powershell from the Azure Portal)
In portal.azure.com:
1) select virtual machine
2) select Run Command
3) Choose one of the pre-written scripts (eg change rdp port, ipconfig etc)
-
Windows Firewall Enable and Disable via Command Line
This is how you do it using a command prompt:
To Turn Off:
NetSh Advfirewall set allprofiles state off
To Turn On:
NetSh Advfirewall set allprofiles state on
To check the status of Windows … more
-
Edit Windows Registry via Command Line
https://www.windowscentral.com/how-edit-registry-using-command-prompt-windows-10 more
-
Disable Microsoft Azure Guest Firewall
http://www.techkb.onl/disabling-the-windows-firewall-on-an-azure-vm-from-the-portal/
https://blogs.technet.microsoft.com/mckittrick/how-to-disable-the-guest-os-firewall-of-an-azure-vm-arm/
-
Windows Firewall Rules for File and Print Sharing
Source: http://tritoneco.com/2013/09/18/file-and-printer-sharing-firewall-rules-explained/
This article is an overview of the ports and services necessary for File and Print Sharing. File shares to … more
-
Configure Windows Firewall to Allow Pings
Open Windows Firewall
Click Advanced Settings on the left.
From the left pane of the resulting window, click Inbound Rules
In the right pane, find the rules titled File and Printer Sharing ( … more
-
Microsoft Access ADP Projects
http://www.joakimdalby.dk/HTM/ADPX.htm
-
Windows Firewall Logging
https://www.howtogeek.com/220204/how-to-track-firewall-activity-with-the-windows-firewall-log/
-
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