Technical Resource Center

Insert Sub-header Here

SQL Snippets

Actionable code blocks to help you get the job done.

Recent Posts

January 17, 2023
Magic Gives Back + T7 Technologies

Check out our latest T7 technologies project! “Magic Gives Back” Is a new site combining the best in entertainment with modern approaches to raising money for schools. The site takes care of all of the back-end work, for example, ticket handling and prize tracking as well as an easy step-by-step marketing schedule! Working with Ultimate […]

Read More
August 23, 2021
There Is Nothing More Important Than Your Data

Do you know the current state of your data environment? I often ask clients to consider this question: If your data disappeared tomorrow, what impact would this have on your business?

Read More
June 3, 2021
Software Development: Phase II is a Fallacy

Anyone who has contributed to a software development effort (which could be any stakeholder, a project sponsor, business analyst, project manager, or SME…) has likely reached a crossroads in designing a system. Here, the three fundamental project-planning pillars, Cost, Time, and Resources (CTR) come to a head. Many times, the proposed method for getting past […]

Read More
June 2, 2021
SQL Server Migration and Upgrades - Five Essential tips

Having worked on many migrations and upgrades of SQL Server instances (2008, 2012, 2014, 2016, 2017), here are five essential tips which can be helpful as you are planning for a migration and upgrade. Understand your network and disk throughput - Accurately estimating the time required to get the data to its destination is important. […]

Read More
June 1, 2021
5 Keys to Estimating Work for Technical Projects

Many projects, challenges, requests, and enhancements can often be interpreted as either very large projects, or very minuscule efforts. In most cases, it is closer to the elephant than the ant.  When you dig further into the details of any request, you often experience dependencies, unknowns, unexpected _(requirements)__, and conflicting priorities. Taking the time to […]

Read More