Viewing 15 posts - 1 through 15 (of 16 total)
So our major hurdle to move our data to the cloud is security concerns and backups. We are a government entity, and thus we have all kinds of data where...
July 13, 2020 at 9:47 pm
I attempted to work from home for a few days. But technical issues with my VPN/Internet and the fact that I really did not have a good place to work...
May 1, 2020 at 5:33 pm
Working in a government organization, I have seen many times that either staff has spent hundreds of hours developing a piece of software or they have bought software and somewhere...
February 6, 2020 at 3:47 pm
I have owned and driven in more cars and trucks that I can remember.
I owned a Mitsubishi Montero some years ago. It was a good 4-wheel drive vehicle. Pretty comfortable...
January 10, 2020 at 10:46 pm
We have dozens of small Access databases in our organization (most of them supported by staff outside of IT). A number of them use an MS-SQL back end which provides...
November 20, 2019 at 4:49 pm
Our job title recently changed from Business Intelligence Analyst to Business Intelligence Developer. It was an end-around move to get out of HR's decision in putting everyone who has 'Analyst'...
November 15, 2019 at 5:14 pm
Got the back up info. So a little explanation. EventAttribute contains a value (can be a comma delimited value) that is a FK into the Lookup table. The AttributeDef table...
July 5, 2017 at 1:43 pm
Other staff in our office has rights to created functions, stored procedures, etc. I just don't. I may be able to find the original query or re-create it, which did...
July 3, 2017 at 3:48 pm
Thanks, I am still looking for the solution that did not require a function. I believe it used a cross apply. It turns out there a backup of my C:...
July 3, 2017 at 1:50 pm
I will have to see if I can post the DelimitedSplit8K function to our DB.
Thanks
July 3, 2017 at 1:06 pm
Let me restate my original issue. There is a comma deleted value (sometimes there is only one value) that are indexes (i.e, IDs) into another table that has a value. ...
July 3, 2017 at 11:17 am
We got into a situation where we had to create an MS-Access application for a business need in a hurry. The application was created and supported by one person...
July 19, 2016 at 9:39 am
Our organization health care premiums are per person. So if you have four family members to cover then it would be the rate X 4. We have several...
March 8, 2016 at 7:15 am
Sounds like a maintenance nighmare. But if each department has solid IT staff to keep up on licensing and updates, then it might work. I work for a...
April 22, 2015 at 3:49 pm
I do not know much about Try, Catch and Throw. But I got rid of all of the semicolons and the code ran without an error on MS-SMS 2008.
April 10, 2013 at 11:22 am
Viewing 15 posts - 1 through 15 (of 16 total)