appuals.com

How to Fix ‘Conversion failed when converting date and time’ in SQL Server

The “Conversion failed when converting date and/or time from character string” error in SQL Server appears when SQL Server cannot interpret a text value as a ...
GitHub

SQL Server MCP Client

See Configuring Claude Desktop / Claude Code for examples. A comprehensive Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides extensive SQL Server ...
archive

Joe Celko's SQL for smarties : advanced SQL programming

remove-circle Internet Archive's in-browser bookreader "theater" requires JavaScript to be enabled. It appears your browser does not have it turned on. Please see ...
Interesting Engineering

Creating a database from scratch: Part 1 – Understanding the basics

A database is an essential component of any modern application, providing a repository for storing and retrieving large amounts of information. Building a database can seem daunting, but it can be ...
Microsoft

Working with time series data in SQL Server 2022 and Azure SQL

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...
GitHub

Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure.

The CLR assembly in this project can only be deployed to a SQL Server with CLR enabled, and support for UNSAFE permission set. If you have SSDT, you can open the SQL server project and publish it to ...