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.