Creating a “Real” Copy of a View: #SQLNewBlogger

I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....

Superseded Indexes

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be in a room with them without thinking, without holding anything back, or without having to...

Comforting Habits

As we get close to the holidays, Steve ruminates on routines and habits.

DCL

Grinding Away: Brent Ozar

Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...

My 2024 in Data: Music

This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...

My 2024 in Data: Health and Workouts

This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...

Big Data or Small Data

Today Steve talks about big data sets and whether we really need them, or even enjoy working with them.

Function Defaults