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

5 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,511 reads

Blogs

Attacking the Weakest Link

By

When I look at a system and think about its security model, the first...

Webinar – Microsoft Fabric for Dummies

By

On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...

Migrate datetime data to datetimeoffset with AT TIME ZONE

By

I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...

Read the latest Blogs

Forums

Multi row tally query with max value

By ibbo14

Hello folks, I would be very grateful if someone could assist me with this...

Looking for a Recommended Azure SQL Managed Instance Book

By shew

Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...

timeout in vs for ssas tabular deploy is 0 but i still timeout deploying

By stan

hi we run 2019 std but i'm testing this on 2016.   following some old...

Visit the forum

Question of the Day

The Backup File Extension

I run this command in SQL Server 2022. What is the extension of the backup file?

BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'

See possible answers