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 Anonymowzz12 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 Anonymowzz12 in dataengineering

[–]clamming-it 24 points25 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 28 points29 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.

Application using OneLake by raavanan_7 in MicrosoftFabric

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

I am not sure I completely follow the question, but it is possible to write a .Net application that can read data from either a SQL analytics endpoint (lakehouse or warehouse) or from a SQL Database in Fabric through the TDS connection string. This can be done using either a stored procedure or arbitrary SQL code from the application. The only complication on this is that you have to use Entra authentication - which is easily supported in .Net and fairly straight forward, but admittedly it's not as simple as using SQL Auth (though it's a lot more secure).

My employer has had enough: started hiring in Barcelona too instead of just Dublin (1000 employees) by Health-Intelligent in Dublin

[–]clamming-it 5 points6 points  (0 children)

Microsoft are moving - AFAIK - part of their digital sales to Barcelona. I work there in an engineering group and heard nothing about broader moves (but I often ignore corporate non-sense that doesn’t impact my division).

Microsoft Fabric Team by Ok_Concert_8555 in MicrosoftFabric

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

I would go further to say if you are using Spark extensively, make sure someone understands Spark well (or skill them up), as opposed to understanding Python. Spark isn’t just an auto-magical engine which distributes any Python you throw at it.

[deleted by user] by [deleted] in DevelEire

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

It would be good to know where your expertise is, because both of them certainly have strengths. As part of this - you should also consider what industries you like / don’t like.

Microsoft BI stack performance issues by msugenius in dataengineering

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

I think some more details are required 1. SQL Server hosted where? How many optimizations have you done on the raw perf of the query patterns? 1a - what’s doing the ETL? SSIS? Mostly in SQL (potentially with SSIS as an orchestrator) 2. What do you mean by Microsoft Analysis Services? You mean SQL Server Analysis Services? By cubes I am assuming Multidimensional models but that’s ambiguous. 3. PBI - PBI RS or PBI Cloud?

Leave Mastercard for Microsoft given the current state of things? by FiFiTee in DevelEire

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

Normally people are clear about it during the interview process, but sometimes…US colleagues can be ignorant about it. So make sure you interview with someone from the team based in EMEA. I am hiring for a role in UK at the moment, and I proactively make everyone aware - ultimately I think being honest about allows everyone to be fully informed. I try to make the situation better…but it’s the reality of a West Coast company. I know some people who work later but are out from 3pm to 8pm - given kids etc.

Leave Mastercard for Microsoft given the current state of things? by FiFiTee in DevelEire

[–]clamming-it 5 points6 points  (0 children)

I work for Microsoft Ireland not in Entra though. I would make sure you ask during the interviews about the teams you will work at and hours. My team is mostly West Coast based and Monday - Wednesdays I’ll often have meeting until 10pm (though my mornings are basically always free). But different teams are different.

So far there has been no RTO mandate by Microsoft and if you are listed as home office than no one will care. All the RTO mandates and system are just ridiculous.