I started out working with Microsoft Access and SQL Server back in 2000 as the only employee doing IT full-time, and worked most of my career where “big fish in a little pond” was an overstatement. Learning is scarce when you do everything and don’t work with anyone who knows more than you. In 2010 I was plunged into the Ocean and grabbed onto anything I could find to stay afloat. I wasn’t going to simply run scripts I didn’t understand, so I learned the DMVs and system tables in the scripts I found and rewrote them all. Now, I know enough where I can start giving back to a community that saved me from drowning.

Blog Post

TempDB memory leak?

I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. There’s a...

2016-01-05

3 reads

Blog Post

Advent of Code

If you want your skills to be sharp, you practice.  If you want to get yourself to actually do practice,...

2016-01-04 (first published: )

1,540 reads

Blog Post

Indexing Strategy

What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...

2015-12-28 (first published: )

3,489 reads

Blogs

Daily Coping 17 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Daily Coping 16 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Error : Sql Query

By akhil

Hi, I'm struggling to solve this problem. count, for each couple of stations, the...

SQL Query

By akhil

Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...

Combine or join 3 tables, 1 for each databases

By pedroccamara

Hello guys, I hope you're all great and healthy I would love to learn...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers