Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
Word searching/matching in SQL Server
Read more: Word searching/matching in SQL ServerThis is a sample of how to match strings which are not exact and have a different order of words. Usually the strings have similar…
-
Using class library in SSIS Projects without GAC installation
Read more: Using class library in SSIS Projects without GAC installationI don’t want to add custom assembly in GAC. Here is my research. There is no direct way to do that from integration services packages,…
-
The transaction log for database ‘SampleDb’ is full due to ‘LOG_BACKUP’.
Read more: The transaction log for database ‘SampleDb’ is full due to ‘LOG_BACKUP’.The ETL process worked fine for the last 3 days. Today it started failing. The reason, Log_Backup. The database was in Full recovery mode and…
-
Using SSIS to pull data in chunks from remote server
Read more: Using SSIS to pull data in chunks from remote serverRecently I hit by server memory issue while running SSIS package. I was getting binary data from remote server but the production server was unable…
-
SSIS Package Performance and Timeout Exception
Read more: SSIS Package Performance and Timeout ExceptionRecently I deployed a package to production and started getting this error; After doing some research I found this; SQL Server remote query timeout default…
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.