Self Service BI within Manufacturing #SQLSaturdayEdinburgh #SQLPASS Presentation (#SQLSat)

SQL Saturday

Edinburgh First Conference CentreDuring mid April I was approached by Microsoft (UK) and asked if I would do a presentation at the Microsoft “Accelerate Your Insights” one day conference on the 1st of May 2014. Though hesitant and somewhat nervous about the prospect, as I had never spoken in public… I agreed and prepared a presentation.

The presentation was related to the recent Case Study I had the pleasure of being involved in through my employer, Jabil (@JabilCircuitInc). It would focus on how, at Jabil, we have progressed though the various backend SQL Server infrastructures offered by Microsoft over recent years and how we are using new technologies and features to enable BI delivery to our employees via production systems.

As a direct result of the presentation at Microsoft’s UK headquarters (Reading, UK) I was also invited to speak at a SQL Saturday (SQL PASS community event) being held in Edinburgh on 14th June 2014 at Edinburgh University Conference Centre.

Though hitting a bit of a technical snag with my work laptop, with less than 2 minutes to my presentation: -

Image

I quickly switched to my personal Surface Pro, which by pure chance I had decided to grab as I was leaving in the morning… had only took it so I had something light to play with between session. Just as well I did – quick switch, download of presentation from cloud storage and was good to go minus my demos.

Overall was able to buffer out the presentation, taking about several other aspects and areas we are working with SQL 2014 and BI… had several questions so am taking from that that audience engagement was good. Hopefully all that attended my presentation took away something that they did not know or at least found it useful.

Presentation can be downloaded both the SQL Saturday website and from here: -

Image

Thanks to Jen Stirrup (@JenStirrup) for the invitation to speak and arranging the great free training event; hope to be invited back in the future.

#SQLPASS #SQLSat #SQLSatEdinburgh #SQLSat281

Full case study @ http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=710000004223

Microsoft Case Study

Global Firm Takes an Evolutionary Leap in Data Management with Self-Service BI (Case Study)

A case study I was involved in just got published on Microsoft.com.

Over the past few years a lot of the work I have been involved in has been subject to NDAs, including this work with Microsoft (via my employer). Hence been unable to blog about my work or any of the great features of SQL Server 2014 or the Power BI suite of products.

Over the past year as part of the case study we were given advance access to SQL Server 2014 builds, Power BI and enhanced features of SharePoint. We also had assistance and regular contact with the SQL development team and Power BI guys.

As direct result of my participation I was lucky enough to enjoy a few trips to the USA, including to Seattle, Charlotte (for SQL PASS 2013 conference) and Tampa; making 2013 a very enjoyable and educational year for me :-) 

Business intelligence (BI) information is only valuable when the right users can discover, analyze, use and share it with others—and all in a timely manner. Current technologies produce data at overwhelming rates, often faster than business users can analyze it, and the bottleneck is frequently the time that it takes to generate useful and impactful reports. At US-based supply chain management giant Jabil, as in many enterprises, data analysis has long been a time-consuming and intensive collaboration between the business groups and IT, creating customized reports whose information, by the time it’s used, is already growing stale. With its new solution built on Microsoft SQL Server 2014 and SQL Server 2014 Power View, Jabil users can create their own reports in minutes from business critical data sources using Microsoft Excel, with IT providing training and guidance—freeing up time to work on strategic projects.

Full case study @ http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=710000004223

Download PDF of Case Study

Week of releases from Microsoft

 

Free Windows 8 Programming book, plus others – Kindle versions…

Programming Windows® 8 Apps with HTML, CSS, and JavaScript [Kindle Edition]

UK Link:
http://www.amazon.co.uk/gp/product/B009WS8FCG/ref=as_li_ss_tl?ie=UTF8&camp=1634&creative=19450&creativeASIN=B009WS8FCG&linkCode=as2&tag=paubunblo-21

US Link:
http://www.amazon.com/gp/product/B009WS8FCG/ref=as_li_ss_tl?ie=UTF8&camp=1634&creative=19450&creativeASIN=B009WS8FCG&linkCode=as2&tag=paubunblo-21

Canadian Link:
http://www.amazon.ca/gp/product/B009WS8FCG/ref=as_li_ss_tl?ie=UTF8&camp=1634&creative=19450&creativeASIN=B009WS8FCG&linkCode=as2&tag=paubunblo-21

