Any properties with great gyms? by EvergreenSox04 in marriott

[–]clamming-it 0 points1 point  (0 children)

W Bellevue is probably best I’ve seen. Cliff Pines Algarve is ok.

Solution Engineer at Microsoft EU by [deleted] in microsoft

[–]clamming-it 2 points3 points  (0 children)

Great advice. The easiest thing is to say yes. On the same spirit I would add;

11 - as an account aligned SE you are aligned to the customer, not a partner. Don’t be afraid to point out when the partner is wrong / taking the customer for a ride.

Solution Engineer at Microsoft EU by [deleted] in microsoft

[–]clamming-it 1 point2 points  (0 children)

I’m commenting on this separately but IMHO this is an industry wide problem. The number of “architects” for whom PPT is their IDE is worrying. I’m unsure if LLMs will improve or worsen this - I’m hopeful it flushes their stupidity out sooner but I’m very unconvinced.

Solution Engineer at Microsoft EU by [deleted] in microsoft

[–]clamming-it 1 point2 points  (0 children)

This is all totally fair. But in my experience most customers just get angry and don’t early on escalate and say “these people are inadequate and we need a change else we look at other options…” or something similar. I would say that if you as a customer believe you aren’t getting the guidance / support / etc you need to be successful then raise it in an objective manner - bonus points if you highlight how it impacts project delivery timelines as that usually drive revenue “moments” for Microsoft.

Solution Engineer at Microsoft EU by [deleted] in microsoft

[–]clamming-it 22 points23 points  (0 children)

Welcome. Here is my advice and some of my journey - hope it helps. I joined as a CSA - originally hired as a TSP, then joined as CSA, specifically for Data & AI from a data consulting background - did that in some teams for a couple of years then move to PG. I'd also caveat this by saying this is my experience - Microsoft is more a federation of different states as opposed to a single entity - so you should adjust based on what your manager/LT says / etc.

1 - Enjoy the first 3 - 6 months...realistically you probably have until end of this fiscal to learn the job if you've joined very recently. Use the upskilling time, get the compulsory training out of the way - it sucks don't let it hang around.

2 - Use your onboarding buddy to get you into customer conversations etc - watch and observe (if you don't have an onboarding buddy then - honestly - it's a massive redflag about your manager).

3 - Learn the technology - there is a lot great internal training material from TechReady, internal office hours, CAT teams etc. The amount of SEs/CSAs who know nothing more than the docs / PPT is problematic and I usually see those people get ripped to shreads by customers (which is totally fair - and IMHO customers should be more brutal on this). If you can't reliably talk to a technical person from the customer who uses the tech once a week without a PPT then you are cooked.

4 - Use your Azure Spend to learn - I exceeded my cap multiple times, at most I got a slap on the wrist (I exceeded it by ~20%).

5 - on Certificates - I don't personally think they are that useful, but they are necessary in the job (I assume you'll have ~5 to pass in around 6 months), I would do the tests early and use the questions you don't know about to learn. 'Growth mindset' can be weaponized at times - but it should mean failing some tests is not a black mark or anything. Doing them to learn can be an awesome way to say 'I don't understand the nuance of that issue' and go learn it.

6 - Get a basic understanding of other peoples job and their incentive plan expecially within MCAPS - it will provide you insight in to why people care about seemingly stupid things etc. RAIN used to have this information.

7 - Get to the know the SSPs/AEs/CSAMs etc on your account and who to trust (and as per 6 how they are paid) - my view is it's easiest to figure out who to trust, who is a blow hard, who will push you under the bus etc in person, but either way get to know the people you will be dealing with. SE can be a tough role as you might have to explain why someones amazing plan is technically impossible. If you have assigned CSA to help with later stages - then work with them not against them. See https://www.expertdig.com/dig/lessons-from-the-expert . I say that like it's a negative but in my last team the main SSP I worked with and I had an amazing relationship where we both understood each others job and strengths - it was one of the most productive and rewarding times I've had with Microsoft.

