Get flash to fully experience Pearltrees
Democratize Big Data HDInsight is Microsoft’s 100% Apache compatible Hadoop distribution, supported by Microsoft. HDInsight, available both on Windows Server or as an Windows Azure service, empowers organizations with new insights on previously untouched unstructured data, while connecting to the most widely used Business Intelligence (BI) tools on the planet.
March 12, 2013 by pinaldave “Don’t use functions in the WHERE clause, they reduce performance.” I hear this quite often.
Over the last few years, I’ve put together a list of best practices for installing Microsoft SQL Server 2005 and 2008 and 2012.
Sometimes you find yourself in need of a way to prevent or alter the execution of a query, stored procedure, or SQL Agent job while some (other) crtitical SQL Agent job is executing.
Microsoft have made announcements about bringing Hadoop to Windows, but what does that mean for SQL Server? In this talk, Jeremiah Peschka will cover a the Hadoop ecosystem at a high level and discuss specific use cases for Hadoop. By the end of this talk, you should have a general idea of how different parts of Hadoop can be used to augment SQL Server’s rich functionality.
Free SQL Server Training The internet has many free training resources for SQL Server DBA's and Developers. They include tutorials, whitepapers, webcasts, videos, and podcasts.
Editor's note: At press time, Embarcadero Technologies released ER/Studio XE, the successor to ER/Studio Enterprise 8.5. Although there wasn't enough time to review ER/Studio XE for this comparison, it'll be reviewed in a future issue. Data modeling software can help you get a picture of what your database environment looks like and what it contains.
It’s been a crazy month, with lots of drama all over the place.
In computer science , ACID ( Atomicity , Consistency , Isolation , Durability ) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases , a single logical operation on the data is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction. The chosen initials refer to the acid test . [ citation needed ]