SQL Server Execution Plans – Arrow Size
When teaching people about how to use SQL Server Execution Plans, one thing that is commonly overlooked is the size of the arrows between different… Read More »SQL Server Execution Plans – Arrow Size
SQL Server
What are your biggest challenges in your current position?
Every role that I have been in has had different challenges over time. Sometimes the challenge is a technical one that relates to scalability, or… Read More »What are your biggest challenges in your current position?
What is your favorite SQL Server DBA Interview question?
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… Read More »What is your favorite SQL Server DBA Interview question?
Dangerous Versions of SQL Server
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:… Read More »Dangerous Versions of SQL Server
How much Procedure Cache memory does one SQL Statement take up?
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… Read More »How much Procedure Cache memory does one SQL Statement take up?
SQL Server 2017 CU 27 Just Released by Microsoft
Today Microsoft released SQL Server 2017 CU 27 (KB 5006944) . Here are the latest updates for each version of SQL Server. If you need… Read More »SQL Server 2017 CU 27 Just Released by Microsoft
Cyclone Bomb Storm In the Pacific Northwest
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… Read More »Cyclone Bomb Storm In the Pacific Northwest
Do You Want to Learn How to Use SQL Server?
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… Read More »Do You Want to Learn How to Use SQL Server?
How Do I Get Started with SQL Server?
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… Read More »How Do I Get Started with SQL Server?
Using OSQL.EXE to run a scheduled task on SQL Server Express Edition
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… Read More »Using OSQL.EXE to run a scheduled task on SQL Server Express Edition