Randy Rabin (3/19/2013)

---

One thing I find interesting about our digital age is the ever-increasing rate of storage usage. 2.8PB is not a trivial number by any means, but how many...

Perhaps. I think we'll have 1TB on cell phones in 5 years. Not all phones, but higher end ones. Especially since Kingston announced a 1TB flash drive.

http://www.pcmag.com/article2/0,2817,2414107,00.asp

I can foresee 1PB...

AFAIK, this works the same as it does for filegroups without Filestream.

You can see some backup and restore here: http://www.mssqltips.com/sqlservertip/1854/how-to-backup-and-restore-a-sql-server-filestream-enabled-database/

I haven't tested a filegroup restore, but you should be able...

As Jeff mentioned, this is confusing. For Job ID 11, I see a 100 as Position 1, not 2. Or am I missing something?

Thanks, Ron. Appreciate the support and questions from you.

You absolutely can use stored procedures:

http://msdn.microsoft.com/en-us/data/gg699321.aspx

Personally I'd recommend building a good data model and database first, then point EF at it. However I'd search around for what other people have...

Great explanation from Craig. We have a few articles on the site as well:

http://www.sqlservercentral.com/articles/Performance+Tuning/usingbitmaskoperators/790/

http://www.sqlservercentral.com/articles/1251/

Great to...

umailedit (3/16/2013)

---

"SHA2 is recommended. Unfortunately you would have to upgrade to SQL Server 2012 in order to use this algorithm. "

You should never use hashing algorithms to store password. ...

I want one.

henrik staun poulsen (3/14/2013)

---

Hi Steve,

We also almost never run CHECKDB.

This is because it takes tooooooo long.

I'm taking something above 50 hours.

When we restore a backup onto our test system, the...

The instance starting has nothing to do with the administrator. I'm asking if you can connect from SSMS with the administrator account, the same one used as the SQL Agent...

mtillman-921105 (3/12/2013)

---

'Thought I'd change my avatar to me - or something that looks a little like me. I haven't been around SSC much lately, work's been way too busy....

Is this a valid instance name? Is it started?

If you connect to the instance with the same administrator account, does it work?