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
Overview First, we need to cover what distributed availability groups are. The basic definition is it an availability group of availability groups (AG). No remembering back to English class in school you were not allowed to use words that were part of the word to define the word so that makes
My environment has over 400 servers and we use MSX/TSX to manage those servers but we want to be able to have different parameters on different servers. Plus we have the need to run Ola’s scripts on Linux with sqlcmd not available in SQL Agent we will need T-SQL jobs. So
I re-branded my website to match my job title. I like the comic book feel and superhero theme. At had a few designs to pick from but went with a classic American superhero with red and blue colors logo with ripping off their shirt jumping into action which is the way
Problem The current environment is rather unique, with a unique workload that requires writing things like this. One of those being having the transactions cache on the server take up nearly 10 GBs of our memory. Being that we would like that 10 GBs of memory go towards the Buffer Pool