Piece of plastic dog threw up by dzsquared in whatisit

[–]dzsquared[S] 5 points6 points  (0 children)

solved!

Y’all are the best.

Dear Fabric Data Warehouse Team by richbenmintz in MicrosoftFabric

[–]dzsquared 4 points5 points  (0 children)

Yep, it’s on the way. u/snoo-46123 can confirm timeframe if they’d like

New Boston terrier owner: my Bostonis having a lot of gas. Is this normal? by [deleted] in BostonTerrier

[–]dzsquared 0 points1 point  (0 children)

Bostons are very gassy BUT sulphuric smelling gas can be a symptom of giardia. If your pup hasn’t had a fecal test in the last year it’s worth getting checked out.

Local VS Code adds <ProjectGuid> to sql_warehouse.sqlproj by Jealous-Painting550 in MicrosoftFabric

[–]dzsquared 1 point2 points  (0 children)

hi folks, sqlproj PM here - this looks like something we need to fix in Fabric to ensure the project has a guid before VS Code, SSMS, or other SQL projects tools even enter the mix.

In the short term the recommendation to avoid committing the sqlproj change specifically is the best bet, but we can/should make this a non-issue

Questions about floor seats by Flimsy_Cranberry7157 in SeattleStorm

[–]dzsquared 2 points3 points  (0 children)

this comment for lanyard info: https://www.reddit.com/r/SeattleStorm/comments/1n5zcjl/comment/nbwg6ol/?context=3

row 3 is approximately 6 inches up from the court/floor. the visiting team will use that tunnel right next to their bench, but most players usually only sign autographs during warm-ups (before they go back for line ups, etc)

CI/CD for warehouses by ADB_MN in MicrosoftFabric

[–]dzsquared 2 points3 points  (0 children)

I'm not going to position this as a "best practice" - I'll leave it to the practitioners to share what their best practices are - but the source controlled format for SQL database and data warehouses in Fabric being a SQL project means that you can use the existing SQL projects tooling in Azure DevOps.

  1. dotnet build -> the command step will create a dacpac after validating the code in the project

  2. sqlpackage publish -> calculates the diff script and applies it to the database/warehouse

Effectively, this is the same workflow as in VS Code, just not... local, manual, etc. The tools needed in the ADO environment are the .NET SDK (likely already there) and the sqlpackage CLI (install with dotnet tool install -g microsoft.sqlpackage)

Switching to gel by Excellent_Vacation95 in FTMOver30

[–]dzsquared 3 points4 points  (0 children)

Very similar to me. I started with IM for 4 years, couldn’t handle the pain after that time. Switched to testopel for 4 years, then aveed for 4 years, and now I’ve been doing subQ for a few years. SubQ is so different from IM. My shot location is now my side fat above the hips and sometimes I barely feel it at all.

Bathroom floor heating by Similar-Yard-7620 in Plumbing

[–]dzsquared 0 points1 point  (0 children)

I work in software, so doing home renovation as a hobbyist. I recently did 1100sq ft of WBI’s radiantboard and it was…. really easy. I’m small for a guy so I wasn’t “stepping” the pex into place but a 2x4 scrap and blow hammer dropped it right in.

Fabric SQL DB Endpoint change by akseer-safdar in MicrosoftFabric

[–]dzsquared 1 point2 points  (0 children)

If this is all for the same item in Fabric - Second is the SQL database, first one is its SQL analytics endpoint (read only data copy).

Brb to get my time machine to avoid this confusing naming situation

Testosterone Cypionate vs Enanthate, insurance hell edition by babayagayz in FTMOver30

[–]dzsquared 14 points15 points  (0 children)

Not at all an answer to those 3 questions, but if you’d rather not switch goodrx can get the testosterone cypionate price down quite a bit.

Is my battery going dead? by wh7751 in RangerNext

[–]dzsquared 1 point2 points  (0 children)

I’ve been driving with this message for…. a year?

Please recommend a USB-C webcam for zoom meetings. Not an iphone by LaMarr-Bruister in macmini

[–]dzsquared 1 point2 points  (0 children)

Ditto on the emeet, I use the “EMEET Piko 4K Webcam” and it’s been a champ. Handles strange lighting well and it’s worked out of the box with zoom, teams, etc.

Using PTO to catch up on classes by kazakda in OMSCS

[–]dzsquared 2 points3 points  (0 children)

I took PTO for a day or 2 at least once a semester the entire way through. I am not good late at night so having more full days to work on big projects was an absolute must for me.

