I believe Excel is more often used for professional data analysis than MS Access. What functionality is missing from Excel that she finds in MS Access?

Here is my proposal.

First, Backup w/ verification and duplicate backups.

o Drop all foreign keys, indexes, including clustered, from OLD tables that will be altered. It will free up workspace, and...

Dale Turley (10/15/2015)

---

I recently left a position I had been in for 6 years - as SQL DBA, Developer and Support - for a new challenge, a bit of extra...

fernando.arias (10/15/2015)

---

Though, would there be any solution for the problem you presented. If there are two persons with the same name one of the will be deleted. Can I avoid...

Kristen-173977 (10/15/2015)

---

How does the APP write to a text file, for later bulk-import, in a multi-user friendly way? Isn't it going to have to open the file, lock it,...

maxlezious (10/15/2015)

---

Hi Eric,

Thanks for your reply. I have made my mind up and have decided to sign the contract with Company A. Hopefully as I get more experienced in the...

ZZartin (10/15/2015)

---

I find it amusing when they start fighting over KB of memory 😛 Or the scene where they map a bios 1 clock cycle at a time by...

maxlezious (10/14/2015)

---

Hi Lowell,

Thank you for your advice.

I agree with you that once i have crossed the 35k mark it will be easier for me to get equivalent or even higher...

Now, does anyone know how to do the equivalent of this on Android and iPhone?

Block unwanted advertisements with /etc/hosts file on Linux

http://www.putorius.net/2012/01/block-unwanted-advertisements-on.html

One option is to identify the domain name of the site hosting the advertisement and block it by adding an entry in your ..\system32\Drivers\Etc\HOSTS file.

The following contains more detailed instructions...

Modify the FOR XML subsquery to contain a DISTINCT clause on the ','+InvNo expression, which also requires adding the same expression to the ORDER BY clause.

SELECT DISTINCT ',' + InvNo

...

Lowell (10/14/2015)

---

My advice would be to take the better paying job right now. no doubt.

once you are at a higher rate, it is very , very doubtful that you would...

Go with whatever job sounds the most promising in terms of your interest, opportunity to learn new things, and where the organization has big plans in the works. That's the...

This guy must have gotten the most laughs of any tech conference presentation. 😛

https://www.youtube.com/watch?v=yL_-1d9OSdk

https://isotropic.org/papers/chicken.pdf

One design consideration for an application event logging table is the acceptable latency between when the event occurs and when the record is available for querying. If we're talking about...