#SSMS

[tweakingsql]

Creating objects on SSMS and merging with VS project

Next let's create a function in SSMS. Then we can see how to incorporate that into the SSDT project.

This changes a date string into the format of our DateSIDs.

To pull this into the VS project, click on Tools > SQL Server > New Schema Comparison.

We use the database on SQL server as the source, and we happen to already have that as a connection.

Select the connection, and click OK.

For the target, we can use the SSDT Project.

And click on OK.

Now the Compare button above the source is active. We can click that and see what happens. We can see the list of differences between the source and target. You can turn off the items to not make changes to by clearing checks from the boxes. To actually make the changes, we click on the Update button.

We confirm we want the changes made. Then we can drill into the project in solution explorer, and see that the dbo schema now has a function.

OK, now let's go the other direction and push changes to the database. We create a dapac file for our project by right-click on the solution's name, then click Build.

Then we can right-click on the solution's name, and select Publish. We need to select a target database. For now, I'm just reusing the same database, but it could go to a different SQL server for testing.

Now we can click on publish, and all the new items are placed into the SSMS database.

It's one way to keep everything in sync and stored.

[thedbahub]

Why Scalar UDFs Appear in Estimated but Not Actual Query Plans in SSMS

Introduction Have you ever noticed that when you view query plans in SQL Server Management Studio (SSMS), scalar user-defined functions (UDFs) appear in the estimated plan but mysteriously vanish from the actual plan? In this article, we’ll explore the reasons behind this behavior and discuss its implications for query optimization and performance. Understanding Scalar UDFs Scalar UDFs are…

[seniordba]

Free Download: SQL Server Management Studio 19.2

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. Microsoft has announced the latest release of SQL Server Management…

[mrjerrychang]

MS SQL 做「主索引鍵」不允許儲存【SQL2019示範替代方法】

有時候在開發程式時會需要搭配微軟SQL Server服務來存取資料，有些資料欄位程式設計師做上「主索引鍵」(稱:做Key)，偶爾會發一種狀況資料表欄位都設計好了最後卻無法存檔，變得存檔也不是，不存檔又白費功夫設定資料表，如何解救此狀況… Continue reading Untitled

[globaltechlearn]

Learn how to install Microsoft sql server and management studio .

[jobean12-blog]

LOVE THIS! Yay! Beautiful my sweet ❤️😍❤️

Selene's summer moodboard sleepover

Running from 15th of august to the 18th!!!

⋆ ★ you can request up to three times from each category so I won't get too overwhelmed

⋆ ★ will be receiving the asks and answering them as time and inspiration allows (also because it took me two weeks to make them last time asidjasdkasdk)

⋆ ★ YOU HAVE TO BE 18+ TO PARTICIPATE! (i am a super minor hater)

⋆ ★ marvel, dc, star wars, hottie actors, ya know the usual

‿︵‿︵୨˚̣̣̣͙୧ - - ୨˚̣̣̣͙୧‿︵‿︵‿︵‿︵୨˚̣̣̣͙୧ - - ୨˚̣̣̣͙୧‿︵‿︵

Standard time!

Character + action: you can request pretty much any character, an alternate universe or not, and something for them to do or a color scheme.

(ex. Natasha Romanoff + ballet, mechanic! Tony Stark + cottagecore.)

Cutie time! (restricted for mutuals + friends only!)

I can make you a moodboard with your favorite character or multiple characters and a setting with you. Just give me a brief physical description so I can match the pictures.

(ex. Day in the beach with Bucky Barnes x brunette plus size reader.)

Dice time!

You ask for a moodboard and I simply deliver :) (it'll mostly end up being something cute, like ducks or chickens hehehe)

Story time!

I can make a mb for one of your stories, just give me a short description if it's a wip or link me. mutuals can choose the random option where I pick a story myself and it's a surprise for you ;)

‿︵‿︵୨˚̣̣̣͙୧ - - ୨˚̣̣̣͙୧‿︵‿︵‿︵‿︵୨˚̣̣̣͙୧ - - ୨˚̣̣̣͙୧‿︵‿︵

no pressure tagging: @alohastyles-x, @stargirlfics, @chelleztjs18, @inklore, @bvckysmoon , @that-sarcastic-writer , @wint3r-h3art , @writing-for-marvel , @psychedelic-ink , @targaryenvampireslayer @e-dubbc11, @starlady66

[voldkat]

every single star in the sky , all for me to behold

[supahsaucemann]

pomni

funny trauma jester

[dreamingeyes]

the peter parkerverse

ALSO i drew peter parker from ultimate spiderman as ugly as i did because he looks so fucking ugly in the show i can't stand it 😭 he does not look like he is 16 his face is so ugly 😭😭😭 one point for msm 2017 they made peter cute (they also made aunt may hot)

UPDATE: i have watched more of the show and ultimate spiderman peter parker is no longer considered to be ugly 🎉🎉🎉

[sastielsfandom]

I know Sam believes in Cas whenever it seems like Cas has gone darkside because of the trust they share. But I find it funny to think that a part of Sam is just like you're not a serial killer but you're close enough to one. I shouldn't like you more because of it but here we are. Don't tell Dean.