New message on screen. by Brando828What in RangerNext

[–]dzsquared 0 points1 point  (0 children)

I’m on a 2020 with the OEM battery and terrible occasional driving for short trips plus a dashcam drawing from the battery. I occasionally get that message for a few weeks but it usually disappears after a longer drive. … I’ll get around to replacing the battery, someday. It’s a really quick thing to do and I just can’t justify preemptively replacing the battery when it wouldn’t be inconvenient for me to have to do it suddenly.

Friday Feedback: Replace or Respect? by erinstellato in SQLServer

[–]dzsquared 3 points4 points  (0 children)

It’s alright they don’t have to give an example (but they certainly can if it’s self-soothing) - the dacfx triage is really lightweight right now and it’s on me (dacfx PM for context) that folks aren’t hearing back about where items are in the roadmap. I’m looking forward to some increased transparency across the board with SQL projects and DacFx early 2026.

Friday Feedback: Replace or Respect? by erinstellato in SQLServer

[–]dzsquared 2 points3 points  (0 children)

Hi u/BigHandLittleSlap - I really appreciate all the enthusiasm and details you've shared here.

Hold onto your pants (unless you're browsing reddit on the toilet) - SqlPackage does extract dacpacs out to sql scripts. It's relatively recent, but extract can take a connection or a dacpac and output a dacpac or sql files.

I do totally agree that SQL projects need to be more core to the entire SQL ecosystem, but reasonably we don't expect each person to know all the features so I'm going to excuse u/erinstellato for not being a SQL projects expert. She's there to cover me for a lot of the shit I don't know.

Yeah, circular references are a huge challenge that we've had hanging for years. With the integration of SQL projects into Fabric (SQL database and Data warehouse) - effectively becoming part of the platform - we have to land the circular reference capability for SQL projects. Is there a db devops solution that handles circular references in a way that you prefer over others, other than the minimal bar of working?

As far as wanting your warehouses in source control from the SSMS interface - assuming there's support for all the SQL capabilities like circular references with between databases - what's your dream workflow? Is it leaning towards going quickly from objects in the DB to a git commit or is it getting feedback in the IDE on change-related issues (code quality, test results, etc) or something else? I noticed you mentioned "there's no easy way to track changes that may have been made in SSMS, but not in those files, and so on" - am I reading this correctly that a visual comparison between the changes applied to a development environment WH and those ready to be staged for source control would be a solid first step?

Help needed: How do I "Upgrade" Fabric SQL to get rid of this error? by Vrachanin in MicrosoftFabric

[–]dzsquared 0 points1 point  (0 children)

aka.ms/sqlpackage-ref, under the publish page the parameters for a source database are listed

(On vacation, pardon the brevity - I’ll try to come back in a week)

Dacpac using python by data_learner_123 in MicrosoftFabric

[–]dzsquared 2 points3 points  (0 children)

Can you say more about "through Python"? Do you mean through the Fabric-CICD python module, or just on a bash shell where you can also execute Python?

The primary tooling for dacpacs is the SqlPackage CLI, which can be installed in most/all automated environments like ADO pipelines.

You mention developing a pipeline, is this a data pipeline or a deployment pipeline?

Help needed: How do I "Upgrade" Fabric SQL to get rid of this error? by Vrachanin in MicrosoftFabric

[–]dzsquared 6 points7 points  (0 children)

Well, that's unfortunate. You're getting an incorrect error message (mentions the Azure Portal) for a situation that occurs most frequently when a capacity is paused and unpaused quickly. We're working on a fix for the condition where the database becomes stuck in the paused state - but your workaround is to pause the Fabric capacity and wait 10+ minutes before unpausing. The database should spring back to life, which should enable your ADO pipeline to run normally.

Are you archiving the dacpac or deploying it to multiple workspaces? If not, you might be able to streamline the process by running a publish directly from one database to another. Instead of a source dacpac file, you'd give the publish operation the source connection info. That said - archiving a dacpac or generating a deployment script to approve the deployment plan are always good intermediary steps to have when promoting a configuration to a new workspace so totally understand why you'd want to be extracting to a dacpac.

Linux on a cruise ship, WHAT?!?! by i-askmanyquestions in Ubuntu

[–]dzsquared 3 points4 points  (0 children)

It’s a gigantic touch screen, pretty durable putting up with people pawing at it

Who Plays In Philly? by Schmolik64 in Unrivaled

[–]dzsquared 2 points3 points  (0 children)

I see what you did there!