My #SQLFamily
To my Data Family, Redgate Family, #SQLFamily, and Family Family:Thank you!I love you!Keep going!
The post My #SQLFamily appeared first on Grant Fritchey.
2019-06-10
11 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
Which Query Used the Most CPU? Implementing Extended Events
A question that comes up on the forums all the time: Which query used the most CPU. You may see variations on, memory, I/O, or just resources in general....
2019-06-03
28 reads
DevOps Is About Communication
I spend a lot of time showing how to use tools to automate database deployments in support of DevOps. However, the one message that I always try to deliver...
2019-05-24 (first published: 2019-05-13)
292 reads
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to get an image and create a container. This time, we’re going to create a container...
2019-05-23
15 reads
Containers: Creating a Container
In yesterday’s blog post we pulled SQL Server images in preparation for today’s blog post where we create containers from those images. If you haven’t already, get Docker installed...
2019-05-22
36 reads
Containers: Getting an Image
I’m working with Docker running on Windows or Linux. There are other ways to do this, but Docker seems to be a pretty strong standard. I’ll leave it to...
2019-05-21
26 reads
Learning Containers
I find that I’m using containers more and more to get things done with SQL Server. They’re so easy to set up for testing, spin ’em up, do stuff,...
2019-05-20
71 reads
Query Store, Plan Forcing and Table Variables
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
2019-05-06
150 reads
Data Breaches: All Your Fault
One part of my job is to understand the compliance landscape. This means that I read a lot about the GDPR and related similar laws. I also have to...
2019-05-03 (first published: 2019-04-22)
489 reads
Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN
The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you...
2019-04-25 (first published: 2019-04-15)
689 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