Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items within SQL Server that I consistently use to help me design and troubleshoot solutions. SP_Who SP_Who is a system stored procedure that returns information on what is currently running on your SQL box. It shows … [Read more…]
Azure HDInsight Overview HDInsight is a cloud based implementation hosted in the Microsoft Azure cloud. It enables you to quickly create, expand and delete a Hadoop cluster installation as your project dictates. For organizations just beginning to see how Big Data could be leveraged to solve business problems. A HDInsight implementation gives you a flexible … [Read more…]
SQL Server 2014 Below is a listing of the SQL Server 2014 new features and where you can find more information on them. Analysis Services Power View is now able to access Multidimensional models in SQL 2014. Complete information is available at MSDN Database Engine Included in the new release are following features: Memory-Optimized Tables … [Read more…]