Login Timeouts
I was recently approached at work about a company that was seeing tons of timeouts in SQL Server. I was asked how to troubleshoot this. There are lots of...
2021-09-27
2 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Volunteer For Something
I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some […]
2021-09-25
211 reads
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find that a lot of people seem to be resistant to the concept. I’m always surprised...
2021-09-20
Rewriting The Query Tuning Book
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
2 reads
Rewriting The Query Tuning Book
While I have not yet signed the contract, I have submitted an outline and proposal for a new version of my book on query performance tuning. Most of the...
2021-09-13
33 reads
The Leaves Are Changing, But Why?
I've recently moved house from Massachusetts to Oklahoma. Long story. Anyway, sitting in my new office looking out at the trees, some of the leaves are starting to change. Ah, Fall. Lovely Autumn colors... WAIT! Actually, something else is going on. Only a few trees are changing color. Word is, we've been a little dry […]
2021-09-04
176 reads
Filtering Extended Events Using Actions
Did you know, you can use Actions to Filter Extended Events? Well, you can. Filtering is one of the greatest ways in which Extended Events differentiates itself from other...
2021-07-26 (first published: 2021-07-19)
238 reads
Define All The Steps Up Front
After 23 years in one place, I'm pulling up stakes and moving. We're selling our house in one state in the US and we're buying a house in another state about half a continent away. To say it's a stressful and exhausting process is an understatement. The worst part is that no one has defined […]
2021-07-24
198 reads
Filtering Extended Events Using Actions
Did you know, you can use Actions to Filter Extended Events? Well, you can. Filtering is one of the greatest ways in which Extended Events differentiates itself from other...
2021-07-19
2 reads
Virtual Presentations: A Presenters Perspective
While we are clearly beginning to see in-person events on the calendar, the vast majority of presentations, events, talks, etc., are virtual. There are a lot of positives to...
2021-07-16 (first published: 2021-06-29)
126 reads
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers