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
655 reads
Blog Posts
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,298 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
36 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
271 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,575 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
55 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
38 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
652 reads
SQL Injection Issues–Password Hashing
I’ve got a demo for one of my talks that really highlights some issues we have with SQL Injection. It’s...
2014-12-04
1,395 reads
SQLKonferenz 2015
If you are looking for one of the most awesome and most import conferences in Europe, then surely you need...
2014-12-04
437 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