So much of modern programming is about string manipulation. Whether it’s parsing XML content, building HTML for the browser or trying to understand what the user just typed into that text entry field, ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...

Queries are the database equivalent of filters in a spreadsheet. Just as a filter can limit and reorganize the information displayed in a spreadsheet, so a query limits and reorganizes the information ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

SQL remains the backbone of enterprise data access. Despite the rise of dashboards, semantic layers, and AI-driven analytics, ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

A Query is a tool that retrieves data from a single table or multiple tables; it is the most powerful tool to analyze your data in Microsoft Access; Basically, a Query is just a question presented in ...