Category: DBA

Features supported by the editions of SQL Server

TweetThere are certain instructions you need to be aware of features supported by different editions of SQL Server. Since the version 2012 (still applicable on 2014 & 2016 CTP2)  Microsoft has divided the number of specifications on editions perspective to accommodate unique…

SQL Server 2016: Concepts and architecture for Stretch Database

TweetThe new feature set within SQL Server 2016 (in CTP2.2 as of today), not just simple enhancements or easy features there will be a big changes to come as compared to previous releases. As there is a flood of information…

Power BI Desktop update

TweetAn updated version of Power BI Desktop is available for download now, this improved version includes an analytical creativity by adding color, fomatting control and images. SO get your existing Power BI replaced with this new version. Download Microsoft Power…

SQL Server Management Studio June 2015 Preview

TweetHere is the good news for SQL Server users, especially DBAs! A ‘preview’ (first one though) release of SQL Server Management Studio (SSMS), which will have a separate release services outside of SQL Engine releases. All you need to do…

SSMS – Proactive Management Tools in a Single Console

TweetHow to keep up data platform predictable performance? Is it possible to have a built-in capabilities that help make performance more consistent and predictable? No doubt to say an exponential growth within server consolidations and multi-tenant data platforms managed within…

Power BI – Deployment and Configuration best practices to deliver just in-time insights

TweetSelf service BI (SSBI) is a straight forward solution for the end-users to design, analyze and mashup with best analytics on the data that resides within the organisation. There are many tools available and market leaders, few from open source and vendor-specific.…

Azure Marketplace – exciting apps and products for data platform solutions

TweetAzure Marketplace is a good place to find relevant applications (apps) and products to enhance productivity for your data platform. The marketplace (or play store in other words) has been featured with various services such as: Virtual Machines Application Servers API…