Over on Experts Exchange someone asked, once I insert a record into the table, how can I retrieve the primary key that was just inserted. This is a topic I covered back in 2005 in my post SQL 101 – System Functions. In this post I introduced you to @@IDENTITY. If you are unfamiliar with…Read More sql db record number
Over on Experts Exchange, someone posted a question I felt I could answer. The user posted a question on how to return a failure and not run a job. I originally took the approach of putting a query at the top of the queries run by the job that would query the table of failure…Read More Return a Success/Failure to a Job based on a SQL query?
Over at Experts Exchange, a user asked for some advice on using online (or off-site storage) for a collection of video files. This is something I have been discussing with my friends and co-workers for some time. I thought I’d try to help out. Looking at the amount of storage, 2 terabytes, I had to…Read More Advice regarding on-line storage versus terabyte drives