Happy New Year 2015
I know it’s late but I’ve been away, I hope you all had a good Christmas and New Year.
I...
2015-01-05
636 reads
The DBA Who Came In From The Cold
Book Review – SQL Server Internals: In-Memory OLTP by Kalen Delaney
The new SQL Server 2014 feature In-Memory OLTP (code-named “Hekaton”) has been attracting a lot of interest since its release,...
2014-12-09
1,775 reads
Video – Identifying large queries using Extended Events
A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...
2014-12-11 (first published: 2014-12-05)
2,360 reads
Blogging for a year!
I’m actually quite proud of the fact that I’ve now been doing this for a year now (and that I’m...
2014-11-07
437 reads
Cardinality Estimation in SQL Server
Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for...
2014-11-04
1,271 reads
Identifying large queries using Extended Events
Following on from my last blog post I now want to run through how to identify large queries using Extended...
2014-10-06 (first published: 2014-10-01)
12,164 reads
Identifying large queries using Server Side Traces
Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).
I know...
2014-09-17 (first published: 2014-09-11)
7,855 reads
The Art of Performance Tuning
Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play....
2014-09-04 (first published: 2014-08-28)
8,783 reads
Website Pulse
Short blog post this time as Website Pulse contacted me a few weeks ago with a few questions about working...
2014-07-31
1,170 reads
Partitioning Basics – Part 3 – Switching Data
This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...
2014-06-24 (first published: 2014-06-20)
3,225 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Distributed Availability Group Issue / Misunderstanding.
Not sure if this is a tech mistake I've made or a lack of...
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers