Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
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;
-
SQL Server database backup restore on lower version
Read more: SQL Server database backup restore on lower versionHow to restore a higher version SQL Server database backup file onto a lower version SQL Server? We can use functionality called Export Data-Tier Application which generates .bacpac file…
-
SQL Query to get server IP address
Read more: SQL Query to get server IP addressHere is how; Reference https://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address#:~:text=To%20do%20this%2C%20create%20a,ll%20get%20the%20IP%20address.
-
SQL Temp Table Drop/Create
Read more: SQL Temp Table Drop/CreateThis is a tip to drop/create temp tables in Stored Procedures;
-
How to embed a Power BI Report Server report into an ASP.Net web application
Read more: How to embed a Power BI Report Server report into an ASP.Net web applicationEvery once in a while, teams from different functional areas of the business (i.e. business intelligence, software development, web development etc.) would join forces to…
RECENT POSTS
-
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
-
Why the Cloud & Integration Engineer Role Is AI-Resilient
-
Azure Tenant vs Subscription vs Landing Zone (Plain English Guide)
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 power bi powershell 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.