Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
Cross Apply and Outer Apply
Read more: Cross Apply and Outer ApplyMicrosoft has introduced APPLY operator in SQL Server 2005. It allows joining between two table expressions, for example joining left/outer table expression with right/inner table…
-
C# component to read Excel data using OleDb in SSIS
Read more: C# component to read Excel data using OleDb in SSISThis is how we can read data from Microsoft Excel using OleDb in SSIS; We need to add output columns with correct data type. There…
-
Don’t’ fail parent package if child package fails
Read more: Don’t’ fail parent package if child package failsI like to keep running child packages inside sequence container even if one of them fails. Currently they are failing; The work around is to…
-
SQL Date Conversion from different data types
Read more: SQL Date Conversion from different data typesWhen we receive data feed from outside vendors, the date values are often like this; The challenge is how to parse these dates and load…
-
Loading stored procedure results into tables
Read more: Loading stored procedure results into tablesThere are multiple methods that can be used to import stored procedures results into tables. OPENROWSET AND OPENQUERY methods require that stored procedures don’t have;…
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.