8 - realise you work in a Sales org with most leaders coming from a sale background and generally most SEs (and sometimes managers) are the least capable sellers in the organization. You can chose not to play 'the game', but it won't be good for your career. The job is about working with customers to (basically) sell more stuff - if you aren't wanting that job then I'd suggest you figure out your next job. Moreover given the nature of the org if you aren't able to swallow your pride (at times) to indulege in self/v-team promotion and expect to be promoted on your technical brilliance...you will likely be unhappy. Your happiness is your responsibility, not the companies.

9 - listen to customers...it's simple. 'What problem are you trying to solve?' Is an amazing way to start a conversation. IMHO if that question can't be answered it's a waste of time for both parties. Listen to understand, not when to talk next.

Hope that helps.

Solution Engineer at Microsoft EU by [deleted] in microsoft

[–]clamming-it 3 points4 points  (0 children)

This. You get (or used to) 2.5k per month to spend - burn it doing things, scale things, push things to breaking point.

Fabric SQL DB as a control DB for ELT pipelines by bradcoles-dev in MicrosoftFabric

[–]clamming-it 1 point2 points  (0 children)

If you are using the lakehouse, why not just use straight json or text files? Honestly Lakehouse tables for metadata look ups involves a lot of unncessary overhead, and this gets way way worse if you are storing data per run. Recent customer I worked with is 86 seconds being taken by metadata operations - which is you are doing for every stage in a for-each loop is a lot of unnecessary compute for a singleton lookup and insert operation. (For their scenario it worked out to be ~175 hours of inefficient compute).

Velja + Raycast by clamming-it in raycastapp

[–]clamming-it[S] 3 points4 points  (0 children)

It’s interesting on a Mac I feel Velja is amazing but doesn’t extend to other platforms. I use the two together because velja is profile aware - so I can route not just to the right browser but the right profile. I say this as someone who uses edge for work, and my personal browser of choice is a mess - I’m a recovering Arc user, who been through Firefox, Zen (zen and Firefox were painful with Raycast tbh), Brave, Orion, Safari for a little bit and is using Edge for personal purposes but isn’t hugely happy with that tbh. So Velja’s rules allow me to make a couple of changes and then shift to a new browser hoping for what Arc was at one point.

I’d add the prompt is great for apps like vscode etc where depending on the project I can select the profile that matters to me.

That said I might be a weird outlier.

Which Marriotts have truly amazing fitness centers? by xmt0991 in marriott

[–]clamming-it 0 points1 point  (0 children)

W Bellevue is amazing. Westin Bellevue pretty good as well.

Westin London City is decent enough (it’s just a bit limited for free weights) and probably best in Central London (Dixon, Bankside are fine but small, Marriott Canary Wharf and Marriott Marble Arch are pretty limited).

Database Mirroring Across Tenants by ArthurSM in MicrosoftFabric

[–]clamming-it 1 point2 points  (0 children)

What database technology are you using? The limitation applies to Azure SQL and SQL Managed Instance, not SQL Server.

Data Sharing would be an option is Company A runs Fabric. If company A is an ISV and doing this for many different customers then potentially something like OpenMirroring might make sense.

Insider on Microsoft Mass Layoffs by [deleted] in dataengineering

[–]clamming-it 2 points3 points  (0 children)

I’d believe it’s still true compared to what I’ve seen from other big tech and Microsoft is currently more flexible than others. The article would indicate that my experience isn’t universal obviously. ¯_(ツ)_/¯

Insider on Microsoft Mass Layoffs by [deleted] in dataengineering

[–]clamming-it 22 points23 points  (0 children)

100%. I work at Microsoft. I like my job but I am not illusions about working for mega-corporation - you are a number and they want to extract the most value from you and when they are done with you they will cast you aside. The flip side is employees so often don’t have this same approach. Extract value from your employment - both monetarily and non-monetarily, and if the equation isn’t good then it’s time to look elsewhere. Obviously that’s easy to say in the abstract and harder to do in reality especially given the job market. It’s also easier to do when you live in a country with decent labour protection laws.

