Azure PowerScript The subscription name doesn’t exist.Parameter name: name

This post show you the common error when you are using PowerShell with Storage Account for SQL.

When you issue the command Select-AzureSubscription -SubscriptionName $subscriptionName. The you get the following error.

Select-AzureSubscription : The subscription name 366a3325-exxx-4xxx-xxx4-xxxxxxxxxx doesn’t exist.

Parameter name: name

At line:1 char:1

+ Select-AzureSubscription -SubscriptionName $subscriptionName

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : CloseError: (:) [Select-AzureSubscription], ArgumentException

+ FullyQualifiedErrorId : Microsoft.WindowsAzure.Commands.Profile.SelectAzureSubscriptionCommand

Look at the screen below. The $subscriptionName is Visual Studio Enterprise and not the Subscription ID.

Advertisements

Microsoft SQL Server Docs card sort

The @SQLDocs team is looking for help with a card sort exercise to better organize our docs! If you have about 10-15 minutes free and would like to participate, please go to: https://80s3ignv.optimalworkshop.com/optimalsort/36yyw5kq-0 … Thanks!

‘Add-AzureAccount’ is not recognized as the name of a cmdlet

This post is giving you one of the solutions to resolve “‘Add-AzureAccount’ is not recognized as the name of a cmdlet” error message.

In many Internet solution the will ask you to type the following command.

Install-Module AzureRM -AllowClobber,

This might not be wrong but just that it doesn’t work for me. It works when I am using the below cmdlet download.

https://github.com/Azure/azure-powershell/releases/tag/v6.11.0-October2018

SQL Server Auto Shrink not working then how to Shrink

Let’s put aside the performance problem. The Auto Shrink in SQL Server work after all. When you go into a database properties then you will see the Auto Shrink property like the one below.

I was searching everywhere and the closer article was this https://support.microsoft.com/en-my/help/2160663/recommendations-and-guidelines-for-setting-the-auto-shrink-database-op. It did not mention anything about recovery model as well.

I have tested despite with whatever recovery model I set the Auto Shrink just would not work. I believed many people said, shrinking database file is bad but I bet if you log file has growth up to 200GB then you would definitely want to shrink it.

You can manual shrink you database or log using the follow command. It works for me so far.

use dashboard15

ALTER DATABASE dashboard15 SET RECOVERY SIMPLE

DBCC SHRINKFILE ‘dashboard15’, 100) 

DBCC SHRINKFILE (‘dashboard15_log’, 100)

ALTER DATABASE dashboard15 SET RECOVERY full

SSIS Unable to cast COM object of type ‘System.__ComObject’ to class type ‘System.Data.SqlClient.SqlConnection’.

This post giving one of the possible solution to resolve the error above.

You have a Script Task in SSIS and utilizing the Connection Manager. The Connection Manager Provider type is Native OLE DB\SQL Server Native Client 11.0.

You have code inside the Script Task.

ConnectionManager cm;

cm = Dts.Connections[“LocalHost.uCustoms”];

SqlConnection sqlConn;

sqlConn = (SqlConnection)cm.AcquireConnection(Dts.Transaction);

You get the error

“System.InvalidCastException was unhandled by user code

HResult=-2147467262

Message=Unable to cast COM object of type ‘System.__ComObject’ to class type ‘System.Data.SqlClient.SqlConnection’. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.

Source=ST_28dc48d9f81b48c88c82e0c815d09082″

You need to change your Connection Manager to .NET Provider\SqlClient Data Provider.

Digital Transformation in a nutshell

This article is about digital transformation. After researching on the Internet there is fewer solid articles on digital transformation.

What is not digital transformation

Buying a lot of IoT devices working on a silo way, putting up the servers to dump data in and call it big data, subscribing the cloud services with machine learning capabilities, and hire a team to create a mobile apps is not digital transformation.

The effect of digital transformation

In Europe, most of the businesses believe digital transformation, especially in the following areas.

1. Innovation ability

2. Superior Customer Experience

3. Respond to market

4. Internal and External Collaboration

5. Improved Brand

6. New business models

Digital Transformation pillars

Engage customers

• Transform from Task based relationship transform to Ongoing relationships
  
• Transform from One size fits all transform to Personalized engagement
  
• Transform from Reactive transform Proactive service
  
• Transform from Single channel transform Omni channel
  

Empower employees

• Transform from Lack of qualified applicants to Landing quality hires
  
• Transform from Opaque workforce to 360 view of talent
  
• Transform from Underutilized training to Personalized learning and development
  
• Transform from Disengaged workforce to Inclusive culture and teams
  

Optimize operations

• Transform from Siloed processes to Connected operations
  
• Transform from Manual processes to Purpose – built experiences
  
• Transform from Wasted resources to Optimized production
  
• Transform from Point in time planning to Continuous Intelligent planning
  

Transform products

• Transform from Disconnected products to Continuous connections
  
• Transform from Transactional data to Real-time intelligence
  
• Transform from One size fits all to Personalized solutions
  
• Transform from Legacy business models to Anything as a service
  

Impact of Digital Transformation

The Good

• Collaboration
  
• Communication
  
• Platform/Mobility
  
• Personalisation
  
• Information (Digital rights management -> Information Rights Management (embedding into documents)).
  
• Analytics
  
• 3D Printing
  
• Internet of Things – e.g. Machine to machine (M2M) – Big Data – volume, variety, and velocity (e.g. from sensors, devices, third parties, web applications, and social media and alerts/early warning/maintenance notification).
  
• Ease of access to services;
  
• Cloud, Big data (e.g. research, BI and marketing);
  
• Video Collaboration/virtual rooms;
  
• Flexibility: Just-in-Time learning and online courses;
  
• Location identifiers – can provide just in time data or assistance;
  

The bad

• Anti-social;
  
• Information overload;
  
• Loss of good analytical skills faster than providing alternatives;
  
• Privacy and security implications (e.g. geo-location tracking, web page visits)
  

e-Waste (both devices and batteries – even wireless mouse, keyboards all have batteries). Global E-waste Monitor 2014 and compiled by the United Nations University, last year an estimated 41.8 million metric tons of e-waste was discarded throughout the world. (Source: Dr Sunil Herat, Academic Staff, Griffith School of Engineering, Griffith University)

Tools:

Microsoft SQL Server, Azure SQL Database, Cortana Suite, SharePoint, Office 365, Visual Studio

Slide: https://1drv.ms/f/s!AlUZkNIm6J4hggjVlQE7RrM3jOIC

The type name ‘ServiceReference1′ does not exist in the type ‘someclass’

The post shows you on of the ways to resolve “The type name ‘ServiceReference1’ does not exist in the type ‘someclass'” error.

Not sure for what reason Visual Studio having this problem lately. When you reference a Service Reference, for example, http://ucustomsintgstg.customs.gov.my/IL_VesselRegistration/VesselRegistration.svc. Then you keep getting the type name does not exist error. I actually found this article http://bursjootech.blogspot.com/2008/06/wcf-type-name-servicereference1-does.html. But where to change.

I changed in my asmx cs code behind file, for example, the namespace from WSTestPriority to WSTestPrioritySvc.

Then you need to change in the asmx mark up as well.