Denny Cherry & Associates Consulting

Reposted: SQL Server Linked Servers Should Never Use An Account With Sysadmin Rights https://www.dcac.com/2025/03/31/sql-server-linked-servers-should-never-use-an-account-with-sysadmin-rights/

https://bit.ly/4f8XUYj SQL Server Performance for Developers Join the 40k+ people who have learned how to improve #performance of your #SQL #Server #database applications. #LinkedIn #Learing #IT

https://www.dcac.com/2025/02/06/having-a-part-time-database-administrator-can-help-improve-your-bottom-line/ Reposted: Having a Part-time Database Administrator Can Help Improve your Bottom Line

https://bit.ly/3P4g5E1 RealtyTrac's DB server needed upgrading and #HA. They used the beta of SQL 2016; making them the 2nd company in the world running SQL 2016, giving them the HA and performance that they needed. Contact DCAC to discuss your #SQL Server upgrade needs https://dcac.com/contact

Reposted: Cloud Environment Isolation Done Right: Network, Identity, and Policy Boundaries https://www.dcac.com/2026/03/23/cloud-environment-isolation-done-right-network-identity-and-policy-boundaries/

https://buff.ly/3SwxjuL Performance Tuning Your Applications Pays Tuning line-of-business apps is worth it for peak #performance. By @mrdenny.com via @inc.com #BusinessGrowth #businesstips #Productivity #Efficiency #INC5000 #CostReduction

Reposted: NetApp Has Some Interesting AI Features In Their New AFx Product Lineup https://www.dcac.com/2025/10/17/netapp-has-some-interesting-ai-features-in-their-new-afx-product-lineup/

https://www.dcac.com/2018/01/29/lcptracker/ Working with DCAC, LCPTracker was able to design and build a new data warehousing solution to meet the needs of their clients and company. Contact DCAC to talk about your data warehousing needs https://dcac.com/contact

https://bit.ly/49sLgBW DCAC was asked to help William Ryan Homes move their systems to Azure in order to imporve performance of the systems while mainting the access the remote employees had. Contact DCAC to discuss your cloud migration needs https://dcac.com/contact

Reposted: Cloud Environment Isolation Done Right: Network, Identity, and Policy Boundaries https://www.dcac.com/?p=87114

https://bit.ly/3Vpkx3G DCAC worked with NDC to move their services to #Azure. NDC consolidates bankruptcy data from across the US, providing a cost-effective method to manage #Chapter13 #bankruptcy claims. Read about how we reduced hosting costs and increased #security.

Reposted: Tune Stored Procedures For Actual Usage, Not Assumed Usage https://www.dcac.com/2026/03/03/tune-stored-procedures-for-actual-usage-not-assumed-usage/

https://buff.ly/3HTRvC4 Denny's most recent #book on #it security is for the #SMB #BusinessOwner and #UpperManagement so that they know which questions to ask their IT people so that they can get the best results for their companies. #security #IT #computers #business

Reposted: 9 questions to ask before adding generative AI to your data project https://www.dcac.com/2025/07/22/9-questions-to-ask-before-adding-generative-ai-to-your-data-project-2/

https://bit.ly/4irwAYe Nip & Tuck Your IT Production Budget Join @mrdenny.com as he talks about the ways that companies can do more with less #IT #Budget via @inc.com #inc5000 #business #savings

Reposted: Why DBAs Still Need to Know the Foundations of SQL Server https://www.dcac.com/2025/08/19/why-dbas-still-need-to-know-the-foundations-of-sql-server/

https://bit.ly/41o8esi With DCACs assistance ATTOM Data was the second company in the world running #SQL 2016, back in 2015. After this DCAC and ATTOM moved to #Azure to improve performance and consolidate resources. Contact DCAC to discuss your cloud migration needs https://dcac.com/contact

Reposted: From Outage to Opportunity: Strengthening Web Applications After Azure & Cloudflare Downtime https://www.dcac.com/2025/12/10/from-outage-to-opportunity-strengthening-web-applications-after-azure-cloudflare-downtime/

https://buff.ly/496Dahn Server #emergencies always seem to happen at 3 a.m. Getting assistance at 3 can be tricky unless you have DCAC's Emergency Response package. Our ER package provides methods to contact the DCAC team anytime to get help with emergencies. #sqlserver

Reposted: The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3 https://www.dcac.com/2025/09/03/the-case-of-the-forgotten-compatibility-mode-scooby-dooing-episode-3/

https://www.dcac.com/2021/07/26/national-data-center-azure-migration/ DCAC moved NDC from an aging on-prem data center to #Azure allowing them to improve performance and reduce costs. Contact DCAC to discuss #cloud #migration needs. https://dcac.com/contact #Chapter13

Reposted: The Mystery of the Locked-Up Database -Scooby Dooing Episode 6 https://www.dcac.com/2025/09/24/the-mystery-of-the-locked-up-database-scooby-dooing-episode-6/

https://bit.ly/4f5rUnK In 2016 AER needed to replace aging computer hardware. They close DCAC to find a solution. DCAC moved AER's systems to #Azure saving 15% over existing costs and coming in 30% under budget. Contact DCAC to talk about your #cloud #migration needs https://dcac.com/contact

https://www.dcac.com/2025/02/24/moving-your-backups-off-site-needs-to-be-part-of-your-disaster-recovery-plans/ Reposted: Moving Your Backups Off Site Needs to be Part of Your Disaster Recovery Plans

