Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
Audit Users logging in using "sa" or service accounts
source: https://www.sqlservercentral.com/scripts/audit-users-logging-in-using-sa-or-service-accountsIF OBJECT_ID ('AuditSqlLogins') IS NOT NULL DROP TABLE AuditSqlLogins
GO
CREATE TABLE … more
-
Automate Gathering SQL Server Information and Emailing CSV File
https://www.mssqltips.com/sqlservertip/6085/automate-gathering-sql-server-information-and-cpu-count/
-
SQL Server Get Product Version and CPU Cores
SELECT @@SERVERNAME AS SQLServerName, CASE SUBSTRING(CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductVersion')),1,4) WHEN '15.0' THEN 'SQL Server 2019' WHEN '14.0' THEN 'SQL Server 2017' WHEN '13.0' … more
-
Ten SQL Commands You Should Be Using
https://www.databasejournal.com/features/mssql/ten-sql-commands-you-should-be-using.html
-
SQL Server Introduction to Statistics
-
sp_BlitzWho and SQL Server First Responder Kit
https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/dev/sp_BlitzWho.sql
-
Free Web Hosting On Github
https://gist.github.com/TylerFisher/6127328
https://pages.github.com/
https://medium.com/@svinkle/publish-and-share-your-own-website-for-free-with-github-2eff049a1cb5
http://jmcglone.com/guides/ … more
-
KB4503293 Cumulative update breaks Event Viewer Custom views
https://www.winhelponline.com/blog/windows-10-v1903-19h1-is-available-now/#eventvwr
https://www.winhelponline.com/blog/process-monitor-track-events-generate-log-file/ more
-
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