[tweakingsql]

Introductions

Eventually, I want to get to the point where I can write an extension for SQL Server Management Studio (SSMS) that will do a few things:

Pretty up what's been entered, or at least get consistent spacing.

Find from a standard place or a specified one and use a list of antipatterns, and show where it's happening in file of SQL commands.

Find (standard or ad hoc) and use tuning hints that would make it easier to tune the stored procedures people write.

Be able to run 2 or 3 across an entire server's worth of functions and stored procedures. Bonus if I could get it to then look at what's running, determine if it's been looked at, and if not check it out (for people that don't store their code on the server).

I've been wanting to try to do this for a while. I know what has to happen, but I haven't used tools to do this since I was in college, and the state of the art is much more advanced. And in some ways, a bit more backwards.

I'm working in SQL, but actually we use T-SQL (aka Transact SQL) which is Microsoft's variant of the language. And is there documentation of T-SQL? Of course not. Why would anything change in their corporate wisdom? They started putting out something called the ScriptDOM (DOM = document object model), and that will create an Abstract Search Tree that we can then process to find problems.

Does it work on it's own, using unspecified scripting languages? Sure. Does it work in SSMS the most used tool for SQL at work? Nope. Does it work natively in Visual Studio (VS)? Nope.

So what I'm trying to do is use ScriptDom in VS, then write an extension to SSMS using VS (that's how it's done) that could be approved for all users at work and installed to whoever wants it, and have a single place where the rules sit. Embedding the rules in the extension is feasible, but not flexible.

[bazooka-overkill]

super macho man drives— or, more accurately, *drove*— a cyber truck, which aran ryan quickly stole and totaled

it was called the "bogusbile," or "the bogus mobile"

[seniordba]

Free Download: SQL Server Management Studio 19.1

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. The SSMS 19.x installation doesn’t upgrade or replace SSMS versions…

[onebadpunspoilsabunch]

She knows who he is, as she referred to him by name. And yet she is not afraid!

 (Although she could’ve just called him that because he’s... well, a sand man.)

[sansastarkmeta]

An early outline of AFFC written around 2003-04 by GRRM was recently shared on r/asoiaf. Read the original post here for more info.

Two entries are notes for Sansa POV chapters:

A)

SANSA DIVIDE CHAPTER – LF: CERSEI HAS OVERREACHED SHE'LL SOON BE DONE

LF of course stands for Littlefinger.

B)

SANSA ?OLD - RESOLVE TO BE SS & TAKE NORTH 1 - TOURNEY OF WINGED KNIGHT 2 - SWEETROBIN [WOOS? WEDS? unclear] 3 - NEWS FROM W.H. KILL THE MOUSE ④

SS very likely stands for Sansa Stark, and W.H. for White Harbor. The mouse of course refers to Ser Shadrich.

The people at r/asoiaf who transcribed GRRM's handwriting favor the reading 2 - Sweetrobin *woos, but *weds is also possible, as well as *wees although less likely.

The circled 4 seems to indicate the then total count of Sansa POV chapters that GRRM had already written drafts of (3) plus one he was planning on writing (already partially written).

As for what can be inferred from all this... The first note almost certainly became AFFC Alayne II. The second one seems to concern an unpublished chapter or chapters that GRRM moved to TWOW. Given it's been twenty years since he wrote this outline, this raises the question: does he still intend to follow this note? Assuming he does, there are some things we can extrapolate and speculate on:

Sansa will not lose herself into the Alayne persona, and is soon heading North to reclaim her identity and Winterfell/the region for House Stark.

The tourney of winged knights is mentioned in the TWOW Alayne I preview from 2015, so this indicates GRRM had the idea for it for at least a decade prior.

Interpretation of the line regarding Robert Arryn is dependant on the reading. If it's *woos it might refer to Robert's infatuation with Alayne, which we've seen in Sansa's last published chapter, AFFC Alayne II, and in the TWOW Alayne I preview from 2015. If it's *weds... the most straightforward reading would be that Robert marries someone, even potentially Alayne/Sansa. Considering Petyr's plans for rulership of the Vale which he reveals in AFFC Alayne II, both scenarios seem surprising.

News from White Harbor most likely refers to news of Ramsay's wedding to Arya Stark. There's no telling whether that includes the crucial detail that the bride is truthfully Jeyne Poole. Another option could be news of the mutiny at Castle Black and some kind of update on Jon, whether that's his death, his speculated resurrection or confusing reports about both and whether he was ever dead at all. Of course, the news could be a mix and match of all of this, too. Any of these options could be the catalyst for Sansa going North.

The strikethrough could indicate these ideas were either moved elsewhere or dropped entirely. Or perhaps GRRM returned to this page a second time and was denotting progress by crossing out passsages he'd since written/included in drafts?

Finally, kill the mouse either indicates that Sansa herself will kill Ser Shadrich or that his death will be featured in a Sansa POV chapter.

I admit I am not super knowledgeable when it comes to GRRM's interviews or any information outside the published novels, so if you're aware of anything that's been revealed in the past that might shed light on this outline, please share.

[tapwaterx]

assorted gobby sketches