As part of implementing a security model for our application, we've enforced schema security such that our application can only call stored procs, views, and UDFs. This helps prevent sql injection , ...

Have you noticed that dynamic SQL is more popular today than ever before? There are a number of factors contributing to the success of dynamic SQL. Commercial off-the-shelf applications, such as SAP, ...

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work ...

In the meantime, the big question for data leaders is where to implement this logic. The market has split into two ...

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

Have you ever spent hours fine-tuning a Power Query workflow, only to have it break because a column name changed? It’s a frustratingly common scenario for anyone working with dynamic or external data ...

Greetings,<BR><BR>I've used "WHERE 1=1" for a long time in dynamic where clauses in which every condition is optional, and lately I heard it suggested that this can cause full table scans by itself.

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...