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.

Blogs

A New Word: Feresy

By

feresy – n.  the fear that your partner is changing in ways you don’t...

Mastering the ORDER BY Clause in SQL Window Functions

By

This article provides a comprehensive overview of the ORDER BY clause within SQL window...

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

Iterative query to sum a colum relating to dates.

By Tallboy

Hi, I have a simple table with 5 columns as follows with about 80,000...

how to force SS to run certain SP in parallel?

By water490

hi everyone I have a SP that is run in SSIS.  That particular SP...

Visit the forum

Question of the Day

No Renames

Which of these can't be renamed with sp_rename?

See possible answers