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
651 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,265 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
15 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
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
650 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,394 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
435 reads
Blogs
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers