Category: Tools

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…

Visual Studio 2015 and whatnot…

TweetAn exciting news to Development world about Visual Studio 2015. Catch up all the excitement from Visual Studio 2015 release Event. If you have a MSDN subscription then all you can do is download the latest version of Visual Studio 2015…

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…

New official blog for SQL Server Integration Services (SSIS)

TweetHere is an exciting news from SSIS product team about a dedicated blog site on the subject matter. Checkout new SSIS product team blog site and  any new announcements and updates will be published on this site. For any previous posts on this subject, they…

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.…

Power BI .. a toolbox that you need for your BI engine

Tweet16Power BI – a Self Service Business Intelligence (SSBI) tool and a Software-as-a-Service (SAAS) cloud based analytical solution from Microsoft. Once you are assured about what is essential on BI aspects you need to know about what kind of tools and…

Save your day with SSAS Partition manager : Automating OLAP cube deployment, dynamic partitioning and processing

Tweet With the current explosion in data volumes, as an Architect/DBA/Developer you need to adopt certain techniques & practices surrounding deployment, data management and administration on a larger scale. If you are a SQL Server user then you aren’t new to table…

BIML – What do I need to know?

Tweet  Whenever I get to know about a new feature/concept within SQL Server I always remember the quote from Socrates – I am the wisest man alive, for I know one thing, and that is that I know nothing. Though I sound…