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

Query Stats

DBAs rarely use the full potential of sys.dm_exec_query_stats.  It’s common to see the queries for looking at the most expensive...

2013-09-04 (first published: )

3,686 reads

Blogs

Use a slicer to filter a visual based upon a measure in Power BI

By

Have you ever wanted to filter a visual by selecting a range of values...

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

By

I wrote a post recently about pruning branches in git. That’s part of the...

Microsoft Fabric shortcuts

By

I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...

Read the latest Blogs

Forums

Blocking question

By SQL Guy 1

Hi all, We have a SSIS package that does 2 things in parallel: moves...

can I monitor auto stats updates through extended events?

By Eric Mamet

We have pretty big tables very sensitive to stats with many updates. Our systems...

SSIS upgrade

By Sailor

I have about 40 packages that are dtsx files that were created with SQL...

Visit the forum

Question of the Day

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

See possible answers