Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
SQL Server basic command
Read more: SQL Server basic commandThis is a handy list of basic commands; Append a new column to table Append multiple columns to a table Create a new table
-
Insert results of SPROC into temp table
Read more: Insert results of SPROC into temp tableI would like to do something like this; SQL Server doesn’t support this and I don’t want to use OPENQUERY like this. Using OPENROWSET will…
-
SQL Server Merge Statement
Read more: SQL Server Merge StatementI have 2 tables one containing historical data using type 2 SCD (Slowly changing dimensions) called DimBrand and another containing just the latest dimension data…
-
Extract numeric values from text in SQL Server
Read more: Extract numeric values from text in SQL ServerI have this paragraph; This is a standard text where the pattern is like this; The ask is to extract Amount and Term from this…
-
SQL Server window functions
Read more: SQL Server window functionsOne of the most obvious and useful set of window functions are ranking functions where rows from the data set are ranked accordingly. There are…
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.