Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
How to get SQL Data in chunks from remote server
Read more: How to get SQL Data in chunks from remote serverOFFSET FETCH is a feature added to the ORDER BY clause beginning with the SQL Server 2012 edition. It can be used to extract a…
-
Remove all spaces from strings using sql
Read more: Remove all spaces from strings using sqlI wanted to remove following spaces and special characters from these strings; I tried to use following SQL to get rid of all spaces; Still…
-
SSIS Foreach Loop Folder as variable
Read more: SSIS Foreach Loop Folder as variableI need to set the Folder in Foreach loop to a variable location. I tried just adding the location to my package configuration, and it…
-
Drop orphan users – internal.object.permissions
Read more: Drop orphan users – internal.object.permissionsI did a database restore from development to staging. Couldn’t connect to database using user login, Adam. Selected General tab on properties by clicking on…
-
Database Isolation Levels and locking hints
Read more: Database Isolation Levels and locking hintsIs it a good idea to use table locks? Here is a list of articles that talk about this; Best practice to use locking hints
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.