https://buff.ly/46ZJ56m Why IT Disaster Recovery Plans are Critical Employees need resources in place for #business #continuity. via @inc.com by @mrdenny.com #DR #BCDR #BC

Do you run a #SQL Server or #IT user group, and need a free web hosting solution for your group? We have a solution for you at https://sqlugs.com/ where you can host your site, including usign your own domain name. Go to the site and simply request a site.

Reposted: Ruh-Roh! SQL Server 2025 Finally Brings Us a Free Standard Developer Edition – Scooby Dooing Episode 2 https://www.dcac.com/2025/08/28/ruh-roh-sql-server-2025-finally-brings-us-a-free-standard-developer-edition-scooby-dooing-episode-2/

https://bit.ly/4gnoTjA DCAC has been working with EGPAF for years. Some of the work includes migrating several systems to #Azure reducing #IT costs by 75%; assisting with the effort to create an AIDS-free generation. Contact DCAC to discuss your cloud migration needs https://dcac.com/contact

Reposted: When Blocking onmicrosoft.com Make An Exception For Microsoft https://www.dcac.com/2025/05/16/when-blocking-onmicrosoft-com-make-an-exception-for-microsoft/

https://bit.ly/3ZGmifd SQL Server: Security for Developers Join the 9k+ people who have learned how to better #secure their #databases in #SQL #Server. #LinkedIn #Learing #IT

Reposted: 5 Tasks That Database Administrators Should Be Doing in the New Year https://www.dcac.com/2025/12/29/5-tasks-that-database-administrators-should-be-doing-in-the-new-year/

https://bit.ly/3Vpkx3G DCAC worked with NDC to move their services to #Azure. NDC consolidates bankruptcy data from across the US, providing a cost-effective method to manage #Chapter13 #bankruptcy claims. Read about how we reduced hosting costs and increased #security.

Reposted: The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3 https://www.dcac.com/2025/09/03/the-case-of-the-forgotten-compatibility-mode-scooby-dooing-episode-3/

https://bit.ly/3ZGmifd SQL Server: Security for Developers Join the 9k+ people who have learned how to better #secure their #databases in #SQL #Server. #LinkedIn #Learing #IT

Reposted: Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain https://www.dcac.com/2025/10/17/scooby-dooing-episode-9-the-case-of-the-artificially-intelligent-villain/

https://bit.ly/3DcOTzU Azure #Migration Provides Time and Cost #Savings DCAC migrated Rev.IO from an aging data center to #Azure, saving $500k over 3 years with improved performance by 34%. Contact DCAC to discuss your migration https://dcac.com/contact

Reposted: Insert Location Matters in Dynamic SQL https://www.dcac.com/2025/11/13/insert-location-matters-in-dynamic-sql/

https://buff.ly/48ekqvy #Prevention Versus #Clean-Up of a #Data Breach by @mrdenny.com via @inc.com Join Denny as he talks about the pain of a data breach and why companies need to protect customer information. #security #ITsecurity #cloud #SMB #cybersecurity #inc5000

Reposted: Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance https://www.dcac.com/2025/06/19/exploring-the-next-gen-general-purpose-tier-in-azure-sql-managed-instance/

https://www.dcac.com/2018/01/29/lcptracker/ Working with DCAC, LCPTracker was able to design and build a new data warehousing solution to meet the needs of their clients and company. Contact DCAC to talk about your data warehousing needs https://dcac.com/contact

Reposted: Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant https://www.dcac.com/2025/11/04/scooby-dooing-episode-10-the-case-of-the-copy-and-paste-consultant/

https://buff.ly/46ZJ56m Why IT Disaster Recovery Plans are Critical Employees need resources in place for #business #continuity. via @inc.com by @mrdenny.com #DR #BCDR #BC

Reposted: 5 Things You Can Do To Understand and Reduce Your Azure Spend https://www.dcac.com/2025/06/02/5-things-you-can-do-to-understand-and-reduce-your-azure-spend/

https://bit.ly/3u0Bsel Cloud Computing Risks Are Overrated Read as @mrdenny.com debunks the most common concerns of moving your workload to the #cloud. Via @inc.com #IT #Savings #Business #inc5000

Reposted: When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages https://www.dcac.com/2025/12/08/when-the-internet-stumbles-lessons-from-cloudflare-azure-front-door-outages/

https://buff.ly/3SwxjuL Performance Tuning Your Applications Pays Tuning line-of-business apps is worth it for peak #performance. By @mrdenny.com via @inc.com #BusinessGrowth #businesstips #Productivity #Efficiency #INC5000 #CostReduction

Reposted: SQL Server 2025 Developer Edition – One size fits all https://www.dcac.com/2026/01/05/sql-server-2025-developer-edition-one-size-fits-all/

https://buff.ly/3Tva1aP Why IT #Disaster #Recovery Plans are Critical and Employees need resources in place for business #continuity. via @inc.com and @mrdenny.com #DR #BC #BCDR

Reposted: The Case for Scooby-Dooing: Solving SQL Server Mysteries Like a Pro– Scooby Dooing Episode 8 https://www.dcac.com/2025/10/08/the-case-for-scooby-dooing-solving-sql-server-mysteries-like-a-pro-scooby-dooing-episode-8-2/

https://bit.ly/41mtiz1 Is Security Better in the Cloud or On-Prem? @mrdenny.com discusses the differences between #IT security on-prem vs in the #cloud and why you need to improve your companies IT #Security stance today. Via @inc.com #IT #Savings #Business #inc5000