Programming Windows 8 Apps with HTML, CSS, and JavaScript [Kindle Edition]


You can get around 10 additional Microsoft Press books (inc Windows Server 2012, Microsoft SQL 2012, Intro to Windows 8, etc) free for Kindle from:
http://www.amazon.co.uk/s/?_encoding=UTF8&camp=1634&creative=19450&keywords=microsoft%20press&linkCode=ur2&qid=1366291391&rh=n%3A341677031%2Ck%3Amicrosoft%20press&sort=price&tag=paubunblo-21

Or for US:
http://www.amazon.com/s/ref=sr_st?keywords=microsoft+press&qid=1366291726&rh=n%3A133140011%2Ck%3Amicrosoft+press&sort=price&tag=paubunblo-21

Visual Studio 2012 Update 2 Released

Tip

To download for team sharing/network deployment, download web installer from the link, then at command prompt use the command: -

“<download path>\VS2012.2.exe” /Layout “<my save path>”

replacing <download path> and <my save path> as required…. This will download the full install (1.8GB).

The same also works for SSDT (SQL Server Data Tools) installers.

Download now from http://www.microsoft.com/visualstudio/eng/downloads#d-visual-studio-2012-update or http://go.microsoft.com/fwlink/?LinkId=273878

Very nice code mapping features during debug and error tracing, watch the video below (or at here – about 25 minutes into video) for details.


Most of the following content has been extracted from http://www.microsoft.com/visualstudio/eng/visual-studio-update#story-update-2

46 minutes, 36 seconds

New Features include

Agile planning

Visual Studio 2012 introduced a new set of capabilities to support agile teams—on their terms. Update 2 adds new capabilities for your team to customize and get more out of its agile tooling. You can now add customizable columns to your Kanban boards so that they more accurately reflect your organization’s structure. Work item tagging helps teams to manage their work items by adding tags to get more out of their data.

Quality enablement

Maintaining quality throughout the development cycle is one of the key focus areas for Visual Studio 2012. In Update 2, you can continue to drive quality wherever you are through web access for Test Case Management. You can author and execute test cases remotely, making it easier for all members of your team to participate in test case reviews. You can also profile your unit tests to create better code by tracking the end to end flow of your code, including the unit test itself.

Line-of-business (LOB) application development

With Update 2 we continue to invest in making it easier for you to develop LOB applications. You can quickly create SharePoint apps and HTML5 client apps using LightSwitch. Just design your app and let the LightSwitch templates provide the fit and finish so you can get your LOB applications running quickly. With the addition of WPF, Silverlight and SketchFlow to Blend for Visual Studio, now you have everything you need for designing and coding your desktop applications in Visual Studio.

Developer experience

When you spend a lot of time developing software, you want tools that will provide an enjoyable developer experience. Update 2 includes enhancements and updates to improve the developer experience for Visual Studio 2012. Code map debugger integration gives you a visual representation of your code while debugging so you can identify issues faster. You can also create great apps for Windows Store using profiling enhancements to find issues earlier that could impact your users.

Plus more… Full description of Visual Studio 2012 Update 2 can be viewed at http://support.microsoft.com/kb/2797912

Additional downloads for Visual Studio 2012 Update 2 (Visual Studio 2012.2) are also available for:

Windows 8 Rocks!

Windows 8 Pro

I have been using Windows 8 full time now for just over a month, a fairly short period (I did have a VM running for a couple of months to check it out as well, though to be honest did not have much time to play with it).

I did not think I would be a fan, I tended to heavily customize and favour my start menu structure, but I can honestly say I don’t miss the start menu; hitting the start button and just typing one or two letters of what I want is so smooth and fast that I am kinda glad to be rid of my OCD organization of my start menu into organized sub folders and groupings.

The start screen is also growing on me, quite like the live tiles, even though I spend almost all my time in desktop mode and I have no touch screen, I still use it. It is easy to use and a nice change from small static icons.

Most significantly, as a rather heavy user of VMs and high memory development software, plus 30-50 windows open at any one time across 3 to 5 screens; is that the whole OS is lot faster and slicker, even with two or three VMs running in the background, all on a laptop, not a high spec desktop.

