alevyinroc


Blog Post

T-SQL Tuesday #58 - Passwords

This month’s T-SQL Tuesday topic is passwords. I’m neither a DBA nor server/system admin, so the only passwords I get to manage are my own. But there’s still lots to...

2014-09-09

8 reads

Blog Post

Shorten Your PowerShell Prompt

Recently, I’ve been getting very annoyed by the length of the default PowerShell prompt. Most of my work starts in my Documents folder, so with the default prompt, I’m...

2013-03-03

26 reads

Blog Post

About

I am a geek, husband, father, geocacher & gratuitous consumer of satellite signals (not in that order). I’ve been in IT professionally for over two decades doing web development,...

2012-12-04

31 reads

Blogs

The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection

By

I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

By

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

The Book of Redgate: Evidence

By

We aren’t the only company that does this, but Redgate Software does try to...

Read the latest Blogs

Forums

Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?

By abdalah.mehdoini

Hello We recently encountered an issue where a SQL table unexpectedly grew in size...

The New World Of AI Robots

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New World Of AI...

Logic question in a WHERE clause using IIF?

By DaveBriCam

Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...

Visit the forum

Question of the Day

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

See possible answers