All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data
Options
Search Blogs
Tags
Archive
Archives

All things Data Related....

TechNet Blogs » All things Data Related....
Sort by: Most Recent | Most Views | Most Comments
Excerpt View | Full Post View

  • SQL Server Service Pack Roadmap

    Posted over 4 years ago
    by Shashank Pawar}
    SQL Server 2008 SP2 is scheduled for release in Q3/CY2010. SQL Server 2005 SP4. Yes there is going to be one. Expected release data is in Q4/CY2010. Based on current support volume as well as the fact that SQL Server 2005 will enter into extended support...

  • Microsoft BI Video

    Posted over 4 years ago
    by Shashank Pawar}
    As part of the BIEB series, a short video of mine explaining Microsoft's BI capability has been published on The Australian newspaper website. Hope you find it informative and quickly summarises the concept of PowerPivot coming out shortly in SQL Server...

  • Looking for a new way to browse the Web instead of just links

    Posted over 4 years ago
    by Shashank Pawar}
    …and if you love Pivot tables in Excel, then you are going to like this tool. Its called GetPivot , and it is from Microsoft Live Labs. It enables you to visually browse the web and then pivot (hence the name) on particular attributes, so for example...

  • Resource: Book on SAP integration with SQL Server

    Posted over 4 years ago
    by Shashank Pawar}
    Do you run SAP as your ERP systems? Do you also have SQL Server or SharePoint in your environment? Do you want to give your users easier ways to access the data in your SAP systems – let them be able to self-serve reports. Well if the answers to any...

  • The premier BI event you can't miss.

    Posted over 4 years ago
    by Shashank Pawar}
    We are excited to be hosting this year’s Microsoft Business Intelligence Conference 2010 in New Orleans, LA! We invite you to join us for this event which will showcase Microsoft’s market-leading business intelligence (BI) products, solution expertise...

  • SQL Server consolidation / virtualization Presentation

    Posted over 5 years ago
    by Shashank Pawar}
    I am going to be presenting a session on SQL Server consolidation at the SQL Server User group on 1st of July 2009. See below for details. Hope to see you there. Date 1st July, 2009 Time 12:00 Agenda 12:00 - 12:30: Registration / Networking / Product...

  • TSQL Script – Determining Default Database File & Log Path

    Posted over 5 years ago
    by Shashank Pawar}
    Below are two methods that can be used to determine the default location of data and transaction log files for your installation of SQL Server. This script can come handy when automating the deployment of databases in your environment.   Method 1...

  • Whitepaper: SQL Server 2008 Management Data Warehouse

    Posted over 5 years ago
    by Shashank Pawar}
    A best practices whitepaper was recently released discussing the SQL Server 2008 Management Data Warehouse feature.   It can be accessed at: http://msdn.microsoft.com/en-us/library/dd939169.aspx

  • SQL Server 2008 Developer Training Kit

    Posted over 5 years ago
    by Shashank Pawar}
    Want some FREE training on the new developer features of SQL Server 2008? Download this developer training kit from - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7 . This kit contains...

  • SQL Server 2008 Clustering White Paper

    Posted over 5 years ago
    by Shashank Pawar}
    This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout...

  • Teched Australia 2009 – Less than a month away

    Posted over 5 years ago
    by Shashank Pawar}
    Wow can’t believe it, Teched Australia 2009 is SOLD OUT!!! It must have something to do with those Netbooks with Windows 7 being given away:). I look forward to attending and meeting you there. Please ensure to attend a session I am presenting on SQL...

  • Running SQL Server 2008 on Windows 7 and Windows 2008 Server R2

    Posted over 5 years ago
    by Shashank Pawar}
    The following knowledge base article describes the known issues when you install Microsoft SQL Server on a computer that is running Windows 7 or Windows Server 2008 R2 . List of known issues when you install SQL Server on Windows 7 or on Windows Server...

  • NEW!!! Sydney SQL Server User Group !!!

    Posted over 6 years ago
    by Shashank Pawar}
    My mate, Victor Isakov (MCT, MCITP, MCM, SQL Ranger) is starting a new SQL Server User Group Meeting during lunchtimes in the Sydney CBD. It will run on the 1st Wednesday of every month, from 12:30 to 14:30, at Westpac Place. This new user group will...

  • Download - SQL Server 2008 System View Poster!!!

    Posted over 6 years ago
    by Shashank Pawar}
    SQL Server 2008 System Views - Map just went live and is available for download at http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en There is a 2005 version link in Related Downloads at the...

  • SQL Server 2005 Cumulative updates

    Posted over 5 years ago
    by Shashank Pawar}
    Cumulative Update #2 for SQL Server 2005 Service Pack 3 Keep your system up to date with the most recent cumulative update package for SQL Server 2005 SP3. This package contains all of the SQL Server 2005 hotfixes that have been released since the...

  • SQL Server 2008 R2: Multi Server Management Feature Survey

    Posted over 4 years ago
    by Shashank Pawar}
    As we are nearing to the release of SQL Server 2008 R2, I have been presenting about its new features and one that reasonates well amongst the DBAs is the multi server management. DBAs see this as a great way of getting insight into planned consolidated...

  • 5W1H of Master Data Services

    Posted over 4 years ago
    by Shashank Pawar}
    On the 26th of March 2010 evening I presented an overview of the Master Data Services at the Brisbane SQL Server User group held at the Microsoft offices in Waterfront Place, Brisbane. You might be wondering what is 5W1H, it is basically the: What? Why...

  • SQL Server 2008 R2 Tour Downunder

    Posted over 4 years ago
    by Shashank Pawar}
    The official launch of SQL Server 2008 R2 is set for the 12th May, 2010. To celebrate the launch, we are organising a tour, with seminars being held at Sydney, Melbourne, Canberra and Brisbane. At the complimentary seminars, Microsoft’s Alan Eldridge...

  • Update for SQL Server 2008 Developer Training Kit – Now includes SQL Server 2008 R2 material

    Posted over 4 years ago
    by Shashank Pawar}
    Download it from - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d   SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced...

  • To BI or not to BI?

    Posted over 4 years ago
    by Shashank Pawar}
    My blog post on the Australian IT news site has gone live, and can be found at - http://blogs.theaustralian.news.com.au/ontheradar/index.php/australian-it/comments/to_bi_or_not_to_bi/ . Please provide your feedback and comments.

  • Database Mirroring large number of databases

    Posted over 4 years ago
    by Shashank Pawar}
    Just in case you have missed it. The SQL CAT team have written up a great article that answers the question on just how many databases can you mirror within an instance. This helps to debunk some of the figures that were documented in SQL Server BOL....

  • SQL Server 2008 R2 and SQL Azure Whitepapers

    Posted over 4 years ago
    by Shashank Pawar}
    Kerberos/Double hop with SSRS From a infrastructure implementation of Microsoft BI solutions, one of the most difficult things to get right can be authentication between multiple servers in a scale out solution. This is known as the ‘double hop’ situation...

  • Its nearly that time of the year again–TECHED TECHED TECHED!!!

    Posted over 4 years ago
    by Shashank Pawar}
    Be early to register for Teched this year as you all remember last year was a sell out. This year is going to be fantastic with a whole lot of new products and technologies that were and are being released this year. Below are a list of a few: * SQL Server...

  • Off Topic – but useful none the less – Win 7 Trick

    Posted over 5 years ago
    by Shashank Pawar}
    Even though this is not related to SQL Server, I thought I would share it, as we know SQL Server runs on top of a OS – and it is always handy to know how we can configure the OS. PRODUCTIVITY TIP Do you spend precious time trying to find the right place...

  • Master Data Services Training Videos

    Posted over 4 years ago
    by Shashank Pawar}
    SQL Server 2008 R2 Master Data Services Training videos are available at - http://www.msdev.com/Directory/SearchResults.aspx?keyword=MDS