SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Tuesday, November 14, 2017
SQL Server: A more useful CXPacket Waits...
Starting with the upcoming SQL Server 2017 CU3 and SQL Server 2016 SP2 releases, CXPACKET waits are split into an actionable wait () and a negligible wait ().
(these wait types are already present in Azure SQL Database).
Making parallelism waits actionable
Wednesday, November 01, 2017
SQL Server Trace Flags
Microsoft have published a useful list of all SQL Server trace flags in a single location:
DBCC TRACEON - Trace Flags
In the past, some of these were poorly documented or hard to find.
MSN, Email: mitch døt wheat at gmail.com