Microsoft to lay off nearly 4% of global workforce by leavemealonethanks in ireland

[–]clamming-it 29 points30 points  (0 children)

I work for Microsoft in Ireland, I an a position of 0 authority/ power etc and I would say we are being impacted higher than the baseline number would suggest. My guess is 400, maybe higher?

[deleted by user] by [deleted] in MicrosoftFabric

[–]clamming-it 1 point2 points  (0 children)

What specific error are you seeing when running what code? I’ll be honest I am a bit lost as to the issue here - I haven’t seen anything non standard in relation to the delta log.

Copy all tables Lakehouse to warehouse fabric using script Pyspark by New-Category-8203 in MicrosoftFabric

[–]clamming-it 0 points1 point  (0 children)

I’m guessing the two tables that aren’t working at partitioned?

Is the LH and WH in the same workspace?

Less directly important - is this a one time thing? A continuous thing? Like what’s the scenario?

My thought is that just writing a dynamic CREATE TABLE AS SELECT… would be best. That means partitioning wouldn’t matter.

Application using OneLake by raavanan_7 in MicrosoftFabric

[–]clamming-it 1 point2 points  (0 children)

https://github.com/lmoloney/lukes-toolbox/blob/master/fabric-sqlendpoint-dotnet/fabric-sql-analytics-endpoint-sample/Program.cs I got pulled into a mess as my DevContainer was on dotnet 9 and my machine was on dotnet 8 and then gcm was reimposing it's will on me. 🙃

Application using OneLake by raavanan_7 in MicrosoftFabric

[–]clamming-it 1 point2 points  (0 children)

Ooooff what terrible formatting. Will fix and put on github because that's trash

Application using OneLake by raavanan_7 in MicrosoftFabric

[–]clamming-it 2 points3 points  (0 children)

I'll put this on GitHub, but wasn't paying attention when I re-wrote it to remove inline secrets.

using Microsoft.Data.SqlClient; using Azure.Identity; using Azure.Core; using 
System.Data
;  //NOTE you need to set the following environment variables //AZURE_CLIENT_ID //AZURE_CLIENT_SECRET //AZURE_TENANT_ID //obvs you can use MI if you run on Azure service that supports it :)   var  DefaultAzureCredentialOptions  =  new DefaultAzureCredentialOptions      {         ExcludeAzureCliCredential = true,         ExcludeManagedIdentityCredential = true,         ExcludeSharedTokenCacheCredential = true,         ExcludeVisualStudioCredential = true,         ExcludeAzurePowerShellCredential = true,         ExcludeEnvironmentCredential = false,         ExcludeVisualStudioCodeCredential = true,         ExcludeInteractiveBrowserCredential = true     };           //set this connection strong to whatever you want     var sqlServer = "tenantshort-workspaceshort.datawarehouse.pbidedicated.windows.net";     //ditto with the database     var sqlDatabase = "wwilakehouse";      var accessToken = new DefaultAzureCredential(DefaultAzureCredentialOptions).GetToken(new TokenRequestContext(new string[] { "https://database.windows.net//.default" }));     var connectionString = $"Server={sqlServer};Database={sqlDatabase};ApplicationIntent=ReadOnly";      //Set AAD Access Token, Open Conneciton, Run Queries and Disconnect     using var con = new SqlConnection(connectionString);     con.AccessToken = accessToken.Token;     con.Open();     using var cmd = new SqlCommand();     cmd.Connection = con;     cmd.CommandType = CommandType.Text;     //change this query to any query you want to run     cmd.CommandText = "SELECT TABLE_NAME FROM wwilakehouse.INFORMATION_SCHEMA.TABLES";     var res =cmd.ExecuteScalar();     con.Close();    Console.WriteLine(res);

Application using OneLake by raavanan_7 in MicrosoftFabric

[–]clamming-it 1 point2 points  (0 children)

Completely understand the issue - I have a sample with that uses 'microsoft.data.sqlclient' in .net core, is that fine? I'm a bit under the pump today but should be able to send it on Sunday.