Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SQL Server - Grant Execute On All Stored Procedures
GRANT EXECUTE TO [MyDomain\MyUser]
https://stackoverflow.com/questions/9321334/grant-execute-to-all-stored-procedures
-
Power BI Hierarchies and Drill Down
https://www.youtube.com/watch?v=cWjLN5nH5dIhttps://www.youtube.com/watch?v=paSDOQ97VZMhttps://docs.microsoft.com/en-us/power-bi/desktop-drillthroughhttps://www.youtube.com/watch?v=2x9lLHDbtDkhttps:// … more
-
SQL Server 2012 T-SQL – EXECUTE WITH RESULT SETS
https://www.itprotoday.com/sql-server-2012-t-sql-glance-execute-result-sets
-
Introduction to PowerShell with SQL Server Using Invoke-SQLCMD
https://www.red-gate.com/simple-talk/sysadmin/powershell/introduction-to-powershell-with-sql-server-using-invoke-sqlcmd/ more
-
Copy Files Via Command Prompt
https://www.nextofwindows.com/windows-tip-how-to-copy-files-without-overwriting-them-in-command-line
-
Remote Desktop Login Error - Because of an error in data encryption, this session will end
https://social.technet.microsoft.com/Forums/windows/en-US/15ea84ae-3bff-4e19-8b28-d59313fc7e68/remote-desktop-login-error-because-of-an-error-in-data-encryption-this-session-will-end?forum=w7 … more
-
Connection SQL Server to SAS
https://www.connectionstrings.com/sas/
http://support.sas.com/documentation/cdl/en/oledbpr/63701/PDF/default/oledbpr.pdf
https://blogs.sas.com/content/sasdummy/2010/11/03/peek-at-your-data-using- … more
-
Remote Desktop Web Client
https://docs.microsoft.com/en-us/windows-server/remote/remote-desktop-services/clients/remote-desktop-web-client-admin
-
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/