There are a few versions of SQL Server 2012 and SQL Server 2014 that are known to cause corruption in certain situations. These versions are: 2012 versions between 11.0.2100 and 11.0.3436 2012 versions between 11.0.5058 and 11.0.5521 2014 versions between 12.0.2000 and 12.0.2369 The recommendation if you are running one of these versions that you check the release notes and …

Dangerous Versions of SQL Server Read more »

I was recently remembered of a time I was working more with performance tuning on Oracle. The following is something that I had discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to the question of how much procedure cache memory does one SQL …

How much Procedure Cache memory does one SQL Statement take up? Read more »

Today Microsoft released SQL Server 2017 CU 27 (KB 5006944) . Here are the latest updates for each version of SQL Server. If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions can help. With the amount of ransomware we are seeing, it is becoming more important than ever …

SQL Server 2017 CU 27 Just Released by Microsoft Read more »

Freak Storm/Weather

This post will be updated with the status of the things as the Cyclone Bomb storm progresses over the next couple days. 10/24/2021 – 8:00am The weather forecasters are saying things like the biggest storm to ever hit the Pacific Northwest. Here is what Cliff Mass had to say: … the formation of an unprecedented storm is nearly a sure …

Cyclone Bomb Storm In the Pacific Northwest Read more »

For some reason, you want to learn how to use SQL Server, but the steps to get started can be overwhelming. I have created a Getting Started with SQL Server class that we sell for just $19.99.  At that price even it if saves you just an hour or two of your time, it is probably worth it. The class …

Do You Want to Learn How to Use SQL Server? Read more »

The question comes up occasionally about how people can get started with Microsoft SQL Server? This is often people who are working and for some reason need to learn how to use SQL Server in their jobs. They ask me, how do I get started with SQL Server? For me, I got started with SQL Server when I took a …

How Do I Get Started with SQL Server? Read more »

One of the feature differences between SQL Server Express Edition and the other paid versions is the ability to schedule jobs or tasks using the SQL Server Agent. Even if you are running SQL Server Express Edition, there is a need to run scheduled jobs. Things like: Backups Index and Statistics Maintenance Shrink DB  (Just Kidding, don’t do that) A …

Using OSQL.EXE to run a scheduled task on SQL Server Express Edition Read more »

This sale only happens 1-2 times a year – get it while it’s hot! SQL Server Mentoring is a training / consulting option for those who just need a little help or direction. This is a cost-effective approach for those who need just a little help. Some call it coaching, others call it micro consulting, but its all basically the …

20% Off Mentoring Services Read more »

So you have a new team member that has just joined your team, and they have no experience with SQL Server, but they need to learn how to get connected and use SQL Server. There are a few options on what you can do: Sit with them and walk through all the details around installing a local server and using …

Getting that New Team Member Started with SQL Server Read more »

Looking at the memory limits and other limits on the SQL Server versions over time, we have seen things increase, but one limit that is still very low is the memory limit for SQL Express. Specifically the maximum memory for buffer pool per instance of SQL Server Database Engine for SQL 2019. The limit there is 1410 MB. At first …

Memory Limit for SQL Server Express Read more »