Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts
by

How To: SQL to Calculate Average of non-Zeroes from a List of Values

I don’t do much coding these days but here’s one I’ve done recently and thought about keeping it for future reference Smile

For a list of values, how to calculate the average only using the ones which are non-zeros?


CREATE FUNCTION dbo.fn_AverageNonZeroes 
(@para int, @parb int, @parc int, @pard int, @pare int)
RETURNS DECIMAL(4,2)
AS
BEGIN
    DECLARE @average DECIMAL(4,2)

    DECLARE @a DECIMAL(4,2)
    DECLARE @b DECIMAL(4,2)
    DECLARE @c DECIMAL(4,2)
    DECLARE @d DECIMAL(4,2)
    DECLARE @e DECIMAL(4,2)

    SET @a=CONVERT(DECIMAL(4,2),@para)
    SET @b=CONVERT(DECIMAL(4,2),@parb)
    SET @c=CONVERT(DECIMAL(4,2),@parc)
    SET @d=CONVERT(DECIMAL(4,2),@pard)
    SET @e=CONVERT(DECIMAL(4,2),@pare)

    IF @a>0 OR @b>0 or @c>0 or @d>0 or @e>0
     SELECT @average=(@a + @b + @c +@d + @e)
             /
             (0+
             CASE WHEN @a=0 THEN 0 ELSE 1 END +
             CASE WHEN @b=0 THEN 0 ELSE 1 END +
             CASE WHEN @c=0 THEN 0 ELSE 1 END +
             CASE WHEN @d=0 THEN 0 ELSE 1 END +
             CASE WHEN @e=0 THEN 0 ELSE 1 END
             )
     ELSE
         SELECT @average=0.0
    
     RETURN @average
END 

by

Free Stock Photos Woman in IT, #STEM

Do you love to support the efforts to attract more women to #STEM ? Do you support a more diverse workplace, outside of your typical blue eyed, white man, in glasses and fancy suits?

Do yourself a favour and start using this great catalogue of stock photos representing women in technology, from diverse backgrounds and biotypes. I know some of these photos are full of Microsoft logos but a lot of them aren’t, so go ahead they are royalty FREE by WOCinTechChat! Bring new life to your presentations, support a more diverse culture in technology Smile

For the full album of free stock photos of women in IT, STEM click here…

image

image

image

image

image

by

Managing Thousands of Projects in Project Online

If you work with Microsoft Project Online you know how great this product is at streamlining project, resource and portfolio management activities. All this is for a single purpose, to allow you to deliver better projects, on time, on budget.

And now a few changes were released this month. Let have a look at 2 very special ones that I would like you to know:

Create and Manage Up to 30,000 Projects

Traditionally, Project Online  allowed for up 5,000 projects. Starting April/2017 this limit will have a significant jump. 6x to be more precise. Now project managers will be able to create and manage up to 30,000 projects in the cloud using Project Online. What was already a fantastic number, now has just increased to great lengths.

Why This is Good?

It offers a better scale, 30,000 projects allows for a much bigger room to move and improve and at the same time offer more flexibility to get more things done.

 

Pick and Choose the Site URL for your Project Site Configuration

Another great improvement on the way things are done in Project Online is on how information is organized in SharePoint sites. Now project managers can create more project sites and every project now can have a 1-1 relationship with their project site.

Why This is Good?

Again, traditionally this number was limited to 2,000. Often times more sites were needed but this limit was reached, then what people used to do was to split your landscape into several PWA sites, which then extended to another batch of 2,000 sites but the trade-off was that it impacted in the team productivity with a fragmented environment.

…One More Great News Before You Go…

In addition to these great improvements, there is one more fantastic improvement done in Project Online this month: Now users can set the destination URL of the project sites in the Enterprise Project Type template. This not only helps with the meta-hierarchical structure of the organization but also streamlines the process of project creation allocating sites based on similarities and functional equivalences.

How It Works?

For example, if you company has a site collection dedicated to a specific department and all sites are located on it (Sales, Marketing, IT etc), let’s call it https://superedge.sharepoint.com/sites/demo for demonstration purposes, now you can configure your all your departmental projects EPT to provision sites directly into this site collection

image

You do this by going into each EPT, then in the Project Site section, select Allow users to choose:

image

 

