PASS Board Update: May 2015
I’ve had a busy month on the Board.
You may have seen some tweets going by about our compliance with international...
2015-05-27
544 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
Database Engine Tuning Advisor
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...
2015-05-26
828 reads
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,086 reads
I Am Grateful For…
I’m almost done reading the book Connected (will be by the time this is published). It’s fascinating although, at least so...
2015-05-15
507 reads
Effects of Persisted Columns on Performance
I live for questions. And my favorite questions are the ones where I’m not completely sure of the answer. Those...
2015-05-13 (first published: 2015-05-05)
5,935 reads
Speaker of the Month: May 2015
I finally got out to some community events last month and got to see a bunch of great speakers. Not...
2015-05-01
508 reads
Benefits for Some, All or Only a Few
As a member of the PASS Board of Directors I attended the PASS Business Analytics Conference (BAC) recently. You can...
2015-04-27
520 reads
Azure SQL Database Firewall Settings
The new portal for managing Azure is pretty. I’m not sure I’m in love with it, but it’s pretty.
However, one...
2015-04-24 (first published: 2015-04-13)
5,255 reads
PASS Board Update: April 2015
It’s been a pretty interesting month on the board.
First, we did have a little problem. I’m sure one or two...
2015-04-23
532 reads
Query Hash Formula Changes Between Versions
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...
2015-04-21
629 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers