Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SQL Server: Get Operating System Information with TSQL
SELECT windows_release, windows_service_pack_level, windows_sku, os_language_version FROM sys.dm_os_windows_info
exec master..xp_cmdshell 'systeminfo'
SELECT @@version
exec xp_msver more
-
SQL Server Performance Tools
https://blog.sqlauthority.com/2019/05/08/sql-server-how-do-i-evaluate-monitoring-tools/ more
-
Azure virtual machine rollback
https://stackoverflow.com/questions/45014625/azure-virtual-machine-rollback
https://azure.microsoft.com/en-au/blog/an-easy-way-to-bring-back-your-azure-vm-with-in-place-restore/
https://docs. … more
-
Free SQL Azure Database
There used to be a free tier for SQL Azure Database, as well as a free web app tier. But now the free SQL Azure Database tier seems to have disappeared.
https://renouncedthoughts.wordpress.com/201 … more
-
Rename Azure Username with Powershell
https://docs.microsoft.com/en-us/powershell/module/msonline/set-msoluserprincipalname?view=azureadps-1.0 more
-
Managing Always Encrypted Locally Stored Certificates in PowerShell
https://www.sqlservercentral.com/articles/managing-always-encrypted-locally-stored-certificates-in-powershell
-
Removing an Office 365 Tenancy
http://www.tecfused.com/2018/10/removing-an-office-365-tenancy/ more
-
Migrating existing domains between two Office 365 tenants
https://medium.com/@hamza.hassoun/migrating-existing-domains-between-two-office-365-tenants-2b5ba6ef2a66 more
-
Onedrive Explorer and Cloud Storage Integration
https://www.airexplorer.net/en/
https://github.com/RaiDrive/Translation
https://www.raidrive.com/
https://docs.microsoft.com/en-gb/windows/desktop/shell/integrate-cloud-storage
-
Setup FTP on Microsoft Azure
https://blog.bitscry.com/2018/08/21/creating-an-ftp-site-in-azure-with-azure-storage-file-share/
-
SQL Server Migration Assistant and Exceptions in Functions
https://www.dbbest.com/blog/exception-sql-server-udf/
http://migration572.rssing.com/chan-6919524/all_p1.html
-
Run stored procedures in parallel
https://dba.stackexchange.com/questions/173265/run-stored-procedures-in-parallel
-
Upload Files to Onedrive Programmatically with Powershell
https://techcommunity.microsoft.com/t5/Office-365/How-to-uploads-files-to-OneDrive-for-Business-using-Powershell/td-p/136332
https://gcits.com/knowledge-base/transfer-users-onedrive-files-another- … more
-
Convert Office 365 Guest to Member Using Powershell
Start Powershell
>Connect-AzureAD
>Get-AzureADUser -SearchString [email protected] | Set-AzureADUser -UserType member more
-
Office 365 Assigning Licenses to Guest Users
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/51b14e7f-1d71-4dec-88fb-410d8be04e06/why-i-cant-authorize-guest-users?forum=WindowsAzureAD
https://blogs.perficient.com/2014/11/25/office-365- … more
-
Debugging SQL Server – Setting Up Windows Debugger by Amit Bansal
https://www.youtube.com/watch?v=h6tCva6oHio&feature=youtu.be&fbclid=IwAR1C08Nj1HTV_1lLKWPtL0xziPzDz0oqRWoybFY4LlgDIGpOtg90cb7Nat8
https://developer.microsoft.com/en-us/windows/downloads/windows-10- … more
-
SQL Server: Datefirst Setting For Determining Day of Week Number
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-datefirst-transact-sql?view=sql-server-2017 more
-
MS SQL Server - How to get Date only from the datetime value
https://tableplus.io/blog/2018/09/ms-sql-server-how-to-get-date-only-from-datetime-value.html
-
SQL Server TSQL Else if Syntax
http://dba.fyicenter.com/faq/sql_server/IF_ELSE_IF_ELSE_Statement_Structures.html more
-
SQL Server Format Function
https://database.guide/3-ways-to-get-the-month-name-from-a-date-in-sql-server-t-sql/ more