Browse by Tags

Tagged Content List
  • Blog Post: 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....
  • Blog Post: Microsoft SQL Server - What is in it for a DBA ?

    http://www.youtube.com/watch?v=TVbHVMuiAkQ
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Data Cubes

    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...
  • Blog Post: 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…....
Page 1 of 1 (16 items)