Execution Plan Stability
I’ve talked before about one of the primary things that the Query Optimizer team at Microsoft tries to avoid, regressions....
2011-03-07
789 reads
Upcoming Engagements
I haven’t been blogging lately because I’ve been busy tweaking my resume, working on PASS SQLRally, serving at church, and spending...
2011-03-07
635 reads
XQuery for the Non-Expert – Aggregates
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-03-07
1,257 reads
Take-aways from the 2011 Microsoft MVP Summit
Every year, Microsoft brings a couple thousand specialists from every corner of the globe together for a few days to...
2011-03-07
631 reads
In summary - SQLskills internals.
Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter]...
2011-03-06
507 reads
SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
515 reads
Leading Wildcards Aren’t A Good Default
SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as...
2011-03-05
1,188 reads
Women in Technology PPT Template
Well hey-howdy-hey (as we don’t say in Texas), it’s Women’s History Month! And by all accounts, it’s going to be a...
2011-03-04
1,033 reads
Oh Yes It’s Ladies Ni…errr…Month
Making WIT awesome since 1993
It’s March and this month sees a lot of celebration, amongst the parties are Mardi Gras...
2011-03-04
446 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that....
2011-03-04
14 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers