UPDATE, April 18, 2017: Ola has added this functionality directly to his scripts. Please download his scripts instead as they have more error handling and other functionality built-in. I will be updating my configuration tables and procedures shortly. This is part 2 of 2 on taking smart backups. I wrote a previous
This T-SQL Tuesday is brought to us by Arun Sirpal (b | t) and wants to write about a technical challenge we have conquered. Having been a DBA for 18 years now it’s hard to pick on a technical challenge but I will stick to the more recent challenge of
UPDATE, April 18, 2017: Ola has added this functionality directly to his scripts. Please download his scripts instead as they have more error handling and other functionality built-in. I will be updating my configuration tables and procedures shortly. This is part 1 of 2 part series on taking smart backups. Part 1
Just in case you missed it I wrote a blog post for Idera on creating a PowerShell module using Plaster you can find it here. It simplifies an earlier blog post I wrote and the same subject with some information I learned from Rob Sewell. This month I have one
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