Play by Play with Pinal Dave was my birthday gift on July 30, 2014: a Pluralsight course that shows how I tune SQL Server performance on a real problem. This post tells why I made it and what each of the five modules covers.
SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
Just like sports stats, SSMS has head-to-head numbers for your server. Here is a tour of the Top Object and Batch Execution Statistics Reports.
mssql-conf: Configuring SQL Server on Linux Without a GUI
Use mssql-conf for SQL Server on Linux memory, file defaults, Agent, ports, and trace flags, then verify effective settings after restart.
SQL SERVER – SSMS: Top Queries by CPU and IO
My father’s office PC started my love for computers and processors. That story leads to the SSMS reports on Top Queries by CPU and IO.
SQL SERVER – SSMS: Top Transaction Reports
A story about my daughter’s school drawing contest leads into the Top Transaction reports in SSMS and what they tell you about your server.
Capping File Growth So One Query Cannot Fill a Whole Disk
One runaway load can fill a shared drive and take every database down with it. A MAXSIZE cap moves the failure to one database.
MySQL – UDF – Validate Integer Function
MySQL has no ISNUMERIC function like SQL Server, so here is a simple user defined function that uses a regular expression to validate integer values.
SQL SERVER – SSMS: Transaction Log Shipping Status Report
Like timber floating downstream, log shipping moves logs from one server to another. Here is how to read the Transaction Log Shipping Status report in SSMS.
Scalar UDF Inlining: When Old Functions Suddenly Get Fast
Check scalar UDF inlining eligibility, database settings, function options, and execution plans before claiming a performance improvement.
SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038
Andy explains isolation in processes, a basic RDBMS idea, with fresh eggs from his family’s chickens. A fun way to learn the fundamentals.










