Upcoming speaking engagements
Ayyyy, matey being that today is the International Speak Like a Pirate Day I thought it was appropriate to post some future...
2012-09-19
363 reads
John Sterrett
#TSQL2Day – A Day in the Life of A Service DBA
Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...
2012-07-18
444 reads
Stress Testing Stored Procedures with Free Tools
I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...
2012-07-12
1,328 reads
First SQL Server UG Meeting in Harrisburg, PA
If you work with SQL Server and live in the Harrisburg area I have some great news for you. The...
2012-07-09
653 reads
Free Training: Performance Tuning with Free Tools!
This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice...
2012-06-28
1,384 reads
Getting Inspired with SQL Someday
Recently, I caught my during a kickoff with a new client saying, “Hello I am John, and I love SQL....
2012-05-10
490 reads
Let’s Meetup [Updated]!
I have a confession to make. I like to meet people who also work with SQL Server. There are so...
2012-04-17
675 reads
Blogs
A Conversation That Refused to End: What We Learned from Our First Event in Zurich
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
A DevOps Workshop Tomorrow in Atlanta
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Stop Wasting Time Rebuilding Indexes Every Night
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
Forums
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
isnull, coalesce overhead
hi, one of our sister division's erp extract view is going thru at least...
is there an elegant way for agent notification to show failure if any step fails
hi our corp dw load sqlagent job goes to the next step on the...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers