Data > Knowledge > Intelligence
column Store index
Great Indian Developer Awards
Project based development
Self Service BI
SQL Server 2012
SQL Server 2014
SQL Server 2014 CTP2
SQL Server Data tools
Tech Ed 2013
Browse by Tags
Data > Knowledge > Intelligence
sql server 2012
Tagged Content List
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....
23 May 2014
Microsoft SQL Server - What is in it for a DBA ?
8 Oct 2013
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...
5 Aug 2013
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...
18 Jun 2013
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 would make the IT team very transactional and operational. Reporting tools no doubt have...
16 Jun 2013
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...
26 May 2013
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...
21 May 2013
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...
13 May 2013
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...
10 May 2013
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 workbooks that use PowerPivot or PowerView if this data comes from external data sources. The best size compression can be achieved for workbooks...
28 Apr 2013
SQL Server Data Tools (Part2)
In my previous blog on SSDT, we saw the advantages and ease of use for “connected development”. http://blogs.msdn.com/b/data__knowledge__intelligence/archive/2013/03/29/sql-server-data-tools-ssdt.aspx In this blog, let us see how SQL Server Data tools can be used for Project Based Development...
3 Apr 2013
Business Intelligence Semantic Model (BISM)
Hi, The attached pdf was presented at Teched Bangalore and Pune in March 2013. Many of you have asked for slides to be shared and hence I am uploading the same here. Will look forward to your questions and views here
1 Apr 2013
SQL Server Data Tools (SSDT)
SQL Server Data Tools (SSDT) is a Visual Studio Suite that allows database users to build, debug, maintain and refactor database objects. It supports code navigation, intellisense and provides for automatic source control. With SSDT, databases can be published just like websites. The previous two sentences...
29 Mar 2013
Big data, Big deal
Today, more data is being produced every year than the entire history of human civilization since 2000. How does one Analyze and Visualize this data? Apart from the V olumes, the V ariety, the V elocity with which it flows in is paramount. This “VVV” data has to be managed, enriched and an...
18 Feb 2013
The term “Cube” is not new. Most of us would associate it with Rubik cubes, invented by the Hungarian sculptor and professor of architecture in 1974. It was so popular that in 1980 Germany recognized it as “German game of the year” Children or the childlike would associate...
30 Jan 2013
The world of Business Intelligence
Rain, Rain everywhere, but not a clean drop to drink Data, data everywhere, but not a reliable byte to impact Business In the good old days, data existed in memory (of the human brain) and passed on from the t eacher to the taught, from a mentor to the mentee, from a parent to a child…....
10 Jan 2013
Page 1 of 1 (16 items)
© 2014 Microsoft Corporation.
Privacy & Cookies