Parallel I/O aside, it's worth mentioning that files and file groups can be backed up, restored, detached, attached separately, which can potentially decrease downtime for very large databases when performing...

To start, you want all accounts to be operating under least privilege. Look at what logins have sysadmin, dbo, or db_datareader access. The following script will lust what accounts, domain...

Not only does full disk encryption protect your data in the event of theft, it also renders the device practically unusable or at least the thief now has to invest...

Rather than a correlated sub-query, you could take a stab at simply select from tbl1, tbl2, tbl3 and then wrap another aggregate query around it; in other words a non-correlated...

I've seen references to folks having issues upgrading...

mastersql (12/14/2015)

---

Can Bitlocker be installed after the Window OS has already been installed?

The website says that the OS has be installed first which is problem for Home Users who...

Whether you're more or less productive working away from the office depends on what stage of the project lifecycle your team is in. Working from home can be productive when...

SQL Server's default Read Committed isolation works in an OLTP database, so long as you keep both your transactions and your query access methods short and optimized. As for bulk...

Rod at work (12/11/2015)

---

Eric M Russell (12/10/2015)

---

MMartin1 (12/10/2015)

---

Eric M Russell (12/10/2015)

---

In many cases the interviewer doesn't really know what they're asking about, and this...

Generally speaking, an ODS consolidates data (typically by periodic bulk loads) from multiple sources into a common (typically normalized) schema while conform the meta data coding (ie: M = Male)...

MMartin1 (12/10/2015)

---

Eric M Russell (12/10/2015)

---

What amazes me is how may times I would decide half way though an interview that I'm really not interested, spend the rest of the interview...

What amazes me is how may times I would decide half way though an interview that I'm really not interested, spend the rest of the interview checking my watch and...

MMartin1 (12/10/2015)

---

Eric M Russell (12/10/2015)

---

In many cases the interviewer doesn't really know what they're asking about, and this would be the guys who asked...

In many cases the interviewer doesn't really know what they're asking about, and this would be the guys who asked a lot of syntax...

Yet Another DBA (12/10/2015)

---

Gary Varga (12/10/2015)

---

Eric M Russell (12/9/2015)

---

GoofyGuy (12/9/2015)

---

Eric M Russell (12/9/2015)

---

GoofyGuy (12/9/2015)

---

If the promise of quantum computing is realised, a great deal of data might be stored in...