It's a nice function that fills a hole, but one I've always used the first day of the next month minus 3 ms to include the time.  I guess EOMONTH's...

I have 2 databases on every server I manage.  The DBA database is just that - a database of procedures and functions I use in administration of the server and...

I've seen the security advantages of using parameters fed into stored procedures, so I won't expand on that.  The dangers of string concatenation being vulnerable to SQL injections are well...

I know I'm a few days late to the party on xp_cmdshell, but last week was ISO-27001 audit week and I was a bit busy. 😉

You can...

It's been quite a while since I've used classic ASP, but IIRC, doesn't Server.UrlEncode convert spaces to a + sign?  That would be the problem, because 'New York' does not...