In observance of the US federal holiday Memorial day, and in memory of all who have died in service, Stedman Solutions, LLC will be closed for the last Monday in May. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell …
Ok cool Stedman Solutions is having CTE (common table expressions) month in June. What does that mean for you my reader? Well let me share all the goodies I have to offer this month! Next month I will be releasing……. Over 15 CTE videos with topics ranging from a memory table to recursive CTE’s Common table expressions hot tips A …
Today Microsoft released a new update for SQL Server. SQL Server 2016 Azure Connect pack (KB 5014242) 2022-05-19 Here are the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 16Download links: CU 16 (KB 5011644) SQL Server 2017 RTM CU 29Download links: CU 29 (KB 5010786) SQL Server 2016 SP2 CU 17Download links: …
I am looking for feedback on your naming conventions for a couple areas relating to naming convention. As Stedman Solutions consultants we work for several clients in each week, and sometimes any team member may work with more than 15 clients in a month. That gives us a large variety of exposure to different nomenclatures. Some of those conventions are …
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU 16 (KB 5011644) 4/18/2022 (Windows) 5/10/2022 (Big Data Clusters) 5/16/2022(Linux) Here are the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 16Download links: CU 16 (KB 5011644) SQL Server 2017 RTM CU 29Download links: CU 29 (KB 5010786) SQL Server …
One of the services we do a ton of is our Design and Development Service. This involves anything from writing custom TSQL procedures to website integration with the database to custom C# applications that we have created. We at Stedman Solutions work with in types of environments – If you have a new application in the cloud with 500+ TB …
Here listed is the current percentages of SQL server versions running our Daily SQL monitoring service with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie chart above represents all of our current customers using our service and what SQL Server versions they are running. …
Daily SQL Monitoring – SQL Server Versions for May Read more »
Over the last 30+ years of working with SQL Server, I have seen a lot of interview questions relating to SQL Server. I have been on both sides of the interview table, sometimes wondering what the person on the other side of the table was asking. As a SQL Server developer do you feel that you were asked good questions …
What is your favorite SQL Server Developer Interview questions? Read more »
I have used my over 30 years of SQL Server experience to personally curate my favorite performance tuning tips and tricks into this training. I am excited to contribute and share with the SQL Server community some of my favorite solutions. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. …
Whenever you hear a company with over 30 years of experience tell you facts from real life scenarios, you should hear what they have to say. Learn from others’ mistakes some say. Our team has come up with 3 quick common database mistakes from working in world of the SQL Server database repair, performance and analysis. 40% of our assessment …