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 …
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 …
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 …
SQL Server 2017 CU 27 Just Released by Microsoft Read more »
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 …
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 …
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, …
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 …
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 …
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 …
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 …