Are Foreign Keys Better Than Indexes?
When I first saw this question I thought to myself, “Self. Don’t you think that’s comparing apples to hammers? Yes,...
2013-09-13
942 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
Microsoft Expands Data Centers… Again
Didn’t they just do this in the spring? Word is out that they’re expanding even more data centers. The cynical...
2013-09-12
678 reads
Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,735 reads
New Windows Azure Virtual Labs
Getting started with new technologies can be a pain. That makes all the new labs that Microsoft just posted extremely...
2013-09-10
591 reads
Developers Rate Azure One of Their Favorite Tools
Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...
2013-09-09
1,274 reads
Speaker of the Month: September 2013
This is my second post in what I hope will be an ongoing series. You can see the rules for...
2013-09-06
865 reads
sp_executesql, Parameters and Parameter Sniffing
I’m honestly not crazy about dynamic T-SQL within stored procedures. There are just a few too many opportunities to mess...
2013-09-05
1,538 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
636 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
547 reads
Make the PASS Summit Work For Your Employer
It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy...
2013-09-02 (first published: 2013-08-26)
1,963 reads
Blogs
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...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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