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.

SQLServerCentral Article

The Case for SQL Logins - Part 1

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.

2 (1)

You rated this post out of 5. Change rating

2002-06-25

12,639 reads

SQLServerCentral Article

Maintenance Plans - Backups and Removing Old Files

Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!

You rated this post out of 5. Change rating

2002-06-10

7,592 reads

SQLServerCentral Article

Maintenance Plans - Behind the Scenes

Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!

5 (1)

You rated this post out of 5. Change rating

2002-05-27

10,421 reads

Blogs

SQL Aggregate Functions: Your Essential Guide & Cheat Sheet

By

SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Read the latest Blogs

Forums

What is the monkey type?

By Avajos

Monkey type is a free online typing practice website that offers a variety of...

SQL JOB add/modified

By Shelley Allen

Is there a trigger to notify when a new SQL Agent job is created/modified?

View generating different plan

By DamianC

Hello   I have a view based upon a number of tables I'm selecting...

Visit the forum

Question of the Day

Full Text Editions

In which editions can I use Full-Text and semantic search?

See possible answers