Tuesday, August 25, 2015

Moving Your SQL Infrastructure to Microsoft Azure

Just Another Big Business (JABB) Systems International is a fictional, 2,400-employee business with global offices. It manufactures security equipment, such as surveillance systems, alarms, bulletproof glass and cars, safes and related technologies. Its IT team of 15 is responsible for the day-to-day running of its datacenters, as well as improving the business through innovative use of technology.


Saturday, August 15, 2015

SS SLUG August 2015 Meet-up


SS SLUG August 2015 Meet-up

  • 11th Floor, DHPL Building
    No. 42 Nawam Mawatha
    Colombo 00200, Sri Lanka

  • 18:00 - 20:30 (UTC+05:30) Sri Jayawardenepura
  • Language: English

We're back after a month's hiatus. We're sorry that we couldn't hold a meet-up last month. This month we've got two exciting sessions lined up for you...

SQL Server Full Text Search
Ravin Perera, Tech Lead Geveo Australasia

Natural text-search capabilities are a must in modern applications. As SQL Server developers, what are the technologies we can use to provide search-engine-like features in our applciations? "Lucene.Net" is very popular, but comes with a huge integration and administrative overhead. In this session we'll explore the SQL Server built-in Full-Text Search feature which allows developers to fulfill most of the common natural text search needs with zero management overhead. You can integrate natural text-serach capabilities into your databases right away!

About Ravin:
Ravin is a Microsoft certified developer and certified scrum master, who has worked on various types of projects. Connect with Ravin on LinkedIn and Facebook (https://lk.linkedin.com/pub/ravin-perera/2b/466/61b|https://www.facebook.com/ravinsp)

Data Mining: Microsoft Time Series
Dinesh Asanka, Senior Database Specialist Pearson Lanka

Continuing with his data mining series, Dinesh joins us with the Microsoft Time Series algorithm. This algorithm provides regression algorithms that are optimized for the forecasting of continuous values, such as product sales, over time. Learn how to predict trends based on the original data set and add new data to the model and automatically use this data in your analysis.

About Dinesh:
Dinesh is a SQL Server MVP and a long time database enthusiast, and has been contributing to the database community for several years through his blog, technical forums and various speaking engagements. He is also a visiting lecturer at the Sri Lanka Institute of Information Technology

Thursday, August 13, 2015

Dealing with an Inherited SQL Server

If you work with SQL Server you’ve most likely been there at one time or another. Maybe you’ve just started a new job, or you might be a Windows administrator who has been tasked to manage SQL Server, or you might be a consultant who has been brought in to deal with a specific problem.  The end result is that you wind up working with a SQL Server instance and one or more databases that you know nothing about.

More at http://sqlmag.com/sql-server/dealing-inherited-sql-server

Saturday, August 8, 2015

SQL SERVER 2016 Data Sheet

SQL Server 2016 has multiple enhancements such as

Mission Critical Performance
Deeper Insights Across Data
Hyper scale Cloud

Below is the link to the Data sheet.
SQL Server 2016 PDF data Sheet