Database
Get flash to fully experience Pearltrees
Big Data | Microsoft SQL Server
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.
Avoid Using Function in WHERE Clause – Scan to Seek | SQL Server Journey with SQL Authority
Over the last few years, I’ve put together a list of best practices for installing Microsoft SQL Server 2005 and 2008 and 2012.
SQL Server 2005/2008/2012 Setup Checklist
PostgreSQL
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.
TSQL function to detect SQL Agent job state
Hadoop Basics for SQL Server DBAs
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.Business Intelligence
Performance
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.
Free SQL Server Training Resources
Data Modeling Software Comparison Review
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.
Clean Up Weird Characters in Database
SQL2012
SQL2008
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 ]
ACID