Monday, January 27, 2014

SS SLUG January 2014 Meet-up Recap

The first SS SLUG meet-up for this year was held at Microsoft Sri Lanka on January 22. We had two sessions on database development and data mining, with 47 attendees in total. Here's a summary of the event, including pictures and downloads

If you had missed the December 2013 meet-up or need to see the action, see these links:

diGIT Live Blog | Photo Gallery | diGIT Photo Gallery | Downloads | Video

Friday, January 17, 2014

January 2014 Meet-up

Session #1

TITLE: Predictive Modeling with the Microsoft Naïve Bayes algorithm

Join this session where Dinesh showcases the capabilities of predictive analysis using the Microsoft Naïve Bayes algorithm. Naïve Bayes is a classification algorithm that ships with SQL Server Analysis Services and is used to mine for and predict outcomes based on selected parameters.

CATEGORY: Business Intelligence (Data Mining)

SPEAKER: Dinesh Asanka (MVP), Database Specialist (Pearson Lanka)
Linked.In | Blog | Facebook | @dineshasanka

40 minutes approx.

 

Session #2

TITLE: Writing Resilient T-SQL Code - Part II

Continuing from where he left off from November's session, Gogula will guide you through writing better T-SQL code that is more resilient to unexpected issues and common code failures. This session is based on the book Defensive Database Programming by Alex Kuznetsov.

    CATEGORY: Development

    SPEAKER: Gogula G. Aryalingam (MVP), Technical Architect (Navantis)
    Linked.In | @gogula | Blog

    40 minutes approx.

     

    Time & Location

    JANUARY 22, 2013 - 6:00 PM Onwards at MICROSOFT SRI LANKA

    11th Floor, DHPL Building, No. 42, Nawam Mawatha, Colombo 2, SRI LANKA

    An excellent opportunity to network and learn. Refreshments provided.

    Entrance FREE

    Tuesday, January 14, 2014

    AI Search Samples

    Just for a moment , I moved away from standard database discussions and thought of writing something about AI.

    This is something I did for my one of the assignment calls Artificial Intelligence Search.

    I used Indian Airlines as a scenario to demonstrate AI search features.

    Breadth First Search

    Depth First Search

    Greedy Search
    Uniform Cost Search
    A* Search

    Saturday, January 11, 2014

    Watch out for SQL Server 2012 licensing pitfalls

    Licensing is little puzzling with all the technologies like virtualization and cloud around.

    This article should give us some what understanding about licensing.

    Friday, January 3, 2014

    What is LocalDB?


    It is a new version of SQL Server Express dedicated to developers to help them avoid a full installation of other editions of SQL Server.

    Benefits.
    bullet Small installer. The 32-bit version has 28.2 MB and the 64-bit version has 33.7 .
    bullet Simplified. It does do not require configuration or administration.
    bullet Run as a low privileged user.
    bullet Simple installation.
    bullet Offers the same T-SQL language as SQL Server Express. It supports stored procedures,  geometry and geography data types, triggers, views.

    Limitations.
    bullet It does not support Windows XP, Windows Server 2003, Window 2000.
    bullet It does not support WOW. LocalDB doesn't support installing 32-bit version on 64-bit Windows.
    bullet Allows only local connections. Only Named Pipes connections.
    bullet Only SQL Server 2012 Management Studio (on a computer updated with .NET Framework 4.0.2) can be used to manage LocalDB. SQL Server Management Studio of previous versions of SQL Server cannot be used.
    bullet Visual Studio 2010 RTM does not support LocalDB.

    Read more at http://www.sqlcoffee.com/SQLServer2012_0004.htm