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/

If Microsoft does intend to stick with a new release every two years, just for the purpose of introducing new features to market and maintaining competitive advantage, then it should...

I agree that DBAs need to expand their skillset into development. However, instead of a .NET language, I'd suggest T-SQL (obviously and essentially), PowerShell, SSIS, and maybe SSAS/SSRS if that's...

Even if 2016 Standard Edition now supports some of the Enterprise features, that doesn't mean that SharePoint leverages them. The deciding factor should still be which Edition leverages your server's...

The problem is that you are converting the date to DD/MM/YYYY format, and that doesn't work properly with range logic. You need to use YYYY/MM/DD format or don't convert at...

On a medium powered OLTP database server, I would consider 100,000 rows or less to be a small amount of data. However, to understand the potential for blocking and duration...

Robin35 (12/9/2016)

---

Eric M Russell (12/9/2016)

---

Where I work, we use Octopus and Chef for automated deployments. If what you need is an account that can create a database, create objects within...