What if You Can’t See these Things in Your Environment…

This is a Question that many times people ask me when they see these cool announcements and all the new features and yet they don’t seem to get them. Don’t worry, that’s the nature of Office 365 Releases. Releases are done by zones and via multiple channels. Very often these changes are done slowly and according to geographic zones, so if you don’t see them yet, don’t worry. They are coming!

by

Microsoft EMS Usergroup Presentation: EMS - Everybody Together Now!

I love talking to the local cloud community. These guys are a good bunch of folks that put their own time and resources to bring innovative and up-to-date content for everyone to see for free! Big shout of to Aaron, from Microsoft for the support.

This week I presented to the Microsoft Cloud User Group in Brisbane, Australia. We talked about EMS in a demo-heavy session!

image

For this session we set vert ambitious targets in terms of demos. My opinion is that EMS is a fantastic but only through hands-on experience is how people realise the value proposition of this product. We ended up doing 40 minutes of demos with Q&A as needed. Great engagement!

BYOD Device Management and ATA Advanced Threat Analytics 

image

image

 

Where Can I Get the Presentation Slides ?

If you’re interested in the slides, they are here: EMS Everybody Together now! – Microsoft Brisbane Cloud Usergroup

As always, feel free to reach out if you would like to know more.

by

Surface Pro 3 Battery Problems

Do you have a Surface Pro 3?

image

Are you experiencing very low, fast battery duration like the case mentioned below? (from winsupersite)

image

If yes, looks like you’re in for a bit of a pain. Microsoft has acknowledged some Surface Pro 3 models have a battery issue where the battery charge is continuously draining and soon it will be unusable. Think in terms of, 1 or 2 hours max of duration. A far cry from ideal. There is a thread now also in Reddit on the topic and on the apparent silence from Microsoft on this.

How Do I Know My Surface Pro has this Issue?

The issue is related to the manufacturer, called SIMPLO. All models that have a battery from this manufacturer have or will have this problem.

How Do I Know the Battery Manufacturer of my Surface Pro ?

There is a neat command-line utility in windows that gives you that information. In your command-prompt type the command powerfcg /batteryreport

image

This will generate an HTML report about your battery, including the manufacturer as you can see here:

image

If the manufacturer reads “SIMPLO”, your device has a problematic battery. In this case, the manufacturer is “LGC-LGC” which indicates this device has an OK battery.

What Should I do if My Surface Pro 3 has a Bad Battery ?

If you’re Surface has less than 1 year, you’re covered by warranty. After that, you should raise your voice and complain to  Microsoft here. There is already a growing list of people doing that and pressing Microsoft for a reasonable solution, after all it is a poor component.

by

IoT, Office 365 and the Prime Position of STEM Kids in Australia


5 million new IoT (Internet of Things) devices will come online every day in 2016. How can companies join the party for a piece of this 50 billion dollars’ cake?

Come to Microsoft Innovation Centre in Brisbane (level 28, 400 George st, Brisbane) and join me to discuss:

  • The state of connected devices in Australia,
  • How can we use IoT and Office 365, and
  • Why Australians are in a prime position to lead the world in this area and the role of the STEM programs for kids is an important strategic move in the innovation agenda.

image

image

image

 

Where Can I Download the Presentation Slides?

You can download the slides for this presentation here.

by

I Am Presenting at the Azure Smorgasbord in December 2015

How does your day look like on December 9th 2015?

Come join me a Microsoft to discuss and share ideas about IoT, Azure and Office 365 in Australia.

iot edge

 

Session Name: “IoT - The Invasion of Australia”

Abstract: “Five million new IoT devices will come online every day in 2016. Do you want a piece of this 50 billion dollar cake? Join Edge Pereira to discuss a use case of IoT in Australia and why we are in a prime position to lead the world in this area.”

Click here to register

 

Where Can I Find the Presentation Slides?

You can find the slides for this presentation here.

by

Hour of Code 2015. I am Volunteer. Again.

Once again this year I am volunteering time for the Hour of Code. And proud of it. Listen what Bill Gates, Mark Zuckerberg, Jack Dorsey and others have to say about this event.

 

 

What is the Hour of Code?

Launched in 2013, Code.org is a non-profit dedicated to expanding access to computer science, and increasing participation by women and underrepresented students. The vision is that every student in every school should have the opportunity to learn computer science. Code.org believes that computer science should be part of core curriculum, alongside other courses such as biology, chemistry or algebra.

 

Untitled

When It Happens?

Volunteers from all over the world help local teachers and their classes during the Computer Science Education Week that happens every year in December. This year it will be from December 7th to 13th.

 

How Can You Help?

We have this year 13.000 requests from teachers from all over the world, but only 4.000 volunteers. We need volunteers to help with the activities and help the teachers. Here are a few things you can do also to get involved:

  1. Recruit co-workers to volunteer:  Blog, share, tell your friends and co-workers about the Hour of Code and ask them to sign up as a volunteer.
  2. If you know someone who’s a volunteer, connect them with people who wants to setup Hour of Code parties.

 

I Want to be a Volunteer. What Do I Need to Do?

To get a better idea about what your volunteer experience will be like, have a look at this guide. There's also some extra tips about how you can get your employer and community involved with the Hour of Code.

 

If you know anyone needing help with it, feel free to connect with me. Remember: I am a volunteer! Smile

by

Infrastructure Saturday 2015 Social Media Stats #infrasat

We’ve just done another successful Infrastructure Saturday event. It takes a lot of time and passion to setup personal time aside and to organize such an event. This is an annual event totally built and sponsored by the community, so the people you find there (attending, organizing or presenting) are 100% committed to the cause. Big shout for the guys organizing: Alan Burchill and Shane Hoey

Below are some of the social media stats collected during the last week up to the event day. This years top contributors were: JustBroady, superedge, david_obrien, pzerger, cloudtidings, bneusergroup, alanburchill, twalex2, blkchninstitute, reecestewart4

If you’ve been to the sessions, thank you very much. I hoped you enjoyed and see you next year.

imageimage

image

image

 

image

image

image

image

image

image

image

 

Top Links about the #infrasat Infrastructure Saturday 2015 Event

  1. https://www.flickr.com/photos/alborath/albums/72157660731316669
  2. https://twitter.com/DigitalGlobe/status/667834517428682752
  3. https://code.visualstudio.com
  4. http://www.infrastructuresaturday.com/
  5. http://www.superedge.net/2015/11/ethereum-blockchain-service-bitcoin.html
  6. https://lnkd.in/b_GeEXZ
  7. https://lnkd.in/bk9tVcN
  8. https://doc.co/75WgEz
  9. http://www.linkedin.com/pulse/want-increase-privacy-protection-your-cloud-data-worries-edge-pereira
  10. http://www.infrastructuresaturday.com
  11. http://infrastructuresaturday.org
  12. https://lnkd.in/buajN7R
  13. https://lnkd.in/bkYJbY4
  14. https://lnkd.in/bBgh534
  15. http://www.superedge.net/2015/11/infrastructure-saturday-2015-australia.html
  16. https://lnkd.in/bhp3pyZ
by

Azure DevTest Labs Now in Preview

Busy week for Microsoft Azure. Another feature comes in preview today: Azure DevTest Labs

image

What it is ?

Azure DevTest Labs gives developers on-demand self-service for Azure-based test environments. With DevTest Labs developers can:

  • Quickly provision development and test environments.
  • Minimize waste with quotas and policy enforcement.
  • Set automated shutdowns to minimize costs.
  • Create a VM in a few clicks with reusable templates.
  • Get going quickly using VMs from pre-created pools.
  • Build within Windows and Linux environments.
  • Integrate directly with your preferred CI tool, IDE, or automated release pipeline.

A really cool feature is that the Dev VMs can be saved as templates and reused across organizational teams  of developers.

image

How Much it Costs?

Azure DevTest Labs is a free service. However, you will be charged for other Azure resources that are created in the Lab. For example, you will be charged for the virtual machines that are created in the DevTest Labs per our virtual machine.

See this new product here at the Azure DevTest Labs webpage

by

Azure Disk Encryption Now Available

Brand new feature deployed today on Microsoft Azure as preview: Disk Encryption

About Azure Disk Encryption

Azure Disk Encryption for virtual machines (VMs) is the answer to many organizations that could not have VMs running in the cloud mainly due to security and legislation compliance requirements.

image

 

What it Does?

What this technology does it to encrypt the VM disks, including boot and data disks, with keys and policies which are controlled in the Azure Key Vault.

image

 

It Works for non-Windows Systems

Disk Encryption for VMs works for both Linux and Windows operating systems. It also uses Key Vault to safeguard, manage, and audit the use of disk encryption keys. All the data in your VM disks is encrypted at rest using industry-standard encryption technology in your Azure Storage accounts.

image

 

What Encryption is Used?

Windows VMs uses BitLocker and the Linux VMs are using dm-crypt

 

How Much it Costs?

This is at no charge. Gratis! The reason for that is because this is brand new and still in preview mode. Microsoft is expected to start charging for it in some way when the product becomes live. Meanwhile it is a great opportunity for you to start playing around with it and testing your systems.

by

I’m Speaking at the Infrastructure Saturday 2015 Australia

Once again I am honoured to be part of the Infrastructure Saturday event in Australia. This is such a great opportunity to connect with the local IT community and talk about tech and experiences with a local flavour and feel.

Session Details

  • Title: “When a data breach happens, what’s your plan ?”
  • Abstract: Ashley Madison, Sony, Kapersky Labs, LastPass, CentreLink, G20 event in Brisbane…What do they all have in common? They were victims of data breaches. And as you probably know by now, some were handled better than others. In this session we will talk about strategies, from mitigation to handling, used when a data breach happens (not “if”) and what controls do we have if you are using Office 365.”
  • Local: Microsoft Offices, George St, 4000, Brisbane, Australia

 

Where Are the Slides?

You can find the slides here

 

Looking forward to talk about this topic!! Below are some of the art done to promote my session. Loved the work Smile

image

edge-pereira-infrastructure-saturday-2015-1

image

edge-pereira-infrastructure-saturday-2015-2

by

List of the Most Common Passwords

Ah the joys of working on a specialized cloud security company. This list got to my hands and I am quickly circulating them with you. These guys do a lot of pen testing, network and cloud vulnerability assessment, cloud assurance etc.

Is any of these your current password somewhere? I hope not! Smile

image

Full list you can get it here

by

Microsoft to Store Data in Germany. Make it Harder for Foreign Authorities. Safe Harbour Lesson #1.

Here’s a way to increase your data protection from US government access: Store it in Germany!

As you probably know, in October 2015 the European Court of Justice declared invalid a "Safe Harbor" agreement between the European Union and the U.S. that allowed Facebook and other firms to transfer data in huge quantities to their servers in the U.S.

The court threw this deal in the bin because it was worried about "mass indiscriminate surveillance and interception" of personal data by the U.S. authorities.

And that’s what’s Microsoft is proposing: to make it harder for Government authorities to put their hands in people’s data.

image

 

Why Germany?

After the whole saga between Microsoft vs. USA Justice Department, European consumers, rights groups and lawmakers have expressed concern about what U.S.-based companies share with American authorities.

image

The European Union has very rigorous rules to protect data, and Germany's regulations are considered especially strict. Besides that EU authorities have been clamping down on data protection in recent months over concerns about mass spying by U.S. intelligence services. Especially after the revelations made by former NSA contractor Edward Snowden that the U.S. spied on German officials, including Chancellor Angela Merkel, angered Berlin.

 

Where Will the Datacenters be Located in Germany?

They will be in Magdeburg and Frankfurt. These new datacenters will maintain the same level of expectations , security, service and quality standards as all Microsoft datacenters globally. The services offered will abide by the Microsoft trusted cloud principles of security, privacy, control, compliance and transparency, as well as consistency with Microsoft’s global cloud services.

image

The reason for 2 datacenters is to ensure business continuity. Also their data will be exchanged through a private network to ensure data resides in Germany even in transit.

 

What is Planned to be Stored in Germany?

As part of this big initiative, Office 365 customers will soon be able to choose to store all data from the following products in Germany:

  • Azure,
  • Office 365 and
  • Dynamics CRM Online

 

Who Will Oversee this Data?

Deutsche Telekom will be the assigned data trustee and will control and oversee access to all customer data.

 

What is a Data Trustee?

Data trustee is an entity that will handle data on your behalf. In this case, it will be a company called T-Systems, which is a subsidiary of Deutsche Telekom. It means that Microsoft will not be able to access this data without the permission of either:

  • customers or
  • the data trustee itself

and if permission is granted by the data trustee, will only do so under its supervision.

This is ground-breaking stuff. Never done it before in Europe and after the repercussion of the Safe Harbour case, this service is expected to grow rapidly.

 

What are the Impacts on Compliance for Customers?

These new cloud services in Germany will specifically address organizations and enterprises operating in data-sensitive areas such as the public, financial or health sector. The immediate effect on this is positive: Now you can even choose the datacenter within the EU jurisdiction which will translate in a better granularity of controls.

We are talking about the German Government which traditionally have a very high level of data handling regulations and security by default. As a matter of fact, Germany is one of the leaders in this quadrant. Together with Customer Lockbox, customers will be able to view how and where data is processed.

 

Will this Avoid the US Authorities to Access my Data?

Honestly, No. Any government that requires access to data stored in the cloud, regardless of the provider (Microsoft, AWS, Google etc) will get this access. In a fight between governments and private companies, governments always win.

However this move will make it increasingly harder for governments to have this access. And that’s the main goal here. It is not to block the access, but to put stronger controls around data access by other people except the data owner.

This move will be likely followed by Amazon and Google very soon.

 

Sounds Great! When Can I Move my Data to Germany?

There is a LOT of ground work to cover. Involving auditing, certifications, and buildings construction. Microsoft is releasing this information now to calm-down the nerves of some big customers. The expected timeline for availability will be around the 2nd semester of 2016

Read the official announcement here from Microsoft Europe.

by

Ethereum Blockchain as a Service Now Available on Microsoft Azure

Microsoft and ConsenSys are partnering to offer Ethereum Blockchain as a Service (EBaaS) on Microsoft Azure so Enterprise clients and developers can have a single click cloud based blockchain developer environment. The initial offering contains two tools that allow for rapid development of SmartContract based applications:

  • Ether.Camp - An integrated developer environment, and
  • BlockApps - a private, semi-private Ethereum blockchain environment, can deploy into the public Ethereum environment.

image

 

What is Ethereum?

If you’re not following closely the whole movement started with BitCoin, have a look at this video.

 

Why Ethereum?

The Enterprise Partner Group at Microsoft is on the front lines with some of our largest customers.  Everyone, particularly Financial Services, is interested in Blockchain technology. While a platform like Bitcoin has many great uses specifically as a Cryptocurrency, Ethereum provides the flexibility and extensibility many of our customers were looking for. 

In Financial Services particularly, Blockchain is a major disruptor to some of their core businesses, and FinTech companies are driving innovation in this space.  Ethereum is open, flexible can be customized to meet our customer’s needs allowing them to innovate and provide new services and distributed applications or Đapps.

Ethereum enables SmartContracts and Distributed Applications (ĐApps) to be built, potentially cutting out the middleman in many industry scenarios streamlining processes like settlement. But that is just scratching the surface of what can be done when you mix the cryptographic security and reliability of the Blockchain with a Turing complete programming language included in Ethereum, we can’t really image what our customers and partners will build.

‘'Ethereum Blockchain as a Service” provided by Microsoft Azure financial services customers and partners to play, learn, and fail fast at a low cost in a ready-made dev/test/production environment. “

It will allow them to create private, public and consortium based Blockchain environments using industry leading frameworks very quickly, distributing their Blockchain products with Azure’s World Wide distributed (private) platform.

That makes Azure a great Dev/Test/Production Environment for Blockchain applications. Surrounding capabilities like Cortana Analytics (machine learning), Power BI, Azure Active Directory, Office 365 and CRMOL can be integrated into apps launching a new generation of decentralized cross platform applications.

 

How to Try Ethereum?

It is available as an Azure VM Template. It means you need to spin up an Azure VM with the Ethereum template loaded. The virtual machine main system is Ubuntu, and it will contain a Go Ethereum client and a Genesys block. Also this template is available on GitHub, you can get it here.

 

Deploying with PowerShell

You will need Azure PowerShell to perform the deployment. You can install Azure PowerShell from here.

Switch-AzureMode AzureResourceManager
New-AzureResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/azure/azure-quickstart-templates/master/go-ethereum-on-ubuntu/azuredeploy.json

 

All this is a pretty straight forward process, you will need to specify:


 



Read more about this exciting announcement here.