Hyper-V was the main reason I took the plunge, it’s integration is very nice; but having used the OS for everyday work, developing and maintaining everything from WPF, .NET and COM+ to old VB6 code, I actually regret not having migrated earlier…

Hyper-V On Windows 8 - Why?

Hyper-V On Windows 8 – Why?

Admittedly there are several hoops to jump through to get VB6 to install correctly, and our antivirus solution (McAfee 8.7i) took a bit of work to install (see http://developtheweb.wordpress.com/2013/02/13/trying-to-install-mcafee-8-7i-onto-a-windows-8-box/), but got them both working and do not have any apps I currently use that I have not been able to install (for Windows 7 SDK on Windows 8 box see http://developtheweb.wordpress.com/2013/03/04/windows-sdk-for-windows-7-and-net-framework-4-on-a-windows-8-pro-dev-box/ – same issue affects latest SP of Windows 7 as well).

All in all I’d happily recommend Windows 8 to anyone, whether for business, development or personal use.

Update: Forgot to mention another neat one… I use a lot of ISO disk images, Windows 8 supports them out of the box, no need for 3rd party tools and drivers, just right click and Mount; and you can mount many at once!

P.S. for VB 6 run setup in compatibility mode, deselect the Data Access components and Source Safe bits, install will say it fails at end but it hasn’t, it can be found in your program files directory. Then install VB6 SP6, which should pass. If you run into trouble with SP6 and it will not install, then make sure VB6 GUI is in the program files directory, (x86) on 64bit, and apply the following to your registry via a reg file: -

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MS Setup (ACME)]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MS Setup (ACME)\Table Files]
“Visual Basic 6.0 Enterprise Edition@v6.0.0.0.0626 (1033)”=”C:\\Program Files (x86)\\Microsoft Visual Studio\\VB98\\Setup\\1033\\setup.stf”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\Visual Basic 6.0 Enterprise Edition]
“DisplayName”=”Microsoft Visual Basic 6.0 Enterprise Edition”
“UninstallString”=”\”C:\\Program Files (x86)\\Microsoft Visual Studio\\VB98\\Setup\\1033\\Setup.exe\””

(change directories/reg key as appropriate, this one is for 64bit)


A nice vid on Windows 8, what’s changed and where to find your stuff…

(25 min)

Alternatively, from the same guy, for the tech savvy or those folks short of time – same content in just 4 minutes.

.NET Development :: Accessing Special Folders Location Across Different Windows Versions & Tightened Security Within Windows Environment

I am writing this post as I know quite a few developers only now migrating apps from Windows XP environments, most of whom are spending a lot of time fighting with the new tighter security world that started to come in with Windows Vista.

As most know; the directory structure for user files and temporary documents has changed over the life of Windows (“C:\Documents and Settings\…” is now “C:\Users\…”, Program Files location changes for 64 bit, etc).

In addition to this many of the folders and registry keys, that as a developer, you used to be able to write files and values to are no-longer accessible. In addition to this areas of the event log are also locked down, and writing to it can crash your application if not handled correctly.

So now on Windows Vista, Windows 7 and Windows 8, as a developer you cannot and should not be writing to Program Files, the root of any of your drives, Windows folder, etc, etc. This can also include the traditional temp folder (C:\Windows\Temp or C:\Temp).

The only places you can write to with any certainty are the user specific Temp folder, the ProgramData folder, or the users document store.

If you are having to deal with a legacy app you might have to manually (or programatically) override the security settings granting permissions to write files to the locations you need, though you should do so with caution, as Windows updates and security patches can reverse your changes.

All of these locations vary depending on the system setup and operating system, so what is the best way to handle it?

Well in any .NET App you can easily access any of these folders locations using the Environment namespace (System.Environment) and the SpecialFolder enumeration.

For example: -

Console.WriteLine(“Folder Path: {0}”,
System.Environment.GetFolderPath(System.Environment.SpecialFolder.ApplicationData));

A full list of the special folders can be found at http://msdn.microsoft.com/en-gb/library/system.environment.specialfolder.aspx

This is not a list of those accessible for writing to, it is a complete list.

In addition to these you can also access the traditional list of environment variables using: -

System.Environment.GetEnvironmentVariable(string);

Though for this you need to know what is available as it will cause an exception if you call for a variable that does not exist.

You can get a full list of what is on your current system with: -

