Andy Warren

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

All authors

Blog Post

Notes on SQLSaturday Orlando 2022

First, the numbers. We registered 240 people, had about 110 on site. That’s definitely better than last year and still quite a bit under what it was pre-Covid. I’ll...

2022-11-04 (first published: )

103 reads

Blog Post

SQLSaturday Orlando on October 8, 2022

This year we’re back at our usual location on the campus of Seminole State College for SQLSaturday #1030. You may remember that last year we couldn’t use the college...

2022-08-01 (first published: )

152 reads

Blog Post

Notes on the 2021 PASS Summit

I attended the three main days this year and wrote notes as I went. As I sat down to type them up I started by going back to look...

2021-11-19 (first published: )

332 reads

Blog Post

Notes on SQLSaturday Orlando 2021

We held an in-person SQLSaturday here in Orlando last weekend (Oct 30th). We didn’t organize one last year, there was just too much risk and too much uncertainty, so...

2021-11-17 (first published: )

195 reads

All authors

Blogs

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Why use XACT_ABORT?

By

This came up one day at my work when a developer was using it....

Using AI for Data Conversion

By

I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...

Read the latest Blogs

Forums

Find all records in a table whose values when summed up will equal another value

By kirkdevilliers

I have a list of transactions in a table. Each transaction has a unique...

sp_lock memory leak

By TheRedneckDBA

I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...

Migration related issue

By LearningDBA

I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...

Visit the forum

Question of the Day

Browsing for Instances

I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy