alevyinroc


Blog Post

Three Ways to Create a Temp Table

Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...

2020-07-06 (first published: )

2,547 reads

Blog Post

Speaking at SQL Saturday Albany

For the second consecutive year, I will be speaking at SQL Saturday Albany 2020 on July 25th, 2020. I will be presenting “Keys to a Healthy Relationship with SQL...

2020-06-16

3 reads

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

By

Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...

Why your data still can’t answer a simple question 

By

Every organization I talk to has the same problem dressed up in different clothes....

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

By

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

Comments posted to this topic are about the item The day-to-day pressures of a...

Creating a Simple and Flexible Random Password Generator in SQL Server

By john.martin

Comments posted to this topic are about the item Creating a Simple and Flexible...

SQL Art, Part 3: Happy Easter Fun in SSMS

By Terry Jago

Comments posted to this topic are about the item SQL Art, Part 3: Happy...

Visit the forum

Question of the Day

Identities and Sequences IV

When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?

See possible answers