var s = System.Environment.GetEnvironmentVariables();
foreach (System.Collections.DictionaryEntry item in s)
{
Console.WriteLine(“{0} = {1}”, item.Key, item.Value);
}

But you need to avoid app specific ones, and watch out for some that may have changed names over the years.

You can access the documentation (.NET 4.5) for the System.Environment class at http://msdn.microsoft.com/en-us/library/z8te35sa.aspx or via your Visual Studio help.


With regards to the Event Log, you need to make sure you create your event source during your app install (or have an admin add it into the appropriate event log). This may not be caught during development as most developers run as admin and may even turn off all the UAC protection.

If you don’t then the kind of error you might see in Visual Studio would look something like: -

Security Exception when trying to write to Event Log

Security Exception when trying to write to Event Log.
“The source was not found, but some or all event logs could not be searched. To create the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security.”

But all your users will see is something like: -

App crash when trying to write to Event Log

App crash when trying to write to Event Log

If you need to use the event log (which is good practice), then make sure you have created your source during your install and not during your exception handling.


As for the registry, unless your app is running in elevated mode, the only hive you now have access to is HKEY_CURRENT_USER, some of which itself may have been locked down, by specific apps to prevent changes. So if you need to read from HKEY_LOCAL_MACHINE then you should not be using CreateSubKey; but creating your keys/valuse during or app elevation and using OpenSubKey for reading… remember you exception capturing though, similar to Environment Variables, you’ll get an exception if you don’t have access or the key does not exist.

Windows SDK for Windows 7 and .NET Framework 4 on a Windows 8 Pro Dev Box

Ran into an issue today trying to install “Windows SDK for Windows 7 and .NET Framework 4”  (http://www.microsoft.com/en-gb/download/details.aspx?id=8279) on my Windows 8 Pro Dev Box.

The error given is: -

A problem occurred while installing selected Windows SDK components.

Installation of the “Microsoft Windows SDK for Windows 7” product has reported the following error: Please refer to Samples\Setup\HTML\ConfigDetails.htm document for further information.

Please attempt to resolve the problem and then start Windows SDK setup again. If you continue to have problems with this issue, please visit the SDKteam support page at http://go.microsoft.com/fwlink/?LinkId=130245.

Click the View Log button to review the installation log.
To exit, click Finish.

and looks like: -

Windows SDK for Windows 7 and .NET Framework 4 error message on Windows 8 Pro system

Windows SDK for Windows 7 and .NET Framework 4 error message on Windows 8 Pro system

Microsoft Visual C++ 2010 Redistributable

Before it tries to install it warns you that the “Microsoft Visual C++ 2010 Redistributable – 10.0.40219” is installed, is newer than the one included and so will not be updated… however this is the cause of the failed install…

Before installing you need to remove all C++ 2010 components.

Note that this issue is not unique to Windows 8, also affects Windows 7 and probably Windows XP too, though not tried it there.

You can also install OK, if during the component selection process you de-select “Microsoft Visual C++ 2010” under  “Redistributable Packages” and “Visual C++ Compilers” under “Windows Native Code Development“: -

Windows SDK for Windows 7 and .NET Framework 4 Component Selection

Windows SDK for Windows 7 and .NET Framework 4 – de-select C++ bits…

Meet the new ASP.NET and Web Tools 2012.2 release…

ASP.NET tooling gets a little better, with updates to Page Inspector, IntelliSense, Publishing and the Editor; Along with a batch of updated project Templates. See: -

http://channel9.msdn.com/posts/Introduction-to-the-ASPNET-and-Web-Tools-20122-Release

for a short-ish (~25min) video on the details.

You can get the ASP.NET and Web Tools 2012.2 installer at: -

http://asp.net/vnext

Image

Some free Microsoft Press eBooks…

Currently available books include – Introducing SQL Server 2012, Introducing Windows Server 2012, Programming Windows 8 Apps, Introducing Windows 8 for IT Professionals, Understanding Virtualization Solutions and more… Available in PDF, Mobi (Kindle) and epub, you can check them out at: -

http://blogs.msdn.com/b/microsoft_press/archive/2012/05/04/free-ebooks-great-content-from-microsoft-press-that-won-t-cost-you-a-penny.aspx

Introducing SQL Server 2012   Programming Windows 8 Apps   Introducing Windows Server 2012