Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SETTING UP EMAIL ON A DOMAIN WITH CLOUDFLARE
https://blog.aaronhktan.com/posts/2018/04/14/setting-up-email-on-a-domain-with-cloudflare more
-
Cloudflare Ports
https://support.cloudflare.com/hc/en-us/articles/200169156-Which-ports-will-Cloudflare-work-with-
https://blog.cloudflare.com/cloudflare-now-supporting-more-ports/
https://www.cloudflare.com/en-au/ … more
-
SQL Server Ports: Configure a Server to Listen on a Specific TCP Port
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-2017 more
-
Setup Multiple Public IPs on a VM in Azure
https://blogs.technet.microsoft.com/canitpro/2017/03/15/step-by-step-setup-multiple-public-ips-on-a-vm-in-azure/
https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-multiple-ip- … more
-
A C# toolkit for writing SSIS Script Tasks
https://www.sqlservercentral.com/articles/a-c-toolkit-for-writing-ssis-script-tasks more
-
SQL Server: TSQL Select Into with Identity
SELECT IDENTITY(INT,1,1) AS ID,* INTO NewTable FROM ExistingTable more
-
Windows 2019 Server: Unexpected Shutdown event tracker on every reboot
Apparently it is a bug with an update - https://social.technet.microsoft.com/Forums/windowsserver/en-US/c543eed6-f647-4563-85ce-8e72d1b36a85/shutdown-event-tracker-keeps-appearing-after-installing-kb4 … more
-
Allow SQL Server Agent jobs management for non sysadmins
https://www.sqlservercentral.com/blogs/allow-sql-server-agent-jobs-management-for-non-sysadmins more
-
Visual Studio Community Edition: Who Can't Use It
https://spreadsheeto.com/visual-studio-community/ more
-
SQL Server: Temporary Stored Procedures
https://www.sqlservercentral.com/blogs/temporary-stored-procedures more
-
SQL Server: Enforce Encrypted Connections
To configure SQL Server to use a self-signed SSL certificate, follow below steps:
Create a self-signed certificate
Set permissions for this certificate
Configure SQL Server to use this … more
-
SQL Server Logon Trigger Examples
https://www.mssqltips.com/sqlservertip/6103/sql-server-logon-trigger-examples/ more
-
SQL Server Unit Testing: tSQLt and SQLCop
https://github.com/tSQLt-org/tSQLt
https://github.com/red-gate/SQLCop/
-
Office 365 Login "More information required"
The reason it is prompting this is because of the self service password reset setting in Azure Active Directory being turned on. If the user has no additional information to reset their password, … more
-
Azure Active Directory Smart Lockout
https://docs.microsoft.com/en-us/azure/active-directory/authentication/howto-password-smart-lockout more
-
SQL Server Memory Consumption by Object
https://www.sqlserverscience.com/performance/memory-consumption-by-object/ more
-
Microsoft Graph Explorer
https://developer.microsoft.com/en-us/graph/graph-explorer
-
An Intro to SQL Window Functions
https://www.toptal.com/sql/intro-to-sql-windows-functions more
-
Different ways to make a table read only in a SQL Server database
https://www.mssqltips.com/sqlservertip/2711/different-ways-to-make-a-table-read-only-in-a-sql-server-database/ more
-
Office 365 Get access to and back up a former user's data
https://docs.microsoft.com/en-gb/office365/admin/add-users/get-access-to-and-back-up-a-former-user-s-data?view=o365-worldwide more