The Very Best of Extended Events
Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when...
2020-04-20
235 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
Develop Resiliency
We are all going through some tough times. It’s tougher for some more than others. Now is the time when you have to work on being resilient, and it...
2020-04-13
7 reads
2020-04-11
130 reads
What Prevents You From Securing Your Servers?
Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I...
2020-04-06
66 reads
Time To Learn Git
I love this quote from Kevin Hill (and not because he mentions me): 3 things I can no longer justify ignoring: #dbatools Git and #Docker for my dev SQL work@cl@sqldbawithbeard@Kendra_Little and @unclebiguns@GFritchey, I blame you...
2020-04-03 (first published: 2020-03-26)
1,097 reads
DB Automation with Azure DevOps
I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...
2020-03-31 (first published: 2020-03-25)
448 reads
Unit Testing & Intelligent Query Processing
Actually, these two topics don’t have anything to do with one another. I just ran out of days to promote everyone individually who was taking part in putting on...
2020-03-31
9 reads
Extended Events: Queries and Waits
Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...
2020-03-30
14 reads
Containers and DevOps
Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change...
2020-03-27 (first published: 2020-03-20)
302 reads
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best data for development is production You can’t have production data for development You have to...
2020-03-27
138 reads
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
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...
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