Running SQL Server in a Docker Container on a Mac
Category:
database-administration
, sql-server
A user recently asked me what a good use case might be to run SQL Server on Linux in a Docker container.
kendra little
Desktop Wallpapers and Webcasts on Isolation Levels and Memory
Category:
database-administration
I’ve been having lots of fun drawing and doing webcasts this summer. I’ve got four SQL Server themed desktop wallpapers to share, and I’ve got lots more coming– along with a new chunk of free webcasts.
Downloadable SQL Server Desktop Wallpapers
Category:
database-administration
Get ’em here
Grab wallpapers at https://github.com/LitKnd/littlekendracomments/tree/main/SQLWorkbooks-Wallpaper-and-Posters.
Did that Query Eliminate Partitions? (videos)
Category:
query-performance
Table partitioning makes execution plans a bit more confusing.
Free Course
I have a free online course which walks you through decoding execution plans, including whether or not partition elimination occurred.
When does physical reads include read-ahead reads in SQL Server?
Category:
query-performance
, sql-server
SQL Server has more than one way to pull pages in from disk for your queries. SQL Server can do a physical read of an 8KB page, or an extent of 8 of those 8KB pages.
Database Mirroring Counters Missing from Perfmon?
Category:
monitoring-troubleshooting
, sql-server
Collecting perfmon counters from SQL Server databases where you are using database mirroring is a little tricky
The counters won’t behave “normally” until after you set up mirroring for a database.
Finding Queries that Cause Wait Stats in SQL Server
Category:
monitoring-troubleshooting
, sql-server
You’ve got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits?
Learn the pros and cons of different techniques to track down the cause of both common and tricky waits in SQL Server, including CXPACKET, PAGEIOLATCH, LCK, RESOURCE_SEMAPHORE, and THREADPOOL waits.