Our website DBs need to reference data in our main production database and when the web developers started writing code they were using 3/4 part naming This was a huge...

Great article Grant.

Former WN4NKJ

Also, a simple way to test this would be to just replace the DELETE with SELECT * and see what comes back.

SELECT * FROM tb_LogIP 
WHERE MsgLogID...

It's also handy to setup a c-name for production that points to your current server. Change connections to the current server to use the c-name instead of the server name....

You can get close writing a PowerShell script...

• Worked in my parents ceramics shop sweeping up, pouring molds, cleaning greenware, loading / unloading kilns.
• Washed dishes at a couple restaurants during high school. Met some crazy and...

Also, check out Glenn Berry's scripts.

https://www.sqlskills.com/blogs/glenn/category/dmv-queries/

Looks like QotD is not happy with the correct answer...  Sys.time

In the lab space, third party vendors can be VERY SLOW to validate their code on new versions. We have two different vendors we work with who are telling me...

Thanks Steve.

I have to agree with Chris. Please don't do this.

1.  You can’t link your account to multiple emails.  An issue I brought up many times.  I don’t want to associate this site with my work email, just in...

I'll add one, please add the forum a post is in back to the most active threads page, it's really helpful.  I know you're going for a more mobile...

Until product owners are willing to put enough detail into requirements documents, we're not going to see AI build complete programs. I know that I routinely round trip...

I also liked the old format better. More compact and concise. I also miss the seeing the forum names for questions.