sql

youtube

Btw, if someone’s interested in learning how to code, Codecademy is a great (and I mean not boring) way to learn some basics.

And listening to this song on repeat one, I finished this in two days! :D

It’s not much, but it’s a start! 😸

bit.ly
Results of the Australian words survey
Map created in CartoDB
By rbil

Last week I put up a link to a survey of Australia word choices. The thing went nuts, making it into the news a lot, and getting so many responses that the thing crashed temporarily on Friday. I helped the the Linguistics Roadshow team make the maps of the responses, and it’s been a good learning experience.

The link above is to the potato cake/scallop question - a vexed topic. You can see a rather clear dialect line between Victoria and New South Wales. This version of the same map below allows you to zoom around the map.

Another contentious topic we’ve discussed before is the water bubbler vs. drinking fountain.

There is a bit of variation here, but still a strong north/south divide.

Another clear distinction is the preferred pronunciation of ‘dance’ - with Adelaide speakers showing their unique sensibilities.

You can see all the maps on this Linguistics Roadshow page. Not all of the maps have such clear divisions based on location. This was a delibrate design to get the students talking about what non-geographic reasons there may be for some differences.

Working with CartoDB is great fun, and the best program I’ve come across for pretty and easy map making. These maps populate directly from a Google Form spreadsheet, meaning they’ll continue to grow as more people do the survey. It was was the reason that we had some dramas when we easily exceded the daily response limit (protip, if you have a uni account use that to set up your Google Form and CartoDB! Thanks to andrewxhill for his SQL for separating points at the same coordinate, and thanks to this Andrew for getting it to work with our data. A big thank you also to the CartoDB team who helped us get the maps back up and running.

The maps were written up in The Guardian, Fairfax outlets and Junkee.

You can see all the maps on the Linguistics Roadshow website.

A more detailed survey is being done by Sydney Kingstone at ANU. You can take part in that one at ozenglishstudy.wordpress.com.
RPGLE - Implicit Embedded SQL

In my most of my posts, you might notice that when I used embedded SQL I always explicitly specify a Dim on the arrays that I use for the SQL. In this post, I don’t.

Here I am showing off that you can use embedded SQL with no limits - an unlimited amount of data.. just like using your old Chain & Read

       Dcl-Proc Process_LCLEARSM;
         Dcl-S  lCounter Int(5);
         Dcl-Ds LCLEARSM Qualified;
           SMCLEARID Char(10);
           SMSTKMOV  Packed(11);
         END-DS;
    
         gQuery = 'SELECT '
                +   'SMCLEARID, SMSTKMOV '
                + 'FROM LCLEARSM';
    
         EXEC SQL
           PREPARE SMQuery FROM :gQuery;
         EXEC SQL
           DECLARE SMCursor CURSOR FOR SMQuery;
    
         EXEC SQL OPEN SMCursor;

         //DOW Class Code 00: Unqualified Successful Completion
         Dow SQLSTT = '00000';

           EXEC SQL
             FETCH SMCursor INTO :LCLEARSM;

           API_DeleteItem(LCLEARSM.SMSTKMOV);

         Enddo;            
       END-PROC;
    

You can read about the SQLSTT variable and it’s uses here.

This will loop through each record, and won’t jump through if there are no records. Very useful if you have lots of data.

One and Done.

Mr applied for one job (long story) and after three interviews he received a job offer.

After four years of living off of my income, the end is in sight!

Mr reads my blog, so send him some love.

Congrats Mr, Junior SQL Developer!

Achieve 24/7 SQL Monitoring with SQL Diagnostic Manager

  • Performance monitoring for physical and virtual environments
  • Query plan monitoring to see the causes of blocks and deadlocks
  • Integrated SQL Doctor expert recommendations
  • Easy integration with Microsoft SCOM
  • Predictive alerting with settings to avoid false alerts
  • Web-based dashboard with at-a-glance views of top issues and alerts

Physical and Virtual Performance Monitoring

Easily monitor and view the performance of both physical server and VMware or Hyper-V virtual server environments to get a complete view of SQL Server databases. View performance metrics and alerts for virtual machines and their related hosts including CPU, memory, disk usage, network etc. to get a complete performance picture of the SQL server environment.

Query Performance Monitoring

Identify and monitor inefficient and poor performing SQL queries, batches, statements and stored procedures causing blocks and deadlocks, such as long or most frequent queries or queries consuming unusually high CPU or I/O. Thresholds can be configured on each individual server allowing for greater flexibility, and the interface makes it very easy to see the most costly queries by looking at individual query executions or query signatures.

*New* Integrated SQL Doctor Expert Recommendations

Expert recommendations from IDERA SQL Doctor are now integrated into SQL Diagnostic Manager. Enhance performance and speed up problem resolutions with built-in tuning advice and best practices developed by SQL Server MVPs. These updated recommendations are integrated into analysis workflows and provide specific guidance to address problem issues including automatic corrective scripts and links to related online content to supercharge your SQL Server performance.

Query Plan Diagnostics

Dig deep into problematic queries with new query plan diagnostic capabilities. View high level query performance information across applications, databases and users with enhanced drill down capabilities into individual queries to view detailed SQL text, execution plan XML, and graphical views of execution plans.

Predictive Alerting

Avoid false alarms with adaptive alerting functionality and set alert thresholds based on built-in historical statistical analysis of your server performance data. Read more…

Capacity Planning

Understand trends and view forecasts of your SQL Server environment to better plan for future needs and get a handle on SQL Server sprawl with database growth reporting.

Mobile Access

Access SQL Diagnostic Manager from anywhere. Use any mobile device, such as iPhone, Android, Blackberry or Tablet to view real-time and historical SQL Server performance data. Plus, view or kill sessions, start/stop jobs and run queries to resolve or diagnose issues remotely while on-the-go.

Web Dashboard

Log in from anywhere and quickly check the status of monitored server instances to identify and diagnose issues. View the current status of monitored instances, drill down into single instance details, view the top occurrences of performance issues, and see a rollup of all active alerts. Customize your display with eighteen new widgets, enhanced heat map view, and query wait state visualizations. Create any number of individually configured dashboards to address the needs of the entire organization.

Integration with SCOM

The SQL Diagnostic Manager Management Pack provides easy integration with Microsoft’s System Center Operations Manager (SCOM). The Management Pack propagates the current status, health and events of all monitored instances up to Operations Manager, allowing the DBA and IT Operations staff to share data at a higher level across their enterprise. The management pack is easy to install and does not incur any additional monitoring overhead. Read the FAQ and watch a quick 5 minute videoto learn more.

Source: [click]