From a schedule program I wrote on my laptop I wanted to turn on an electric wall outlet which would...

I wanted to do some home automation and I wanted to write the code myself (I’m a software...

I have all the changes archived to archive table using triggers, but this doesn’t record anything...

I create archive tables to log all of the changes made to a table. The archive tables look like the...

Surprisingly SQL Server doesn’t automatically create indexes just because you have a foreign key. So...

I have an application with the following as part of the data model: So an Account can have many...

I’ve seen this done a few different ways, but I think this is the best way because you can reuse it...

We have the requirement that our passwords have to change every 90 days.  I wanted to automate...

All of these failed except the last one, I was logged in as RMUser:   exec sp_password...