Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...

Wondering if this is A) possible and B) a bad idea. During the account creation process, I'd like to run a SQL query to see if the IP address in question is banned. Is this a bad idea to do via the ...

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 ...

When your users need to run a parameter query while they’re working in a form, this custom button will save them some time. Users can enter criteria directly into a parameter query’s dialog box, but ...

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 ...

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, ...

The only way to get extended support for 2008 versions of Windows and SQL Server is in the cloud. Here’s why you should be thinking about 2012 migrations now as well. The release of Windows Server ...

Here's a look at different ways to query Hadoop via SQL, some of which are part of the latest edition of MapR's Hadoop distribution SQL: old and busted. Hadoop: new hotness. That’s the conventional ...