Poland SQL Day 2012 Women in Technology Panel Event

In May, 25th and 26th May, we would like to invite all of you for a ‘Women in Technology’ Panel at SQL Day2012 in Wrocław (Poland). We are looking forward to meeting you at SQLDay Poland in May 2012. I will be participating in the Panel, and I’m very excited about it!

The SQL Day 2012 conference is a great opportunity to make friends and learn with fellow SQL Family members in Poland. Therefore, we would like to add to the SQLDay fun! We are holding a ‘Women in Technology’ (WIT) panel meeting SQL Day 2012 in Wrocław (Poland) on 25th and 26th of May. We will have a team of women, who will swap ideas and discussions. We look forward to hearing your ideas too! The Panel will be held in Polish and English.

We will talk about the following topics. We are also keen to hear your ideas, too!

1. Keeping women in IT by mentoring, networking and career advice
2. How to attract younger women in IT
3. Career – what are the best ways to progress?
Men in Technology are also invited to the ‘Women in Technology’ panel meeting. Men are very welcome to the Panel too. It would be good for men to share their ideas, too. 

Although the panel members are women, these are ‘people’ topics in which everyone can learn something about career advancement.

The ‘Women in IT’ panel is arranged for the first day of the conference. If you would like more information, please email us on WiTPanel@plssug.org.pl  You can also find us here:


We look forward to meeting you!

Power View connection error – Resolved

When you’re starting off to create a visualisation in Power View, you might notice the following error:

rsCannotRetrieveModel
400 

http://www.microsoft.com/sql/reportingservices”>An error occurred while loading the model for the item or data source ‘http://sapphire/PowerPivot Gallery/HelloWorldPicnicPowerViewTutorialRC0.xlsx’. Verify that the connection information is correct and that you have permissions to access the data source.

When you read down to the foot of the error message, the error message becomes more specific. Here is an example:

A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running.


When you start up the ‘SQL Browser’ service, then the Power View visualisation works.  The SQL Server Browser operates as a Windows Service. It has two main roles: it listens for incoming requests for Microsoft SQL Server resources, and it provides information about SQL Server instances installed on the computer. If it isn’t running, then the connection fails since the data source can’t be found.




Upcoming National and International Speaking Events

The blog has been a bit quiet since I’m busy preparing for some up and coming events. Here is a list of some things which are keeping me busy!

Attunity hosted webinar – Faster Business Insights By Enabling Real-time Data For BI & Analytics, Webinar, 26th January

Reserve your space today! If users rely on reports that include stale or outdated information, the impact on ‘same day’ decision cycles is far greater than you think. Join us for this special webinar to hear industry business intelligence (BI) expert, Jen Stirrup share her insights about new advances in technologies to better enable real-time data for BI and analytics. Attend this webinar to learn about:

  • Best practices to achieve low-latency data movement
  • How to overcome costly obstacles to provide low-latency data movement
  • New cost-efficient techniques to enable real-time data for BI and analytics
  • New approaches for implementing change data capture (CDC) technology with data replication
  • Live demonstration
  • And a lot more!

In addition, Richard Thomas, Attunity’s Director of Technical Services will discuss how Attunity Replicate software plays a critical role to deliver real-time information across your organization. Plus, Jeff Cole, an Attunity Solutions Architect, will provide a live product demonstration. Don’t miss this opportunity.

Sweden SQL Server User Group at the World Trade Center, Stockholm, 30th January

We are pleased to announce that Jen Stirrup, joint owner of Copper Blue Consulting, will be participating in the Swedish User Group meeting on 30th January at the World Trade Center in Stockholm. Jen will be speaking, in English, on Data Visualisation and Business Intelligence.  If you’d like to register, please click here.

SQL Saturday Ireland Technical Launch for SQL Server 2012 at the Hilton Hotel, Dublin, 24th March

