Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SQL Server Unit Testing: tSQLt and SQLCop
https://github.com/tSQLt-org/tSQLt
https://github.com/red-gate/SQLCop/
-
Office 365 Login "More information required"
The reason it is prompting this is because of the self service password reset setting in Azure Active Directory being turned on. If the user has no additional information to reset their password, … more
-
Azure Active Directory Smart Lockout
https://docs.microsoft.com/en-us/azure/active-directory/authentication/howto-password-smart-lockout more
-
SQL Server Memory Consumption by Object
https://www.sqlserverscience.com/performance/memory-consumption-by-object/ more
-
Microsoft Graph Explorer
https://developer.microsoft.com/en-us/graph/graph-explorer
-
An Intro to SQL Window Functions
https://www.toptal.com/sql/intro-to-sql-windows-functions more
-
Different ways to make a table read only in a SQL Server database
https://www.mssqltips.com/sqlservertip/2711/different-ways-to-make-a-table-read-only-in-a-sql-server-database/ more
-
Office 365 Get access to and back up a former user's data
https://docs.microsoft.com/en-gb/office365/admin/add-users/get-access-to-and-back-up-a-former-user-s-data?view=o365-worldwide more
-
Automatically Running Stored Procedures at SQL Server Startup
https://www.mssqltips.com/sqlservertip/1574/automatically-running-stored-procedures-at-sql-server-startup/ more
-
Problems signing in to an application from the access panel
https://docs.microsoft.com/en-us/azure/active-directory/manage-apps/application-sign-in-other-problem-access-panel more
-
SQL: How an OR Short Circuits
https://sqlstudies.com/2019/06/17/its-interesting-how-an-or-short-circuits/ more
-
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
https://jasonbrimhall.info/2019/06/13/get-the-source-of-preemptive_os_pipeops-waits/ more
-
SQL and NULL Mistakes
https://www.red-gate.com/hub/product-learning/sql-prompt/the-null-mistake-and-other-sql-null-heresies more
-
Simple script to backup all SQL Server databases
https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ more
-
Identity function tutorial in SQL Server
https://www.sqlshack.com/overview-of-identity-functions-in-sql/ more
-
Querying Temporal Tables
https://www.sqlservercentral.com/articles/querying-temporal-tables more
-
Tracking Azure Costs with Cost Management
https://www.sqlshack.com/tracking-azure-costs-with-cost-management/ more
-
SQL SERVER CONTAINERS
https://www.scarydba.com/2019/06/17/sql-server-containers-are-boring/ more
-
Does the case expression short circuit
https://sqlstudies.com/2019/06/13/does-the-case-statement-short-circuit/ more
-
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
https://blog.sqlauthority.com/2019/06/03/sql-server-fix-msg-15274-access-to-the-remote-server-is-denied-because-the-current-security-context-is-not-trusted/ more