A tweet chat on SQL 2014 – An excerpt

Did you take a vacation recently amidst nature? Did you join the weekend trekking group to hear the chirping sound made by young small birds?  Tweeting in the modern world does not hold the same meaning. The new form of tweets are opinions expressed by humans and followed by interested parties. A film celebrity could…


SQLite

Most database users are proud to say that they have worked on databases of large size.  For business processes, laying out the table structure with the data-types is an important skill called modeling.   In this new generation of applications (apps), developer community is looking at easy to use, no overhead to deal with small…

3

Forecasting Sales data with Excel mining – Step by Step Guide

Mining is a service and can be coded.  This means that it is enterprise ready. Mining can be done using Excel SSDT PowerShell and SSMS Analysis Services service should be “ON” for mining to run Using a combination of basic PowerPivot and Mining Plugins for Excel 2013, let us create a forecasting model. Open Excel…

2

Getting started with Self Service BI using Power View

Self Service BI capability is “THE” thing that senior executives want. IT on the other hand want it too. No matter how often the report format has been scrutinized there is always a tweak required which wouldmake the IT team very transactional and operational. Reporting tools no doubt have evolved over a period of time….


Great Indian Developer Awards – Visual Studio and Sharepoint

Folks, these awards excited me. Please see details below Even us database folks use Visual Studio either in the form of SSDT (SQL Server Data tools) or BIDS (Business Intelligence Developer Studio) Initially BIDS was used for development of Cubes and reports. Now SSDT is a single shell that can be used even to develop…


Data Mining Plugin for Excel 2013

Data mining option is a plugin for Excel 2013. You can build powerful mining models and even work with a range of data in excel sheet to exploit the power of mining in a simple and intuitive way. Download the data mining plugin for office 2013 from the link below. http://www.microsoft.com/en-us/download/details.aspx?id=35578 Once installed, you can…

20

Infrastructure as a Service for SQL Server (IaaS for SQL Server)

With “IaaS”, the usage of cloud has further increased productivity.  Infrastructure available as a service, offers Virtual machines which are available as templates.  So you can pick the size and the version desired and deal only with your application without having to worry about Infrastructure. SQL Server Virtual images available for SQL 2008 R2 and…


SQL Azure – An introduction

SQL Azure – why should you use it? Hardware sizing is always a chore that is more based on “guesses”. It is a difficult science to predict and forecast usage of database and its growth.  Having something elastic like “SQL Azure” makes it best for costs and maintenance.  SQL Azure gives a lot of flexibility…

10

PowerPivot & PowerView can hold more data with Workbook Size Optimizer

Workbook Size Optimizer http://www.microsoft.com/en-us/download/details.aspx?id=38793 The Workbook Size optimizer for Excel can better compress data inside workbooksthat use PowerPivot or PowerView if this data comes from external data sources.The best size compression can be achieved for workbooks based on SQL Serverdatabases and there are a few tricks we can do for other SQL datasources aswell. The…