One of the things I have enjoyed about working at ChannelAdvisor is being in the EAP program in Microsoft the last two years. This year that included going to the first ever SQLCAT customer engagement lab for SQL on Linux and seen firsthand how committed Microsoft is to making SQL
Must say I’m loving SQL Operations Studio. I’m lucky enough to have some systems with 2017 already installed on them with Query Store enabled so that gives me the ability to track wait stats over a period of time inside a database. For those that are new to 2017, Query Store
Problem Recently, I read an article on extended events where you can watch proportional fill happen on your files. It reminded of a process I wrote to solve a problem we had with page contention (PFS) with our systems processing upwards of 30K transactions per second. So I wrote a process
This month’s T-SQL Tuesday blog is brought to us by Malathi Mahadevan (b | t) and this month topic is about setting our learning goals for 2018. I have for the last 5 (except for last year) years set learning goals for the year after attending a session at PASS Summit in 2012
This will be a very short blog post to make you aware of a bug in CU2 for all of those who I know have eagerly installed the newest CU for 2017. A small bug I have found is that it changes your compatibility mode on the msdb database to
I spoke at PASS Summit on monitoring availability groups to a crowd of about 200 people and received feedback from about 30 people. I must say the feedback was all over the map from me doing really well to me doing just OK. I wish more people would take time