In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...

Does anyone know how, once terminal'd into a Unix box (I know very little about navigating Unix), I can execute a sql statement against the informix database installed on the system?<BR><BR>SQL Server ...

Here’s an image for you. There is no such thing as a data lake. The multi-petabyte storage racks nearly overflowing with unstructured and semi-structured data that are being built by hyperscalers, ...

In part 1, we looked at generating T-SQL style code. In part 2, let's get this thing to run! Last time, I showed how a single SELECT statement can be built to create an executable string of T-SQL.

It’s time to get off Windows and SQL Server 2012 (or run them on Azure) Your email has been sent The release of Windows Server 2022 is a good reminder that older ...

I have a 2014 15” MacBook Pro that I’m looking to replace sooner or later with an equivalent M1 MacBook Pro (most likely the 14”). However, one big holdup is that for my day job, I run Visual Studio ...

Community driven content discussing all aspects of software development from DevOps to design patterns. The easiest way for a Java developer to learn Java Database Connectivity (JDBC) is to experiment ...

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line of business applications and ...

Built-in functions, UDFs, materialized results, and integrations with ML and AI models make streaming SQL a compelling choice ...

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...