IT & Digital Marketing Articles
Filtering posts by
tag: SQL
February 06, 2025
7 minute read
Dynamic SQL is often talked about in hushed tones in dark corners. No, it's is not 100% safe, and the objections to it are valid. But, with some basic precautions, it's possible to make it as safe as any other SQL and reap the benefits of its...
January 24, 2024
6 minute read
An easy method for speeding up queries against large tables is by using temporary tables. Here's a quick demo on using temp tables to optimize your returns.
February 20, 2023
5 minute read
Importing data from Excel into SQL Server without a bulk import option can be a challenge. Here's how data expert Laura Moss solved this by using Excel to generate T-SQL.