Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
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
-
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