Mitch Wheat - Treat the cause, not the symptoms!

I’ve moved this blog and content to here .

Configuration file locations: Where are my postgres *.conf files? Where is the Postgresql config file: 'postgresql.conf' on Windows?...

If you’re not encrypting connections to SQL Azure (or any remote SQL Server instance), then you probably should. Encrypted connections to SQ...

If you have a high end NVidia graphics card and you’re investigating data science with Keras+Tensorflow, then you obviously want Tensorflow ...

Just came across this link at Packt: https://www.packtpub.com/packt/offers/free-learning

I’ve recently been learning Python with the goal of using it alongside R for data science. It’s got a lot going for it as a language and the...

Another SQL Server Trace Flags resource (in addition to the Microsoft one ). There are a bunch of SQL Server resources hosted there, SQL ...

I’ve updated SQLDiagCmd , my standalone executable for running any or all of Glenn Berry ’s excellent SQL Server DMV diagnostic scripts . As...

I was searching through email today looking for a LINQPad snippet that a colleague, James Miles , wrote some time ago, one which we used to...

Starting with the upcoming SQL Server 2017 CU3 and SQL Server 2016 SP2 releases,  CXPACKET waits are split into an actionable wait ( CXPACKE...

Microsoft have published a useful list of all SQL Server trace flags in a single location:      DBCC TRACEON - Trace Flags In the past, ...

I was recently trying to work out why SSAS installed on the same server as SQL Server would not use shared memory for its processing connect...

New to SQL Server Manager Studio (SSMS) 17.3 is the XE Profiler. This is Profiler-like functionality built-in to SSMS: SSMS 17.3 has Profile...

A quick and easy SSAS optimisation: turn off flight recorder: SQL Server Analysis Services Flight Recorder provides a mechanism to record se...