Transaction Logging & Recovery (101)

Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...

A day in the Stream

Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
Related Posts:

Quick...

A day in the Stream

Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the...

2015 in review

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.

Here’s an excerpt:
The concert hall at the Sydney...

Monday Morning SQL Break – January 4, 2016

It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...

Query the Buffer Pool

SQL Server's buffer pool is a majority of your memory, but most DBAs can't tell you what's in it.

Query the Buffer Pool

DBAs are known for asking for more memory, but often can’t say what’s in memory.  While I agree that many...

2015 a year in review

It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell...

Technical Dogma

Humans are creatures of habit, and I suspect that engineering/technical types are even more so. We find something that works...

Hidden GUI Gems

I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help...