SQL Solutions Group

Name: SQL Solutions Group
Address: Las Vegas, NV, 89123, US
Telephone: +18012850251

Home
United States
Las Vegas, NV
SQL Solutions Group

Call Directions Website Contact the business

SSG is a Microsoft certified full service SQL Server consultancy specializing in system analysis, architecture, performance tuning, and integration.

SQL Solutions Group is a Microsoft certified, full-service SQL Server consultancy, specializing in system analysis, architecture, tuning, and integration. Our principal consultant, Randy Knight, has over 25 years SQL Server experience, and a strong track record in system optimization. The list of SQL Solutions Group offerings includes:

End to End Database Development including Analysis, Design and Implementation
Database Performance Tuning
Oracle Integration and Migration
Business Intelligence (SSIS, SSAS, SSRS)
Outsourced DBA Services
SQL Server Database Audits
Infrastructure Design and Implementation
SQL Server Technology Training
Contract to Hire and Direct Placement of High Quality Talent

10/31/2026

The most-searched SQL questions, and we've got answers for all of them. Whether you're a junior dev or a business owner trying to make sense of your data, we break down the "how" so you can focus on the "what's next." Save this for your next database deep-dive.

10/29/2026

After 300,000+ support tickets, we’ve seen every way SQL Server can break, and the same culprits keep showing up.
Slow queries. Backup failures. Tempdb contention (again). Critical incidents at 2 a.m.
On Wednesday, November 18, the SQL Solutions Group team is going live to share what our ticket data actually reveals about the most common SQL Server problems, why they keep happening, and how to prevent them before they turn into outages.
In this free webinar, you’ll learn:
- The top root causes behind SQL Server performance issues
- Why backup and recovery failures slip through the cracks
- How to spot tempdb and configuration problems early
- Practical fixes DBAs and IT teams can apply right away
Real incidents. Real data. Practical takeaways.

Save your spot: https://na2.hubs.ly/H08H7730

10/28/2026

Your index rebuild says 0%... for 2.5 hours. Time to panic? 😬

Not yet. percent_complete in https://na2.hubs.ly/H085sVg0_exec_requests doesn't track index rebuilds at all. It only reports on reorgs and a few other operations.

Our SQL expert Rich Benner checked https://na2.hubs.ly/H085sVg0_exec_query_profiles instead and found the "stuck" rebuild was actually 94% done. 🙌

Swipe through to see what to check instead ➡️

Full post and queries at the link in bio.

10/23/2026

Your server hit 100 percent CPU. Twice. And both times, update statistics seemed to fix it.
Here is the catch: the real culprit was a table valued parameter.
Table variables and table valued parameters have no column level statistics, so SQL Server can cache an ex*****on plan built for 12 rows and reuse it when 40,000 rows show up. That is when high CPU usage takes over. Updating statistics only helped because it forced a recompile.
Swipe through to see the one line fix with OPTION (RECOMPILE), when temp tables are the better long term choice, and how Query Store helps you spot the pattern. If parameter sniffing and plan reuse sound familiar, this one is for you.
Need help with SQL Server performance tuning? The experts at SQL Solutions Group are ready. Visit https://na2.hubs.ly/H07Zs1z0

10/21/2026

Ask a senior SQL Server DBA about third party backups and you'll usually hear the same answer: no.

Not because they're stubborn. Because they've seen too many "successful" backups fail during recovery.

Broken LSN chains. VM snapshots without proper VSS coordination. Log truncation outside of real backups. DR tests exposing backups that were never actually recoverable.

The reality is recoverability is defined at the engine level, not by a green checkmark in your backup software.

But as databases grow and backup windows disappear, native backups alone are not always practical. VSS snapshots can work if SQL Writer participation, LSN consistency, and log backup strategy are all handled correctly.

What made you trust or avoid third party SQL Server backups?

10/16/2026

Gold star behavior: DBA edition

Six habits that keep SQL Server fast, safe and boring (the good kind of boring):

1. Integrity checks
2. Verified backups
3. Maintenance tasks
4. Appropriate configurations
5. Performance monitoring
6. Security awareness

Click through to see why each one matters. Be honest: which one does your team skip?

Share your favorite slide to your story, and follow for more SQL Server tips. Want to know how your servers score? Book a SQL Server health check at https://na2.hubs.ly/H08rcK50

10/15/2026

Is your SQL Server hiding risks you can't see? A proper SQL Server health check should never be a guessing game.

At SQL Solutions Group, every assessment we run covers 5 critical areas of risk: security and access, backup and recovery and corruption, configuration and best practices, performance and stability, and HA/DR readiness. We dig into login configurations, role memberships, orphaned users, encryption, backup job history, restore validation, CHECKDB schedules, wait statistics, index fragmentation, blocking and deadlock history, and more.

Database downtime, data loss, and security gaps are avoidable when you know exactly where your SQL Server environment stands. Whether you are managing on premises SQL Server, Azure SQL, or a hybrid environment, a health check gives you a clear roadmap to improve database performance, strengthen data security, and reduce operational risk.
Do not wait for a failure to find out where your SQL Server stands. Click the link to schedule your SQL Server health check with SQL Solutions Group today.

https://na2.hubs.ly/H08kZXB0

10/13/2026

Welcome to the DBA haunted house. Enter if you dare.
Every SQL Server DBA has a nightmare, and these four are the scariest rooms in the house. Backups that show green every night but have never been through restore testing. Database corruption uncovered by DBCC CHECKDB that is older than your oldest backup. A transaction log that fills the disk at 2 a.m. because the database is in the full recovery model with no log backups. And sysadmin permissions handed out to developers, vendors, and service accounts like Halloween candy.
The good news? Every one of these monsters can be defeated with a solid disaster recovery plan and smart SQL Server security practices.
Which room would send you running? Tell us in the comments.
Need help making sure your SQL Server backups actually work? The experts at SQL Solutions Group can help. Visit https://na2.hubs.ly/H07ZwRL0

10/12/2026

Slow queries. Backup failures. Tempdb. Again. Every SQL Server team knows the feeling of staring at a pile of alerts and wondering which critical incidents actually deserve attention.
SSG Lead Consultant Rich Benner went through more than 300,000 real client tickets to find out what truly breaks in SQL Server, how often, and why. Join our free SQL Server webinar on Wednesday, Nov. 18 at 2:00 p.m. Eastern/11:00 a.m. Pacific to see what the data reveals about alert fatigue, the everyday problems hiding in plain sight, and how to approach SQL Server troubleshooting with more confidence.
No labs. No theory. Just real incidents and practical lessons for SQL Server monitoring, incident triage, and database administration.
Save your spot here: https://na2.hubs.ly/H07ZTMr0

10/09/2026

Ready to fortify your data security? Contact us today and let’s discuss how we can protect your most valuable asset.

Address

Las Vegas, NV
89123

Telephone

+18012850251

Website

http://www.sqlsolutionsgroup.com/

Alerts

Be the first to know and let us send you an email when SQL Solutions Group posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.