SQL Server, What's In My Buffer Cache?
When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...
2019-03-06 (first published: 2019-02-19)
2,293 reads
Interview with Uwe Ricken
I have just done my first interview! The very special guest was Uwe Ricken!
My idea for the interview was...
2019-02-19
118 reads
Speaking at SQLBits in March 2019
I’m super excited about the fact I’ll be speaking at SQLBits this year. It’s my first time as a speaker...
2019-02-18
121 reads
Upcoming SQLpassion Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-02-18
128 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing a few extensions. Buck Woody has a great list...
2019-02-18
6 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing...
2019-02-18
315 reads
Don’t Leave the Database Behind…Or Win If You Do
If you’ve had struggles with database development and had a real world disaster, you could win in a new Redgate...
2019-02-18
166 reads
Error in SSMS: Attempted to read or write protected memory.
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked...
2019-02-18
184 reads
Partitioning 5: The extra partition
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
2019-02-18
175 reads
SQLSaturday Atlanta & South Florida 2019
I’ll be in South Florida again this year and will stay over as usual for a couple days of vacation. I see Brent is attending; I’ll have to make...
2019-02-18
16 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU Cianjur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur,...
Alamat Kantor BCA KCU Depok Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok,...
Alamat Kantor BCA KCU Cibubur Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers