Tag: SQL Server

AI & Machine Learning / Applications / ASP.NET / C# / Cloud / Coding / Data Security / Servers & Services / Software / Tools & Utilities / Web

Harpyx: Open-Source Platform for RAG-Based Document Intelligence A practical solution to search, analyze, and query large document collections without losing control over data, infrastructure, and LLM providers

- by Ryan - Leave a Comment

Over the last few months, I've worked with several companies that were looking to use AI for something more substantial than text generation: making sense of their documents. Specifications, technical …

Harpyx: Open-Source Platform for RAG-Based Document Intelligence A practical solution to search, analyze, and query large document collections without losing control over data, infrastructure, and LLM providers Read More
AI & Machine Learning / Applications / ASP.NET / C# / Cloud / Coding / Data Security / Servers & Services / Software / Tools & Utilities / Web

UncannyPrompt: Open-Source AI Prompt Management for Teams An open-source, self-hosted platform (with a free SaaS alternative) to help teams manage their AI workflows with more control

- by Ryan - Leave a Comment

Over the last two years, prompts have become part of the daily routine of many teams working with generative AI. Not as a formal discipline, and not only in the …

UncannyPrompt: Open-Source AI Prompt Management for Teams An open-source, self-hosted platform (with a free SaaS alternative) to help teams manage their AI workflows with more control Read More
ASP.NET / C# / Cloud / Coding / Cyber Security / Data Security / Servers & Services / Web

Building Web APIs with ASP.NET Core - The Book Build fully-featured APIs with ASP.NET Core! An all-practical guide on building modern APIs utilizing REST and GraphQL standards

- by Ryan - Leave a Comment

I'm pleased to announce that my new book, Building Web APIs with ASP.NET Core, is now available for purchase in E-Book and Paperback format on all the major online stores, …

Building Web APIs with ASP.NET Core - The Book Build fully-featured APIs with ASP.NET Core! An all-practical guide on building modern APIs utilizing REST and GraphQL standards Read More
ASP.NET / C# / Cloud / Coding / Design / Servers & Services / SQL / Web

ASP.NET Core Web API - The Book A practical guide explaining how to create fully featured Web APIs with the ASP.NET Core framework using REST and GraphQL - Now available for Early Access!

- by Ryan - Leave a Comment

Today I'm proud to announce that my future book - ASP.NET Core Web API, which I'm currently writing for Manning Publications - has just reached the MEAP state! In case you …

ASP.NET Core Web API - The Book A practical guide explaining how to create fully featured Web APIs with the ASP.NET Core framework using REST and GraphQL - Now available for Early Access! Read More
Cloud / Servers & Services / SQL / Web

How to create an Azure SQL Managed Instance How to setup and configure a SQL Managed Instance on the Azure Cloud Portal: a great way to create, host and mantain SQL Databases in the cloud

- by Ryan - 2 Comments.

Providing ourselves with a SQL Managed Instance on the Azure Cloud Portal can be a great way to create, host and mantain SQL Databases in the cloud. As we most …

How to create an Azure SQL Managed Instance How to setup and configure a SQL Managed Instance on the Azure Cloud Portal: a great way to create, host and mantain SQL Databases in the cloud Read More
ASP.NET / C# / Coding / SQL / Web

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider

- by Ryan - Leave a Comment

In this article we'll see how to take advantage of Serilog, a neat open-source diagnostic logging library for .NET applications, to log our ASP.NET Core web application’s data to a …

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider Read More
Coding / SQL

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database

- by Ryan - Leave a Comment

If you've stumbled upon this post it most likely means that you need to change the type and/or format of one or more table column of a SQL Server using …

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database Read More
Coding / SQL / Windows

SQL Server - Reset the numeric counter (seed) of an Identity column How to reset the numeric value of the seed counter of an identity column with SQL Server 2002, 2005, 2008, 2008R2, 2012, 2016, 2017, 2019

- by Ryan - Leave a Comment

If you came across this article, you probably need to reset the numeric value (seed counter) of an identity column used by a table in your SQL Server database. The …

SQL Server - Reset the numeric counter (seed) of an Identity column How to reset the numeric value of the seed counter of an identity column with SQL Server 2002, 2005, 2008, 2008R2, 2012, 2016, 2017, 2019 Read More
Coding / Servers & Services / SQL / Windows

SQL Server - Call a URL using GET or POST method and fetch Status Code and Response Text How to execute a GET or POST call to an external URL within a Stored Procedure (using HTTP or HTTPS protocol) and retrieve the StatusCode and ResponseText

- by Ryan - 4 Comments.

We already talked about the MSXML2.XMLHTTP and MSXML2.ServerXMLHTTP objects in an older post: these objects provides methods and properties for server-safe HTTP access between different Web servers and can be used to exchange …

SQL Server - Call a URL using GET or POST method and fetch Status Code and Response Text How to execute a GET or POST call to an external URL within a Stored Procedure (using HTTP or HTTPS protocol) and retrieve the StatusCode and ResponseText Read More
Servers & Services / SQL / Tools & Utilities / Windows

Enable DTS Designer in SQL Server Management Studio - How to How to make the DTS Designer component for SQL Server 2000 work in SQL Server Management Studio (SSMS) 2005, 2008 and above

- by Ryan - 2 Comments.

Today I had to update a certain number of old Windows Server 2003 and Windows XP virtual machines to their Windows Server 2016 and Windows 10 up-to-date counterparts. Among the …

Enable DTS Designer in SQL Server Management Studio - How to How to make the DTS Designer component for SQL Server 2000 work in SQL Server Management Studio (SSMS) 2005, 2008 and above Read More