Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
SQL Server NULL or empty value checking
Read more: SQL Server NULL or empty value checkingThis is how to check NULL or empty input values for a date column. Currently NULL or empty values produces ‘1900-01-01’ value which is not…
-
Select Date between Two Date Columns
Read more: Select Date between Two Date ColumnsThis is how to run a SQL Query where you have two date columns and like to see if your date falls between those columns;…
-
SQL Method to convert to neart 1000 integer
Read more: SQL Method to convert to neart 1000 integerThis is my sample data. Values Expected Results 1.25 1 1.49 1 1.5 2 1.7 2 This is how we can achieve expected results in…
-
SQL Server Change Data Capture
Read more: SQL Server Change Data CaptureChange data capture (CDC) records insert, update, and delete activity that applies to a SQL Server table. This makes the details of the changes available…
-
Why the SQL Agent Jobs are failing after database restore
Read more: Why the SQL Agent Jobs are failing after database restoreAfter the data refresh (database restore), run this, otherwise the job would be failing;
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.