Author: Shahzad Khan
-
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…
-
DNS – NSLOOKUP what is the meaning of the non-authoritative answer?
Read more: DNS – NSLOOKUP what is the meaning of the non-authoritative answer?Non-authoritative answer simply means the answer is not fetched from the authoritative DNS server for the queried domain name. First you have to understand how…
-
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
-
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)
-
Building a FinOps Cost Intelligence Dashboard on Azure: From Raw Data to Operational Insight
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 c# containers css datatables design pattern docker excel framework Git HTML JavaScript jQuery json knockout lab LINQ linux power bi 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.