Execution Plans in Extended Events
Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both of these tools are fantastic for troubleshooting. Combined,...
2015-06-17
17 reads
Execution Plans in Extended Events
Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both...
2015-06-17
1,142 reads
Pass TV
Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an...
2015-06-17
668 reads
Creating a Date Dimension with Power Query
A date dimension or table can be extremely important when working on a Power BI project, or BI projects in...
2015-06-16
5,687 reads
Announcing Workshops – Columnstore Deep Dive
After 2 year of active blogging and almost 60 blog posts (56 + 3 on Azure) we have decided that it...
2015-06-16
459 reads
Excel BI Tip #27: CUBESET and CUBESETCOUNT Functions
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-06-16
1,418 reads
Publicizing Mistakes
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
461 reads
The Company Meeting
I’m leaving today for a trip to Cambridge, UK. I do this 2-3 times a year, but this one is...
2015-06-16
630 reads
SQL Server Policy Based Management by Example
What steps do you go through to validate SQL Server configurations after a server build? Even a single server can...
2015-06-16
1,561 reads
Analyzing Baby Names using Power BI
Me and my wife are contemplating names for our first baby we’re expecting in a couple of months! We don’t...
2015-06-16
818 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
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....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers