SQL Solutions Group

It only seems like yesterday since it was my turn to write a blog. And yet, here we are again, still staring at the M&M dispenser full of dark chocolate peanut M&Ms. (In my last blog I called it ...

https://sqlsolutionsgroup.com/copying-databases-across-sql-managed-instances/

In today’s tech-saturated world, we expect developers to have a broad range of skills and programming languages at their disposal, SQL usually being one of those. This ensures the whole team ca...

https://sqlsolutionsgroup.com/common-mistakes-with-sql-code/

I’m looking forward to 2024. From many perspectives, I think we are going to see great advancements, including in technology, that on one hand will make our lives easier, but also make our deci...

https://sqlsolutionsgroup.com/the-right-tool-for-the-right-job/

Continuing an SSG tradition of adapting "A Visit from St. Nicholas," the classic poem by Clement Clarke Moore. Happy holidays to all! The post A Visit from St. Randy: ‘Twas the night in the s...

https://sqlsolutionsgroup.com/a-visit-from-st-randy-twas-the-night-in-the-server-room-silent-and-cold/

We often see databases that are simply larger than they need to be. This is usually attributable to technical debt and the gradual growth of data over time. So, what does it look like to put SQL ...

https://sqlsolutionsgroup.com/improve_health_of_database/

If your health is suffering, you're not as much of an asset to your employer, so it's in their and your best interests to ensure as much "balance" as possible. The post Health Considerations in...

https://sqlsolutionsgroup.com/health-considerations/

Andersen & Sons Shelling specializes in the growing, processing and marketing of walnuts, located in the Northern Sacramento Valley. The post Anderson & Sons Shelling: “We’re Nuts About SSG...

https://sqlsolutionsgroup.com/anderson_and_sons_shelling/

PolyBase vs. Linked Servers … which wins? Recently we have had several clients reach out to us about a data archival solution. Some of their databases are in the TB range, with data going back ...

https://sqlsolutionsgroup.com/polybase-vs-linked-servers/

Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t be erroring, maybe you value your job and have CHECKDB scheduled which ca...

https://sqlsolutionsgroup.com/blindsided-by-database-corruption/

We often see companies not doing index maintenance in Azure. This will get you started because Index Maintenance with Elastic Jobs is easy. The post Index Maintenance: Automating Azure with Ela...

https://sqlsolutionsgroup.com/index-maintenance-automating-azure-with-elastic-jobs/