Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SQL Server Find Object Dependencies
https://docs.microsoft.com/en-us/sql/relational-databases/tables/view-the-dependencies-of-a-table?view=sql-server-2017#TsqlProcedure
https://www.mssqltips.com/sqlservertip/2999/different-ways-to- … more
-
Certificate Warning for Remote Desktop Connection
https://stackoverflow.com/questions/20686361/how-to-ignore-the-certificate-warning-on-remote-desktop-connection
-
SQL Server Scalar Functions
https://www.red-gate.com/simple-talk/sql/sql-training/tsql-user-defined-functions-ten-questions-you-were-too-shy-to-ask/#fifth more
-
Microsoft Windows Azure Virtual Machine Tutorials
https://docs.microsoft.com/en-au/azure/virtual-machines/windows/index
-
Multiple Session RDP
https://github.com/stascorp/rdpwrap/
http://woshub.com/how-to-allow-multiple-rdp-sessions-in-windows-10/
-
SQL Server Contained Databases
https://mssqlexperiments.wordpress.com/2014/01/04/contained-database-concepts-and-experiments/ more
-
Multiple Remote Desktop RDP Sessions
https://social.technet.microsoft.com/Forums/ie/en-US/c52b6da7-cdf2-4e1f-95d1-6471c6f2f6b0/easiest-way-to-enable-more-than-2-concurrent-rdp-sessions-on-windows-server-2016?forum=winserverTS
-
SQL Server: Troubleshoot xp_cmdshell
http://www.sqlpanda.com/2011/10/trouble-shooting-xpcmdshell.html
https://www.techtalkz.com/threads/granting-xp_cmdshell-permission-to-sql-login.190618/
-
SQL Server: Query the System Catalog
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/querying-the-sql-server-system-catalog-faq?view=sql-server-2017
https://dataedo.com/blog/useful-sql-server-data- … more
-
Visual Representation of SQL Joins
https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
-
Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"
To work around this problem, open a command prompt, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"
Note … more
-
SQL: Merge Statement
https://stackoverflow.com/questions/14806768/sql-merge-statement-to-update-data more
-
FTP SSL Using .Net
https://www.codeproject.com/Questions/193443/FTP-SSL-using-NET
-
SQL Server: Deleting Files with TSQL
http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx
https://stackoverflow.com/questions/43269779/how-to-delete-files-on-the-directory-via-ms-sql- … more
-
SQL: Using NOT IN Operator with NULL Values
http://www.sqlbadpractices.com/using-not-in-operator-with-null-values/
-
Virtual Desktops on VDI
https://www.youtube.com/watch?v=Ab2wWCGgmTk more
-
Steps to Create Point-to-Site VPN using Azure Portal
https://www.assistanz.com/steps-to-create-point-to-site-vpn-using-azure-portal/
-
SQL Server Execute Stored Procedures in Parallel
https://www.codeproject.com/Articles/67499/Execute-Stored-Procedures-in-Parallel
http://www.sql-server-performance.com/forum/threads/asynchronous-execution-multithreaded.13249/
https://dba. … more
-
Find and List All Listening Ports Using Command Line in Windows
netstat -a | findstr -i "listen"
-
Add Administrators to Azure Subscription
https://docs.microsoft.com/en-us/azure/billing/billing-add-change-azure-subscription-administrator