Microsoft, SQL Server, SQL Server Sri Lanka User Group, SS SLUG

SS SLUG Kaleidoscope – May 2012 Action

After a month’s break SS SLUG came into action, but with a low attendance this time, probably because its the season of convocations and many of the regular attendees were missing or lack of communication about the meeting. Nevertheless, this month’s meeting was pretty concise and compact, likewise the post comes out short and early.

The meeting kicked off with two sessions that were lined up for the evening.

  • Windowing Functions in SQL Server by Dinesh Karunarathne
  • Breaking an SQL Myth in 300 Seconds – Table Variables with less data does not go to tempdb by Dinesh Asanka (MVP, SQL Server)

Dinesh K. explained that Window Function, is primarily a function that affects a particular set of rows and there are three types of Window Functions.

  1. Ranking Functions
  2. Aggregate Functions
  3. Analytic Functions

He did an in-depth explanation of each type along with a small demonstration. With regard to the third section, he went on to explain the new improvements in SQL Server 2012. A side comment was made that, this function thought it seems very useful, doesn’t come that handy with big data sets.

Next in line was Dinesh A., with a new segment, where he had to bust an SQL myth within 300 seconds. The myth for the evening was, “Table Variables with less data does not go to tempdb“. He proved a point with a demonstration on Temp Tables Vs Table Variables Vs CTE.

Overall view, this time meeting compared to the previous meetings was played at a lower key. So let’s see if June will raise the bar higher…

Advertisements
Programming, SQL Server, SQL Server Sri Lanka User Group, SS SLUG

SS SLUG Kaleidoscope – January 2012 Action

After celebrating the success of the last October meet up for two months, the first SS SLUG meet up for 2012 was held on the 18th. Last meet up had a significant turn out, where the place seemed too small to accommodate the attendees. But disappointingly, this time there was a lesser crowd.

Getting down to real business, the meet up was lined up with two sessions.

Before hitting off with his session, Dinesh A. mentioned that the content of his presentation was taken from msdn. According to which, Resource Governor, is a feature available in SQL Server, where it allows you to set limits on the resource consumption of SQL Server workloads and in turn help you manage your workload. Then he elaborated on the main concepts of Resource Governor,

  • Resource Pools
  • Workload Groups
  • Classification

What was to be noted was the mentioning of the creation of two resource pools and mapping of workload groups when SQL Server is installed.

  1. Internal resource pool and Internal workload group
  2. Default resource pool and Default workload group

The interesting part is that, the Internal group and resource pool act as the highly privileged or reserved. You cannot or should not try to modify it, because the basic commands are specified for those and are not accessible for modifications. The session ended with a comprehensive demo of how to assign a maximum and minimum CPU usage percentage for an SQL Server workload and there by monitor the CPU usage as well.

Next on stage was Dinesh P. whose session was a bit overhead for a newbie like me, but still was worthwhile for those who are well grounded in the arena. Initially he planned of getting an audience involvement by starting off an open discussion on what everyone has done to eliminate round trips. But as usual it took a fortune to get the people talking 🙂 Moving on, he spoke of the various difficulties faced and then came to the point on how to solve the issue. What I picked up was, which I wasn’t aware of, a data type called the “Table Data Type“. Dinesh did a demo on how to use the data type and Merge technique to eliminate roundtrips.

Overall rating of the session was GOOD 🙂 Am I looking forward for the next meet up?? YES, let’s see what they’ve got next time 😉

Programming, SQL Server, SS SLUG

What’s the big deal about SQL Server 2012??

SQL ServerMicrosoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization“.

Unless you were living under a rock, you must be aware of the ongoing revolution in the SQL Server world about the much anticipated release of SQL Server 2012 formerly known as SQL Server Denali. The SQL Server 2012 Release Candidate was released last week.

And if your thinking that this is gonna turn out to be another blog post on the performance of the release, you better think twice. I’m not an expert in the development of the release nor do I have a clue of what the hype is all about, but I would like to bring out what I think from an eye of an IT student by connecting the dots and and pieces of what I’ve heard and read.

Just like all software products bring in new versions by improving the flaws of the previous versions and coming up with new adornments to the existing product, the newer version of SQL Server also, successfully maintains the good old tradition. Well, according to the Release Candidate 0 announcement, what can the users enjoy??

  • Greater Availability
  • Blazing fast performance
  • Rapid data exploration
  • Credible, consistent data
  • Optimized productivity

So the buzz is all about these new/ improvised aspects of the product. If you take the track records, you can see the contribution of many tech brains to achieve its current status. But a sure thing is, SQL Server 2012, is not THE Flawless product and we could expect something better than this in the future as well. It’s just another Key milestone of the SQL Server Development!