IT & Digital Marketing Articles

Filtering posts by category: Data Solutions & Reporting

Remove filter

June 10, 2025 Laura Moss 3 minute read

During database maintenance or migration, knowing the record count per table is crucial to gauge data scope. Here are 2 methods to retrieve total record counts for all tables in a SQL Server database.

February 06, 2025 Laura Moss 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...

SQL Dynamic SQL

January 14, 2025 John Hadzima 13 minute read

Always Encrypted is a feature in SQL Server and Azure SQL designed to protect sensitive information in individual database columns of an application's database. In this example, we have a .NET 8 application, an Azure SQL database, and an Azure Key...

January 24, 2024 Laura Moss 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.

SQL SQL Server

July 13, 2022 Laura Moss 7 minute read

Data wrangler Laura Moss shares an easy way to calculate the distances between points in a database, taking into account the curvature of the earth using Haversines with SQL.

January 11, 2022 Laura Moss 15 minute read

Modified database project deployment scripts help avoid out-of-memory errors when processing data in tables with records in the billions and higher.

August 09, 2021 Brian Knox 6 minute read

Becoming a Microsoft Certified: Data Analyst Associate has more benefits than just a bullet point on a resume. If you are looking to prove your talents or take on a new challenge in your career, becoming a Microsoft Certified: Data Analyst...

Let's find what you're looking for