Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SQL Server Always On Availability Groups Step By Step
https://www.sqlrx.com/steps-for-installing-sql-server-alwayson-availability-groups/
https://argonsys.com/microsoft-cloud/library/step-by-step-creating-a-sql-server-alwayson-availability-group/ … more
-
Multithreading in Powershell
https://gallery.technet.microsoft.com/scriptcenter/Multi-threading-Powershell-d2c0e2e5 more
-
Azure DNS
https://docs.microsoft.com/en-us/azure/dns/dns-delegate-domain-azure-dns
https://edi.wang/post/2019/8/9/create-a-private-dns-server-without-vm-on-microsoft-azure more
-
SQL Server Ports: How to Find
https://www.sqlshack.com/overview-of-sql-server-ports/
-
Connection Strings for SQL Server and Other Databases
https://www.connectionstrings.com/ more
-
Logging SQL Server Logins
Source:
https://www.sqlservercentral.com/blogs/has-this-login-been-used-recently
--DROP TABLE #LogInfo
DECLARE @searchstring1 nvarchar(500) = ''
DECLARE @searchstring2 nvarchar(500) = '' … more
-
Compare and Synchronize the Data of Two Databases
https://docs.microsoft.com/en-us/sql/ssdt/how-to-compare-and-synchronize-the-data-of-two-databases?view=sql-server-ver15 more
-
Windows 10 Connected Accounts (and How to Remove)
Start Menu
-> Settings
-> Accounts
-> Access work or school
+ Connect or Select Account to Disconnect more
-
Powershell Redirection
https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_redirection?view=powershell-7 more
-
Visual Studio Debugging Exceptions
https://michaelscodingspot.com/debugging-exceptions/
-
SharePoint Migration Tool
https://docs.microsoft.com/en-us/sharepointmigration/introducing-the-sharepoint-migration-tool more
-
SQL Server Express LocalDB
You can connect with SSMS or visual studio with server name:
(localdb)\MSSQLLocalDB
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql- … more
-
SQL Server Ports
Using netstat is handy to research to see if a port is in use, but for this issue it is more direct to see what SQL Server thinks is going on, and fortunately there are some views that have the info … more
-
Regaining access to SQL server after changing the domain
https://www.sqlservercentral.com/articles/regaining-access-to-sql-server-after-changing-the-domain
-
Team Foundation Server (TFS) to Azure Devops Migration
https://docs.microsoft.com/en-au/azure/devops/migrate/migrate-from-tfs?view=azure-devops
https://www.microsoft.com/en-us/download/details.aspx?id=54274
-
Create a virtual network peering - Resource Manager, different subscriptions
https://docs.microsoft.com/en-us/azure/virtual-network/create-peering-different-subscriptions#cli more
-
Microsoft Azure: What is IP address 168.63.129.16?
-
Join an Azure VM to an on-prem Active Directory
https://4sysops.com/archives/join-an-azure-vm-to-an-on-prem-active-directory/
https://superuser.com/questions/1115047/how-to-join-azure-vm-to-domain/1115229
https://serverfault.com/questions/903515/ … more
-
Install Sharepoint 2019 on Single Server
open Sharepoint Management Shell (must be Run As Administrator) and run the following cmdlet
New-SPConfigurationDatabase -DatabaseName SharePoint_ConfigDB -DatabaseServer MySQLServerInstance - … more
-
SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed
https://blog.sqlauthority.com/2019/03/04/sql-server-fix-database-diagram-error-15517-cannot-execute-as-the-database-principal-because-the-principal-dbo-does-not-exist/ more