Tag: SQL server
-
Enable Microsoft Entra-only authentication with Azure SQL
Read more: Enable Microsoft Entra-only authentication with Azure SQLEnable Microsoft Entra-only authentication; Enable in SQL Database using Azure portal To enable Microsoft Entra-only authentication in the Azure portal, follow these steps: Enable in…
-
Changing user password for PaaS SQL Server instance
Read more: Changing user password for PaaS SQL Server instancePermissions Requires ALTER ANY LOGIN permission. If the login that is being changed is a member of the sysadmin fixed server role or a grantee of CONTROL…
-
Last Run Date on a Stored Procedure in SQL Server
Read more: Last Run Date on a Stored Procedure in SQL ServerWe starting to get a lot of stored procedures in our application. Many of them are for custom reports many of which are no longer…
-
Using varchar(MAX) vs TEXT on SQL Server
Read more: Using varchar(MAX) vs TEXT on SQL ServerThe VARCHAR(MAX) type is a replacement for TEXT. The basic difference is that a TEXT type will always store the data in a blob whereas the VARCHAR(MAX) type will attempt to store…
-
finding all stored procedures that is calling functions
Read more: finding all stored procedures that is calling functionsI would like to find all the stored procedures that has reference of Functions or called Functions from Store procedures. Here is the script;
RECENT POSTS
-
Blazor WebAssembly, JavaScript Interop, and Safari: Why I Avoid async for Navigation
-
Google is making its boldest AI move yet inside Gmail
-
OpenAI just introduced ChatGPT Health
-
Building a Practical Azure Landing Zone for a Small Organization — My Hands-On Journey
-
PowerShell Automation at Scale: Lessons from Azure Platform Operations
Categories
Tags
ADO ai angular asian asp.net asp.net core azure ACA azure administration Azure Cloud Architect Azure Key Vault Azure Storage Blazor WebAssembly BLOB bootstrap Branch and Release flow c# c#; ef core css datatables design pattern docker excel framework Git HTML JavaScript jQuery json knockout lab LINQ linux powershell REST API smart home SQL Agent SQL server SSIS SSL SVG Icon typescript visual studio Web API window os wordpress
ARCHIVE
DISCLAIMER
The information on this weblog is provided “as is,” without warranties of any kind, and confers no rights. The content reflects my personal views and does not represent the thoughts, intentions, plans, or strategies of any organization with which I am affiliated. Discussion and differing viewpoints are welcome; however, I reserve the right to moderate or remove comments that are abusive, profane, rude, or anonymous. Please keep the conversation respectful and constructive.