First, it's unclear whether you know the basic concepts of dimensional modeling, requirements gathering, or ETL at this point. So before you start building anything, I highly recommend you read...

A "crash" is a series of events, not a single moment in time. You need to know an ideal point in time for which to perform a transaction log restore?

It's hard to believe there are 1 billion active yahoo email accounts. 100,000,000 of them are probably drop boxes for phishing scammers.

Remember when Microsoft offered to buy Yahoo for $45 Billion back in 2008? Yahoo said no, because they felt the deal was undervalued.

David.Poole (12/15/2016)

---

A particularly well timed editorial given the massive failure of Yahoo to secure it's customers data or behave appropriately in response to an immense hack as reported on BBC...

If the two servers are located on-premises, like in the same rack or server room, then perhaps you can connect them directly using a crossover network cable.

Trying to extract meaningful consumer information from ExaBytes of IoT data is about like trying to extract gold from sand. There are other companies like SurveyMonkey that have a much...

If we can leverage millions of interconnected IoT devices and BigData to better predict the weather or crime, then that's a big win. I'd love to wake up each morning...

xsevensinzx (12/14/2016)

---

Gary Varga (12/14/2016)

---

Eric M Russell (6/9/2016)

---

I predict that within 5 years the Internet of Things, Social Media, and Big Data will be passé. Companies just can't find a way...

I believe that developers and DBAs can both benefit from advanced T-SQL training.

It is possible to revert a source database from a database snapshot, but any changes made to the source database in the interim will be lost. Perhaps the best solution...

Perhaps the network administrator didn't want to be the primary point of contact for support calls over the Christmas holidays.

Yes, every developer should use a VCS (version control system). When I have...

If a user is a member of DB_OWNER, then they own your database and can do whatever they want with it. DB_DATAREADER grants a user permission to read from any...

A BIT datatype can be NULL.

Also, an integer columns can be used to contain multiple bitwise values (TINYINT 8, SMALLINT 16, INT 32, BIGINT 64).

https://www.mssqltips.com/sqlservertip/1218/sql-server-bitwise-operators-store-multiple-values-in-one-column/