Dalkeith (3/24/2016)

---

I do wonder sometimes whether something like Watson could be developed to produce a truly objective job applicant decider. I'm conscious that everyone is slightly biased when it comes...

If what you're describing in a scenario where each SQL Server table is added to the MS Access project as a linked table, and then you're joining linked tables together...

The following will check for and extended property called 'MICROSOFT DATA QUALITY SERVICES - DQS' across all databases, returning one row for each match.

exec sp_MSForEachDB

'

USE ?;

if exists

(

...

Not only does a language like T-SQL abstract us from internals (although we can view at the sequences of high level operations performed by the execution plan), but the execution...

If you have power users or 3rd party applications that insist on connecting as 'SA', then you can fake them off by renaming original 'SA' account, and then recreating 'SA'...

This cartoon reminds me of that 1995 SciFi movie 'Johnny Mnemonic', which takes the concept of a 'sneakernet' to a whole new level.

http://www.wired.com/2013/03/technology-johnny-mnemonic/

There was a forum discussion a few years back on how to prevent users from changing their SQL Server account passwords.

https://social.msdn.microsoft.com/Forums/en-US/237e5b91-c5ca-49b1-980b-1e0429279231/prevent-sql-login-password-change?forum=sqlsecurity

Consider something like the following. What it does it create...

The concepts of a corporate retirement pension or even seniority based on years of service are practically nonexistent here in the US, least of all within the IT industry. Our...

... The plan was to have the master copy of the database at the Admin office, and each remote location would have its own copy of the database on SQL...

Eric M Russell (2/25/2016)

---

Even if the data I lost was important to me, I would not pay the ransom, because there it's entirely plausible that it's part of a scheme...

Gary Varga (3/22/2016)

---

Me too. I have been...

Over the past decade, the bar has been raised regarding requirements for a DBA or data professional. That's good, but perhaps we need to reach out and be better mentors.

Also, consider setting up an Audit trace on account password changes.

http://www.toadworld.com/platforms/sql-server/w/wiki/10429.tracking-password-changes

Does the application normally login using the 'SA' account or using another account with SYSADMIN privillage? A user can change the password on any account for which they can login,...

HR and management like canned pop quiz style technical interviews (ie: What is a clustered index?), because they are straightforward, and they can add up the scores and easily stack...