Book Review – Query Tuning & Optimization
Via Twitter in October Benjamin Nevarez@BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning...
2014-12-04
740 reads
Blog Posts
Book Review – Query Tuning & Optimization
Via Twitter in October Benjamin Nevarez @BenjaminNevarez solicited help for book reviewers for his new book “Microsoft SQL Server 2014 Query Tuning & Optimization” I jumped at this opportunity as...
2014-12-04
10 reads
Deciding On a Presentation Topic for 2015
I’m spending some time this week and the next few weeks thinking about what I want to talk about next...
2014-12-04
649 reads
Exam Prep 70-463: Columnstore Indexes and Partitioning
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-04
1,258 reads
First Blog Post
Well, this is my first blog post…I’ve said I was going to do this for a long time and it’s...
2014-12-04
251 reads
First Blog Post
Well, this is my first blog post…I’ve said I was going to do this for a long time and it’s finally here. Via Twitter a in October Benjamin Nevarez @BenjaminNevarez solicited...
2014-12-04
8 reads
How to Handle Dynamic Rowsets
Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary...
2014-12-04
1,562 reads
NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
In NUMA (Non-Uniform Memory Access), processors in the same physical location are grouped in a node which has its own local node memory. In a NUMA based system, there...
2014-12-04
38 reads
Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
The SQL Server 2014 Buffer Pool Extension feature can extend the buffer pool space on to Solid State Drive (SSD), where data and index pages can be cached. There...
2014-12-04
23 reads
SQL in the City 2014 – Washington DC
I’m off today, traveling to SQL in the City 2014 – Washington DC to meet Grant and deliver another database delivery...
2014-12-04
647 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers