Category: Data Design
All about Azure Databases, Azure single database, Azure managed instance, Azure Cosmos database, Azure VM based databases
-
FIND AND REPLACE using Regular Expression in SSMS
Read more: FIND AND REPLACE using Regular Expression in SSMSWe can use Regular Expression to find and replace, valid with all versions of SSMS Find what: {.+} Replace with: ‘\1’, Look in: Selection Expand Find Option…
-
Updating SSIS packages for specific SQL server version
Read more: Updating SSIS packages for specific SQL server versionUpdating SSIS packages for a specific SQL server target version (valid only for SQL Server 2012 and above) Right click on a project, click properties…
-
LEAD (Next) and LAG (Previous) Analytic function
Read more: LEAD (Next) and LAG (Previous) Analytic functionSQL Server 2012 has two new analytical functions, LEAD() AND LAG(). These functions return data from Next row (LEAD) and Previous row (LAG) of the…
-
Azure SQL Database (PaaS) Backup/Restore
Read more: Azure SQL Database (PaaS) Backup/RestoreThis is tricky. Azure PaaS (Platform as Service) SQL Database has master database only. If programmer is taking any advantage of MSDB databases or synonymous,…
-
How to confirm Access Database Engine (ACE Driver) is installed on Database Server
Read more: How to confirm Access Database Engine (ACE Driver) is installed on Database ServerFollow these steps to verify Access Database Engine (ACE Driver) installation; Double check to make sure you did install the x64 version of Microsoft Access Database…
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.