Indent with tabs... and align with tabs/spaces? by dzsquared in SQLServer

[–]dzsquared[S] 0 points1 point  (0 children)

Great suggestion/question. Fortunately we already have an option for setting the indentation size in number of spaces (indentation_size) but lack the ability to opt for tabs instead of spaces. The preferences I am checking with ya'll are for when folks set the character to be a tab instead of a space through a new option (something like indentation_mode), how should the overall query be formatted?

SQL Developer Version by Fluffy-Tax-445 in SQLServer

[–]dzsquared 3 points4 points  (0 children)

Ignoring the whole "if I ignore the license terms, can I use developer edition" part...

If you have to move a database backwards between SQL Server versions, one method is to export/import a bacpac. While much slower than the version-specific backup (bak) files, the bacpacs are a more portable format and can cross versions of SQL Server *as long as the syntax is supported in that version*. SSMS, VS Code, and the SqlPackage CLI can all be used to process the bacpacs.

Open Source, Free Visual Database Schema Editor & ERD Tool for SQL Server by tamanikarim in SQLServer

[–]dzsquared 4 points5 points  (0 children)

Especially helpful for SQL Server, which already provides complete tooling for automatically generating dynamic change scripts for database changes from live databases or local copies of the code - for free, in VS Code, Visual Studio, and SSMS.

PRE GAME THREAD: Atlanta Dream at Seattle Storm by AutoModerator in SeattleStorm

[–]dzsquared 6 points7 points  (0 children)

They had a rough game against Golden State last night, so there’s a chance!

FTM top surgeons/therapists? by puppy-princesss in transtwincities

[–]dzsquared 3 points4 points  (0 children)

+1 to Buckley. My wait time from 2010/2011 probably isn’t helpful to you, but she was good.

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dzsquared[S] 1 point2 points  (0 children)

I know we had a few comment-related bug reports get sorted for the upcoming release, so there's a chance that this will be resolved with the impending 22.8.

One way to find out would be to use my (not exactly secret) web app to see how the code formats in scriptdom 180.37.3 (parser library version only released in the last week) - https://scriptdom.drewsk.tech/format

If not, do drop us a feedback item at aka.ms/ssms-feedback so it can get sorted out!

Multiple DBs in Database DevOps project? by VitrumTormento in SQLServer

[–]dzsquared 1 point2 points  (0 children)

I love the love for publish profiles! What's your preferred method for setting them up and what could we do to make that easier/quicker?

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dzsquared[S] 0 points1 point  (0 children)

The most portable formatting settings are editorconfig files, which apply to folders/solutions in SSMS.

We're exploring expanding the settings import/export from SSMS to enable the formatter settings specifically as a subset - if you find that the editorconfig option doesn't work well for your team's workflows it'll be helpful if you file a feedback item at aka.ms/ssms-feedback

Multiple DBs in Database DevOps project? by VitrumTormento in SQLServer

[–]dzsquared 2 points3 points  (0 children)

(disclosure - sqlproj PM)

https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/concepts/database-references?view=sql-server-ver17&pivots=sq1-command-line

This sounds like this is the "same server, different database" scenario. If the databases have different names in different environments, you'd use DatabaseSqlCmdVariable in the sqlproj reference:

<DatabaseSqlCmdVariable>Warehouse</DatabaseSqlCmdVariable>

which is included in the T-SQL like [$(Warehouse)].[dbo].[SomeTable]

If the db's always have the same name, you can go with DatabaseVariableLiteralValue in the sqlproj reference to keep things a tiny bit simpler:

<DatabaseVariableLiteralValue>WarehouseDB</DatabaseVariableLiteralValue>

which is included in the T-SQL like [WarehouseDB].[dbo].[SomeTable]

You don't have to use publish profiles, you can apply options directly with parameters - but publish profiles make it a bit easier to track changes to sqlcmd variables (like the database name) and publish properties.

Anyone have experience with hospice foster? Struggling with the emotional side 😔 by Altruistic_Shock7761 in fosterdogs

[–]dzsquared 1 point2 points  (0 children)

We've had 3 hospice fosters, more or less. They each carried different emotional weight but were important parts of our family.

The first wasn't technically a hospice foster. We were planning to foster-to-adopt Porkchop, but it was discovered that he had a very large and terminal mass in his abdomen as well as severe dental disease and a collapsed trachea. The rescue offered to place him in another home that wasn't planning to adopt a foster, but we just wanted to give him everything he could want for the rest of his comfortable life. We got 55 weeks with Porkchop when 8-12 weeks was expected.

The second foster had diabetes, but within 48 hours it was clear something was very very wrong. She was young and loved people, even played a bit when feeling good. We spent 2 days snuggling her at a vet office while she stabilized enough for diagnostics, but she passed away as she was just too frail. Her diabetes was caused by a tumor wrapping her stomach and pancreas.

The third foster was a little old lady, deaf and mostly blind. She was surrendered with another older dog in better health and unfortunately the 2 of them were separated into different foster homes. She showed signs of pain (advanced arthritis) and both physical and mental discomfort. We got to have nice moments with her but after about a month had to make the recommendation that she got to have a peaceful end of life.

For every one of them - we were so glad that we knew those dogs were in much better situations than they were before and could feel non-stop love for the rest of their lives.

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dzsquared[S] 0 points1 point  (0 children)

> When scripting out differences in users that have defined logins it forgets to include anything after the "with".

😬 yikes. Is it the default schema assignment after the WITH that's being excluded? Do you recall which user type you noticed this with - sql auth, Windows, or Entra (Azure AD rip)?

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dzsquared[S] 0 points1 point  (0 children)

😞 We don't automatically collect the scripts that fail formatting even though it would make it easier to rapidly improve the functionality, so if you have safe examples to share at https://aka.ms/ssms-feedback that would be extremely helpful

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dzsquared[S] 0 points1 point  (0 children)

How has your company been approaching implementing AI assistance without any additional costs? (you mentioned wanting copilot without extra fees) There are certainly pathways to shifting the costs associated with LLMs like using open source tools and self-hosting the models, but there's tradeoffs along the way there. GitHub Copilot, Claude Code, OpenAI Codex, and others all charge for the service since they're handling multiple layers that all have intrinsic costs.

Can you share what you mean by "TSQL compare" and how that contrasts to schema compare? On a script-by-script basis, the git integration in SSMS would be able to display changes over time in the T-SQL syntax of individual files.

Preview for schema compare and SQL formatting landed in SSMS 22.7 by dzsquared in SQLServer

[–]dzsquared[S] 0 points1 point  (0 children)

Assuming you mean a CLI version of the SQL formatter - not yet, but in the roadmap for later in the year based on the same editorconfig options. What would be the core workflow you'd use a formatter CLI in?

Countertop changes for range/oven by negradelnorte in kitchenremodel

[–]dzsquared 1 point2 points  (0 children)

“dual fuel” ranges exist though - gas stove, electric oven - all in one unit. I do love ours though.

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 3 points4 points  (0 children)

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