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.

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,799 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

608 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

506 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

702 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,075 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,017 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

316 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

539 reads

Drop Me? No, I Don’t Think So–Question of the Day

by Andy Warren

SQLAndy

Drop Me? No, I Don’t Think So is my latest question of the day and has to do with dropping...

2014-05-14

401 reads

Smart As A Bear?

by Andy Warren

SQLAndy

I got this at Hobby Lobby for $7 on sale, it’s about the width of a license plate and a...

2014-05-14

314 reads

Blogs

A New Word: Gnossienne

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By Mala Mahadevan

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By Brian Kelley

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

How Can SQL Server Detect Application Errors When Developers Can’t?

By Pablo Echeverria

Comments posted to this topic are about the item How Can SQL Server Detect...

Getting Database MaiL Profiles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting Database MaiL Profiles

Preserving Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preserving Data

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers