alevyinroc


Blog Post

Meetings Are Work Too

So Many Meetings I’ve said it. We’ve all said it.
I can’t get any work done today, I’ve got so many meetings.
I need to be reminded on occasion that for...

2022-09-20

114 reads

Blog Post

Why You (usually) Want a Clustered Index

Note: I originally wrote this a few years ago but never posted it. It resurfaced when I migrated the blog so it’s being posted now.
After watching Kevin Kline’s (blog...

2022-06-13 (first published: )

548 reads

Blog Post

Mic Check

Is this thing on? If you’re reading this test post, it means DNS has updated properly and I’ve successfully migrated to Azure Static Web Sites. Welcome!

2022-05-10

Blog Post

Blog Changes Coming

Over the next couple days (weeks?), a significant change is coming to my blog (and if you’re reading this text, it’s already happened). I will be leaving Wordpress behind...

2022-04-25

Blogs

How to find free space in Azure PosgreSQL

By

I wanted to figure out how big (or approximately how big) my dump file...

T-SQL Tuesday #180: Good enough is perfect Roundup

By

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Read the latest Blogs

Forums

Compare rows within the same table

By SQL Bee

I have a table. Structure in script below. I have to compare and see...

Microsoft Recommendations for Update Stats?

By Brandie Tarvin

I have an application team that is insisting on daily (and for some, weekly)...

how can i tell if our db2 driver is ms or ibm or other?

By stan

i see this in the definition of a linked server on our wh sql...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers