2020-01-23
276 reads
Grant Fritchey
Causality Tracking in Extended Events
If you go through all the stuff I’ve written about Extended Events, you’ll find that I use causality tracking quite a bit. However, I’ve never just talked about what...
2020-01-22 (first published: 2020-01-13)
252 reads
2020-01-21
339 reads
How Do We Prove Expertise?
Today, Grant Fritchey talks about the two paths to expertise for database professionals and why it’s hard to really know if someone is an expert.
2020-01-17
366 reads
Let's Fix a Password Problem
Grant discusses the need for password managers to help prevent security issues between different accounts.
2020-01-15
252 reads
Execution Plans: First Operator
The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...
2020-01-14 (first published: 2020-01-06)
490 reads
2020-01-11
234 reads
Ending My Time as PASS President
With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....
2020-01-10 (first published: 2019-12-30)
432 reads
Why Don’t People Use Columnstore Indexes?
I saw this question on SQL Server Central the other day and had an immediate, visceral reaction. I know why. Now, before I explain my answer, please, let me...
2020-01-01 (first published: 2019-12-16)
1,320 reads
Fritchey Family Christmas Movies
MERRY CHRISTMAS! HAPPY YULETIDE! HAPPY HANUKKUH! Instead of something technical, let’s take a moment to just kick back and enjoy a few great Christmas movies. Now, let’s be clear....
2019-12-23
9 reads
Blogs
Use Jupyter Notebooks to Help People on StackOverFlow
By Rob Sewell
I am sat in the PowerShell Saturday in Hamburg. You can see me on...
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Forums
Needed to find all possible Dates Overlaps from a single Table
Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client hasn't...
Optimize Cursor
I inherited this script that has a cursor and I know this query can...
Unable to add secondary node existing node due to DCOM is unavaialble
Dear Team, This is Naveen, Hope all are doing well. I need emergency help...
Ask SSC