IT & Digital Marketing Articles
Laura Moss is a senior software engineer with Marathon Consulting. As a data wrangler, she specializes in data warehouse architecture and moving data between systems. Her inbox is always empty.
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.
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...
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.
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.
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.
Modified database project deployment scripts help avoid out-of-memory errors when processing data in tables with records in the billions and higher.
How many email messages do you have in your inbox? Six? Sixty? Six thousand? If your answer isn't zero, you’re doing email wrong. Take back control of your inbox.