We are pleased to announce that Allan Mitchell and Jen Stirrup, joint owners of Copper Blue Consulting, will be giving individual presentations at the SQL Saturday event in Dublin on 24th March. Allan will be discussing Data Quality, and Jen will be discussing Data Visualisation and Business Intelligence. The event is supported by the Professional Assocation of SQL Server and we will be attending the after-event party. We hope to see you there! To Register, please click here.

SQLBits UK Technical Launch for SQL Server 2012, London, 31st March


Allan and I are both presenting individual presentations at SQLBits. Allan will be talking about CDC in SQL Server 2012. I’ll be talking about Data Visualisation and Business Intelligence in SQL Server 2012. The Saturday event is free, so please do come along and join us. The event will be held at the Novotel London West  and for more information, please register here. Incidentally the SQLBits site is Powered by SQL Server 2012, so it’s worth a look for that reason, too!

Importing Google Spreadsheets into Windows Azure Data Explorer

Hi! This blog will take you through the steps of importing a Google spreadsheet into Microsoft Azure Data Explorer. You could then play with this data by using data from the Windows Data Market. I think I love the Data Explorer so much because it allows a nice, easy format for mixing up data from different sources.  This activity takes the form of two steps: ensuring that the Google spreadsheet is published, and then importing it into Data Explorer.

The Google spreadsheet came from the fantastic Guardian Datablog, and it focuses on the New Years Honours list for 2012. In case you’re not British or from the Commonwealth, and wondering what I’m blathering on about, the New Years Honours List is a quaint British tradition which recognises outstanding achievement to people who serve their communities.  The original Guardian commentary can be found here.

The Google spreadsheet obviously belongs to them, so I needed to take a copy of it, and publish it to my own Google account. To do this, you click on ‘File’ and then ‘Publish to the web’ It is very straightforward to do this, but if you need an image, click here.



You then need to make sure that you publish the spreadsheet as a CSV format. This is quicker and easier for importing. You can see an example of this below, or if you need the original image, you can find it here:


ii Google Publish to the web


The other item to note is that you should just select one sheet, and not ‘All Sheets’. In doing so, you’re making the data easier to import. Here, the sheet is called ‘Full List’.


Once you’ve selected the sheet, you should copy the link that appears in the box. You’ll need this in order to import the data. I didn’t import this file as ‘web content’ – instead, I did ‘Import File’ and then copied the link into the ‘Open’ Dialog box. This imported the file as text. You then get the following options:


a Open as CSV


Upon importing the data as a table, you might find that you get the following error message:

The CSV input has rows with varying numbers of columns, and the first row does not have enough columns to specify the input width for all rows. Specify a value for the ColumnCount option to prescribe the number of columns to include in the output. Here is an example of the image here:

b Open as CSV error

If this is the case, then it is perhaps easier to import the data as text in order to examine more clearly to see if there are issues. To do this, just open the ‘Text’ box at the top left hand side, or right-click and select ‘Open as Text’. Here is an example:




c open as Text

Once you’ve converted it to text, the Data Explorer screen will appear as follows. You can click on the image or click here for a larger image:





d result when opened to text

Now, it is a bit clearer to see the status of the data since we can see the text. The next step is to try and re-import it as a table.  You can do this by clicking ‘Table’ at the top left hand side. You’ll now get the following screen:



e Comma delimiter settings and skip first line

And another thing…

If you’re sharp eyed, you’ll have noticed an anomaly on line 10. Why does Herbert Douglas have the title ‘Charity’? Shouldn’t this be in ‘For Services to’ column? If you look back at the first picture of this blog, you’ll see that the same thing happens in the Google spreadsheet; since it matches the source, then this isn’t an issue with the data import, but the raw data. You can see a snapshot of the raw data below and if you need a larger image, click here.

i Google publish to the web





Don’t be fooled by the nice clean appearance of the Data Explorer – there are lots of customisation and nice things that can be done with the Data Explorer, so let’s look forward to more fun in future blogs!


Don’t you just love data? I do! I hope that this helps.