Andy Warren

I started my SQL journey here at SQLServerCentral as one of the founders, helping to build a place to share and learn that continues to thrive under the editorial guidance of my friend Steve Jones. I've done a lot of volunteer work over the years ranging from our local SQL group (oPASS, SQLOrlando) to serving on the Board of Directors of PASS to designing and building the framework of SQLSaturday (which has gone on to produce more than 1000 locally managed events since we started in 2007). These days I manage a DBA team, but over the years I've been a trainer, consultant, contractor, and DBA. I'm rarely present on social media, the best way to contact me is here, LinkedIn, or via email.

Presenting at ONETUG on July 10, 2014

by Andy Warren

SQLAndy

I’ll be presenting SQL Performance for Developers to the members of ONETUG on July 10, 2014. I’m going to hit...

2014-05-20

412 reads

Running Out of Foreign Keys-Question of the Day

by Andy Warren

SQLAndy

Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...

2014-05-20

342 reads

Running Out Of Foreign Keys

by Andy Warren

SQLServerCentral

Foreign Keys (FK)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2014-05-20

1,792 reads

Discuss

Password Cracking–Part 2

by Andy Warren

SQLAndy

Two days felt like a long time, so we found a cloud server with 16 cores we could use. We...

2014-05-19

606 reads

Building The SQLSaturday Orlando Marketing Plan–Part 8

by Andy Warren

SQLAndy

One of things I wish PASS provided was at least one template for an event flyer, something that is basically...

2014-05-18

504 reads

BASIC

by Andy Warren

SQLAndy

It might or might not surprise you that I learned to code in Basic. I suppose my first real attempt...

2014-05-16

696 reads

Statistics Parser

by Andy Warren

SQLAndy

A quick plug today for Statistics Parser by Richie Rump, a free web site that takes the output from “set...

2014-05-16

1,069 reads

Password Cracking–Part 1

by Andy Warren

SQLAndy

I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...

2014-05-15

1,015 reads

Peace Officers Memorial Day and Half Staff

by Andy Warren

SQLAndy

Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...

2014-05-15

312 reads

Building the SQLSaturday Orlando Marketing Plan-Part 7

by Andy Warren

SQLAndy

Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...

2014-05-14

533 reads

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

By Meagan Longoria

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

SWAG Saves the Day

PASS Summit East is in one week. I was on the road last week...

Upgrading SQL Server Containers on the Laptop

I don’t have SQL Server installed on my laptop. In an effort to keep...

Read the latest Blogs

Forums

Increase Deadlock Detection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Increase Deadlock Detection

A Tool is Better than a Script

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Tool is Better than...

Understanding Deadlock Victim Selection in SQL Server

Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers