Alvin Ashcraft<p>Dew Drop Weekly Newsletter #425 - Week ending March 21, 2025.
<a href="https://zc.vg/v1Stg?m=0" rel="nofollow noopener noreferrer" target="_blank">zc.vg/v1Stg?m=0</a>
<a class="hashtag" href="https://bsky.app/search?q=%23dewdrop" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a class="hashtag" href="https://bsky.app/search?q=%23newsletter" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a class="hashtag" href="https://bsky.app/search?q=%23javascript" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a class="hashtag" href="https://bsky.app/search?q=%23azure" rel="nofollow noopener noreferrer" target="_blank">#azure</a> <a class="hashtag" href="https://bsky.app/search?q=%23cloud" rel="nofollow noopener noreferrer" target="_blank">#cloud</a> <a class="hashtag" href="https://bsky.app/search?q=%23windowsdev" rel="nofollow noopener noreferrer" target="_blank">#windowsdev</a> <a class="hashtag" href="https://bsky.app/search?q=%23csharp" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a class="hashtag" href="https://bsky.app/search?q=%23dotnet" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a class="hashtag" href="https://bsky.app/search?q=%23ai" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a class="hashtag" href="https://bsky.app/search?q=%23devops" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a class="hashtag" href="https://bsky.app/search?q=%23agile" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a class="hashtag" href="https://bsky.app/search?q=%23IoT" rel="nofollow noopener noreferrer" target="_blank">#IoT</a> <a class="hashtag" href="https://bsky.app/search?q=%23mobiledev" rel="nofollow noopener noreferrer" target="_blank">#mobiledev</a> <a class="hashtag" href="https://bsky.app/search?q=%23dotnetmaui" rel="nofollow noopener noreferrer" target="_blank">#dotnetmaui</a> <a class="hashtag" href="https://bsky.app/search?q=%23podcasts" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a class="hashtag" href="https://bsky.app/search?q=%23sqlserver" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a class="hashtag" href="https://bsky.app/search?q=%23data" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a class="hashtag" href="https://bsky.app/search?q=%23m365" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a class="hashtag" href="https://bsky.app/search?q=%23windev" rel="nofollow noopener noreferrer" target="_blank">#windev</a><br><br><a href="https://zc.vg/v1Stg?m=0" rel="nofollow noopener noreferrer" target="_blank">Dew Drop Weekly Newsletter 425...</a></p>
Recent searches
No recent searches
Search options
Not available on dice.camp.
dice.camp is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon server for RPG folks to hang out and talk. Not owned by a billionaire.
Administered by:
Server stats:
1.8Kactive users
dice.camp: About · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.3.7
#sqlserver
0 posts · 0 participants · 0 posts today
Vlad :verified:<p>Blog post from the past:</p><p>In which I go through my SQL Server Management Studio configuration. </p><p><a href="https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration/" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2023/01/31/my-sql-</span><span class="invisible">server-management-studio-19-configuration/</span></a></p><p><a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.cloud/tags/dba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dba</span></a> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mssqlserver</span></a> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mssql</span></a> <a href="https://mastodon.cloud/tags/sqlserverdba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserverdba</span></a></p>
LavX News<p>The Reluctance to Upgrade: Why SQL Server 2022 is Stuck in the Shadows</p><p>Despite the launch of SQL Server 2022, many administrators are hesitant to migrate from SQL Server 2019, citing cost and lack of compelling new features. This article explores the underlying reasons f...</p><p><a href="https://news.lavx.hu/article/the-reluctance-to-upgrade-why-sql-server-2022-is-stuck-in-the-shadows" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.lavx.hu/article/the-reluc</span><span class="invisible">tance-to-upgrade-why-sql-server-2022-is-stuck-in-the-shadows</span></a></p><p><a href="https://mastodon.cloud/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>news</span></a> <a href="https://mastodon.cloud/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://mastodon.cloud/tags/CloudComputing" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CloudComputing</span></a> <a href="https://mastodon.cloud/tags/DatabaseManagement" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseManagement</span></a> <a href="https://mastodon.cloud/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a></p>
Alvin Ashcraft<p>Dew Drop Weekly Newsletter #423 - Week ending March 7, 2025
<a href="https://buff.ly/hLA2GtR" rel="nofollow noopener noreferrer" target="_blank">buff.ly/hLA2GtR</a>
<a class="hashtag" href="https://bsky.app/search?q=%23dewdrop" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a class="hashtag" href="https://bsky.app/search?q=%23newsletter" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a class="hashtag" href="https://bsky.app/search?q=%23javascript" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a class="hashtag" href="https://bsky.app/search?q=%23dotnetmaui" rel="nofollow noopener noreferrer" target="_blank">#dotnetmaui</a> <a class="hashtag" href="https://bsky.app/search?q=%23aspire" rel="nofollow noopener noreferrer" target="_blank">#aspire</a> <a class="hashtag" href="https://bsky.app/search?q=%23blazor" rel="nofollow noopener noreferrer" target="_blank">#blazor</a> <a class="hashtag" href="https://bsky.app/search?q=%23xaml" rel="nofollow noopener noreferrer" target="_blank">#xaml</a> <a class="hashtag" href="https://bsky.app/search?q=%23csharp" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a class="hashtag" href="https://bsky.app/search?q=%23dotnet" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a class="hashtag" href="https://bsky.app/search?q=%23agile" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a class="hashtag" href="https://bsky.app/search?q=%23ai" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a class="hashtag" href="https://bsky.app/search?q=%23devops" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a class="hashtag" href="https://bsky.app/search?q=%23IoT" rel="nofollow noopener noreferrer" target="_blank">#IoT</a> <a class="hashtag" href="https://bsky.app/search?q=%23mobiledev" rel="nofollow noopener noreferrer" target="_blank">#mobiledev</a> <a class="hashtag" href="https://bsky.app/search?q=%23sqlserver" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a class="hashtag" href="https://bsky.app/search?q=%23data" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a class="hashtag" href="https://bsky.app/search?q=%23m365" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a class="hashtag" href="https://bsky.app/search?q=%23podcasts" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a><br><br><a href="https://buff.ly/hLA2GtR" rel="nofollow noopener noreferrer" target="_blank">Dew Drop Weekly Newsletter 423...</a></p>
Iñaki de Miguel Díaz :verified_aroace:<p>He encontrado un plugin gratis pero no libre para el <a href="https://masto.es/tags/managementstudio" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>managementstudio</span></a> de <a href="https://masto.es/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> que me pone un theme oscuro y mis ojos supermiopes lo agradecen mucho XDD</p><p><a href="https://masto.es/tags/developers" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developers</span></a> <a href="https://masto.es/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a></p>
Da Red Gobo Darven Dissek ✅<p><span>Mais comment c'est trop bien DbaTools pour SQL Server !<br>On a commencé à faire mumuse avec au boulot, et plus on avance, plus on voit à quel point c'est génial.<br><br>Pour ceux qui galèrent à déployer du SQL Server en prod, arrêtez de le faire à la main, et utilisez les. Une ligne de commande, et paf, c'est déployé.<br>Les manips casse pieds à faire à la main dans SQL Manager ? C'est de l'histoire ancienne ça! Une commande et paf, c'est réglé.<br><br>Maintenant, scriptez tout ça, et profitez de la vie...<br><br></span><a href="https://social.maplatefor.me/tags/SqlServer" rel="nofollow noopener noreferrer" target="_blank">#SqlServer</a><span> </span><a href="https://social.maplatefor.me/tags/DbaTools" rel="nofollow noopener noreferrer" target="_blank">#DbaTools</a><span> </span><a href="https://social.maplatefor.me/tags/VisMaVieDeTech" rel="nofollow noopener noreferrer" target="_blank">#VisMaVieDeTech</a></p>
HistorySheWrote<p><span class="h-card" translate="no"><a href="https://mastodon.social/@DaveMasonDotMe" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>DaveMasonDotMe</span></a></span> Thanks for sharing this. I guess I'm getting a salute from Brent. I'm with you - not impressed. I got the Polyglot Notebook working, but with much pain.</p><p>Had a conversation today with a data scientist. He had so much trouble with ADS that he installed SSMS. I told him to just uninstall ADS and don't look back.<br><a href="https://mindly.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mindly.social/tags/VScode" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>VScode</span></a></p>
Alvin Ashcraft<p>Azure Data Studio Retirement.
<a href="https://techcommunity.microsoft.com/blog/azuresqlblog/azure-data-studio-retirement/4371009" rel="nofollow noopener noreferrer" target="_blank">https://techcommunity.microsoft.com/blog/azuresqlblog/azure-data-studio-retirement/4371009</a>
<a class="hashtag" href="https://bsky.app/search?q=%23cloud" rel="nofollow noopener noreferrer" target="_blank">#cloud</a> <a class="hashtag" href="https://bsky.app/search?q=%23azure" rel="nofollow noopener noreferrer" target="_blank">#azure</a> <a class="hashtag" href="https://bsky.app/search?q=%23sqlserver" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a class="hashtag" href="https://bsky.app/search?q=%23azuresql" rel="nofollow noopener noreferrer" target="_blank">#azuresql</a> <a class="hashtag" href="https://bsky.app/search?q=%23vscode" rel="nofollow noopener noreferrer" target="_blank">#vscode</a> <a class="hashtag" href="https://bsky.app/search?q=%23data" rel="nofollow noopener noreferrer" target="_blank">#data</a><br><br><a href="https://techcommunity.microsoft.com/blog/azuresqlblog/azure-data-studio-retirement/4371009" rel="nofollow noopener noreferrer" target="_blank">Azure Data Studio Retirement |...</a></p>
Vlad :verified:<p>Imagine running a version of SQL Server that's a quarter of a century old and thinking it's a good idea to expose it to the internet.</p><p><a href="https://mastodon.cloud/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.cloud/tags/MSSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MSSQL</span></a> <a href="https://mastodon.cloud/tags/Microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Microsoft</span></a> <a href="https://mastodon.cloud/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.cloud/tags/Security" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Security</span></a></p>
Make App Pie<p><strong>Introducing HANA</strong></p><p></p><p>While I had planned something about the General Ledger for this newsletter, circumstances changed, so I’ll do something entirely different.</p><p>As many of you know, I’m no longer with Scientific Device Laboratory. If you’d like to know more about that situation, I have described it in detail <a href="https://www.linkedin.com/pulse/road-ahead-whats-happening-bizoneness-steven-lipton-f3blc" rel="nofollow noopener noreferrer" target="_blank">here</a>, but the very short version is that I lost the ability to access SAP B1 for this newsletter for the last nine months.</p><p>Fortunately, I found someone to help. Richard Duffy and SMB Solutions are graciously providing me with a new Demo instance of SAP Business One, but with one Wrinkle: It is HANA.</p><p>Before I go into anything other topics, I’m writing a series of newsletters about how HANA affects SAP B1. We’ll cover the basics of how to write queries in HANA for those curious or needing to translate SQL to HANA and back. Once we have all that, I’ll share with you what I plan to do about writing this newsletter on a HANA system. I’ll assume you know SQL or have taken my course <a href="https://www.linkedin.com/learning/sap-business-one-reporting-and-customization/getting-the-most-from-sap-business-one" rel="nofollow noopener noreferrer" target="_blank">SAP Business One Reporting and Customization</a>.</p><p>First, let’s give a little background on HANA. SAP decided several years ago to make a database system they could use across their product line. It has its pluses and minuses. The marketing for HANA was often around its speed due to the in-memory column-based database.</p><p>Data in a computer system is stored in dimensional sequence, not the two dimensions we associate with a table. It is as if you had a spreadsheet of only one row.</p><p>The best we can do to represent a table is to take the rows or the columns as groups, add them in sequence, then add the next row or column.</p><p>Let’s suppose you had this table:</p><p>The data would be stored in row order like this in a row-based database.</p><p>This is fast for performance in adding and deleting data but presents performance problems in calculations. To get a sum for balances, for example, you have to load each row, get the balance, add it to the total, and then get the next row, which is lots of work.</p><p>On the other hand, a column-based database would do this:</p><p>All the data for the columns are grouped. To get a sum, it loads the column and sums it. Unlike the Row-based arrangement, there is no jumping around in the data, making it much faster. However, this usually requires in-memory access to the data instead of on-disk access. Such an arrangement requires a substantial amount of memory to run efficiently. Also, insertions and deletions of rows are more complicated as you add data in several places, not as one group.</p><p>HANA is not the only column-based database. Data analysis tools like Pandas and even Microsoft SQL Server 2012 have in-memory processing in columns.</p><p>Because the HANA implementation of the SAPB1 started from scratch, you will notice a different User interface when running HANA compared to a SQL Server version of Sap Business One. My disparaging quip about SAP B1 UI being as fashional as Windows 95 is no longer accurate.</p><p>I’ll discuss this UI in a later column, but from now on, you’ll see screenshots like this in my newsletters.</p><p>The real fun begins when you start making queries. HANA has its variant of SQL. Creating a query in the SAP B1 Query Generator of the names and quantities of inventory items produces this query.</p> <pre>SELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited",T0."OnOrder" FROM OITM T0 </pre> <p>You’ll notice the double quotes on the column names. Double quotes are required on column names. Some, like the table name, have optional quotes, but putting quotes around all tables, columns, and aliases like TO is legitimate and often good style.</p> <pre>SELECT "T0"."ItemCode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "OITM" "T0"</pre> <p>What’s in the Quotes is case-sensitive. Can you spot the two errors here?</p> <pre>SELECT "T0"."Itemcode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "oitm" "T0"</pre> <p><strong>“T0″.”Itemcode”</strong> and <strong>“oitm”</strong> do not have the proper case. Interestingly, it will work if I do <strong>oitm</strong> without quotes.</p><p>Comments are still two dashes. Like many other programming languages, HANA adopts the <code>/*</code> and <code>*/</code> for block comments.</p> <pre>-- This is a comment/*This is a block comment. You can add several lines until you use the termination character on the next line.*/</pre> <p>Basic selection, literal strings with single quotes, and sorting also work the same as SQL: this query works with a parameter and sorting:</p> <pre>-- A comment is two dashesSELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM OITM T0 WHERE -- Compound data filter T0."SellItem" = [%0] -- Parameter AND T0."PrchseItem" = 'Y' -- String Literal AND T0."OnHand" > 0 -- ComparisonORDER BY T0."IsCommited" -- Sorting</pre> <p>If you look at only the basics, HANA looks a lot like SQL. However, once you get past the syntax, HANA starts getting different from SQL. In the next newsletter, I’ll look at some commonly-used functions in HANA.</p><p><a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/database/" target="_blank">#database</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/hana/" target="_blank">#hana</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/performance/" target="_blank">#performance</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/sap/" target="_blank">#sap</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/sap-b1/" target="_blank">#sapB1</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/sql/" target="_blank">#sql</a> <a rel="nofollow noopener noreferrer" class="hashtag u-tag u-category" href="https://makeapppie.com/tag/sql-server/" target="_blank">#sqlServer</a></p>
Vlad :verified:<p>Blog post from the past:</p><p>In which I test and compare the insert speeds in various combinations of scenarios, including table types, recovery models, and hints.<br><a href="https://mastodon.cloud/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a><br> <a href="https://mastodon.cloud/tags/sqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqldba</span></a><br> <a href="https://mastodon.cloud/tags/microsoftsqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoftsqlserver</span></a><br> <a href="https://mastodon.cloud/tags/mssqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mssqlserver</span></a><br> <a href="https://mastodon.cloud/tags/mssql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mssql</span></a><br> <a href="https://mastodon.cloud/tags/mssqldba" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mssqldba</span></a><br> <a href="https://mastodon.cloud/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a><br><a href="https://vladdba.com/2023/06/22/testing-large-insert-speeds-in-sql-server/" rel="nofollow noopener noreferrer" target="_blank"><span class="invisible">https://</span><span class="ellipsis">vladdba.com/2023/06/22/testing</span><span class="invisible">-large-insert-speeds-in-sql-server/</span></a></p>
Rocky Lhotka 🤘🖖<p>Check out the upcoming <a href="https://fosstodon.org/tags/vslive" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>vslive</span></a> conference in Las Vegas.</p><p><a href="https://devblogs.microsoft.com/visualstudio/vs-live-2025-las-vegas/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">devblogs.microsoft.com/visuals</span><span class="invisible">tudio/vs-live-2025-las-vegas/</span></a></p><p><a href="https://fosstodon.org/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dotnet</span></a> <a href="https://fosstodon.org/tags/microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoft</span></a> <a href="https://fosstodon.org/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> <a href="https://fosstodon.org/tags/blazor" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>blazor</span></a> <a href="https://fosstodon.org/tags/aspnetcore" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aspnetcore</span></a> <a href="https://fosstodon.org/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a> <a href="https://fosstodon.org/tags/github" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>github</span></a> <a href="https://fosstodon.org/tags/devops" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devops</span></a></p>
Alvin Ashcraft<p>Dew Drop Weekly Newsletter #414 - Week ending January 3, 2025.
<a href="https://buff.ly/3DPKtzg" rel="nofollow noopener noreferrer" target="_blank">https://buff.ly/3DPKtzg</a>
<a href="https://bsky.app/search?q=%23cloud" rel="nofollow noopener noreferrer" target="_blank">#cloud</a> <a href="https://bsky.app/search?q=%23webdev" rel="nofollow noopener noreferrer" target="_blank">#webdev</a> <a href="https://bsky.app/search?q=%23dotnet" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://bsky.app/search?q=%23windowsdev" rel="nofollow noopener noreferrer" target="_blank">#windowsdev</a> <a href="https://bsky.app/search?q=%23javascript" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://bsky.app/search?q=%23xaml" rel="nofollow noopener noreferrer" target="_blank">#xaml</a> <a href="https://bsky.app/search?q=%23csharp" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a href="https://bsky.app/search?q=%23devops" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://bsky.app/search?q=%23agile" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a href="https://bsky.app/search?q=%23ai" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://bsky.app/search?q=%23podcasts" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://bsky.app/search?q=%23data" rel="nofollow noopener noreferrer" target="_blank">#data</a> <a href="https://bsky.app/search?q=%23m365" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a href="https://bsky.app/search?q=%23sqlserver" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://bsky.app/search?q=%23dewdrop" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a href="https://bsky.app/search?q=%23newsletter" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a><br><br><a href="https://buff.ly/3DPKtzg" rel="nofollow noopener noreferrer" target="_blank">Dew Drop Weekly Newsletter 414...</a></p>
Alvin Ashcraft<p>Dew Drop Weekly Newsletter #412 - Week ending December 20, 2024
<a href="https://zc.vg/kXAe2?m=0" rel="nofollow noopener noreferrer" target="_blank">https://zc.vg/kXAe2?m=0</a>
<a href="https://bsky.app/search?q=%23dewdrop" rel="nofollow noopener noreferrer" target="_blank">#dewdrop</a> <a href="https://bsky.app/search?q=%23newsletter" rel="nofollow noopener noreferrer" target="_blank">#newsletter</a> <a href="https://bsky.app/search?q=%23webdev" rel="nofollow noopener noreferrer" target="_blank">#webdev</a> <a href="https://bsky.app/search?q=%23javascript" rel="nofollow noopener noreferrer" target="_blank">#javascript</a> <a href="https://bsky.app/search?q=%23mobiledev" rel="nofollow noopener noreferrer" target="_blank">#mobiledev</a> <a href="https://bsky.app/search?q=%23IoT" rel="nofollow noopener noreferrer" target="_blank">#IoT</a> <a href="https://bsky.app/search?q=%23windowsdev" rel="nofollow noopener noreferrer" target="_blank">#windowsdev</a> <a href="https://bsky.app/search?q=%23ai" rel="nofollow noopener noreferrer" target="_blank">#ai</a> <a href="https://bsky.app/search?q=%23dotnet" rel="nofollow noopener noreferrer" target="_blank">#dotnet</a> <a href="https://bsky.app/search?q=%23csharp" rel="nofollow noopener noreferrer" target="_blank">#csharp</a> <a href="https://bsky.app/search?q=%23agile" rel="nofollow noopener noreferrer" target="_blank">#agile</a> <a href="https://bsky.app/search?q=%23devops" rel="nofollow noopener noreferrer" target="_blank">#devops</a> <a href="https://bsky.app/search?q=%23podcasts" rel="nofollow noopener noreferrer" target="_blank">#podcasts</a> <a href="https://bsky.app/search?q=%23m365" rel="nofollow noopener noreferrer" target="_blank">#m365</a> <a href="https://bsky.app/search?q=%23sqlserver" rel="nofollow noopener noreferrer" target="_blank">#sqlserver</a> <a href="https://bsky.app/search?q=%23data" rel="nofollow noopener noreferrer" target="_blank">#data</a><br><br><a href="https://zc.vg/kXAe2?m=0" rel="nofollow noopener noreferrer" target="_blank">Dew Drop Weekly Newsletter 412...</a></p>
Microsoft DevBlogs<p>Embedding models and dimensions: optimizing the performance to resource-usage ratio</p><p>Since the release of vector preview, we've been working with many customers that are building AI solution on Azure SQL and SQL Server and one of the m...</p><p><a href="https://devblogs.microsoft.com/azure-sql/embedding-models-and-dimensions-optimizing-the-performance-resource-usage-ratio/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">devblogs.microsoft.com/azure-s</span><span class="invisible">ql/embedding-models-and-dimensions-optimizing-the-performance-resource-usage-ratio/</span></a></p><p>By: Davide Mauri</p><p><a href="https://dotnet.social/tags/microsoft" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>microsoft</span></a> <a href="https://dotnet.social/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> <a href="https://dotnet.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://dotnet.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlserver</span></a></p>
Continued thread
Number 1 on my SQL Wishlist? An IN LIKE expression.
I just wrote a WHERE clause with 10 OR column_name LIKE ‘%column%value%’ expressions.
If I knew the exact values, I could have writtenWHERE column_name IN (‘column value 1’, …, ‘column value 10’)
All I want for Christmas is to be able to writeWHERE column_name IN LIKE (‘%column%value%1’, …, ‘%column%value%10’)
It's Christmas time, so I am going to start my SQL Wishlist. There is certain SQL syntax that does not exist, but that I find myself, over and over again, wishing did exist.
I use T-SQL (SQL Server) in my professional life and PostgreSQL for all of my hobby projects. If a feature doesn't exist in one of those two flavors, than I probably don't know about it (because it wouldn't do me any good anyway), but if I ever add something to the list that does exist, please tell me.
And sure, I know there are lots of ways to extend SQL's functionality, but these are things that would be so useful if they were just part of the standard syntax (or at least a vendor-specific version of it) and could be typed as quickly and easily as any other SELECT statement or WHERE clause.
Azure SQL 
Python!
I recently presented at Python Day 2024 on Langchain integration. I created a slide deck that I believe can be useful beyond just the session, so I wanted to share it here for everyone's benefit. The deck covers the most common topics for a Python developer: Is there a free version of SQL Server or […]
https://devblogs.microsoft.com/azure-sql/azure-sql-loves-python/
By: Davide Mauri
Azure SQL Devs’ Corner · Azure SQL ❤️ Python! - Azure SQL Devs’ CornerLearn how to connect to SQL Server using Python for Azure SQL development. Find out why Azure SQL is important for Python developers.
Qiita - 人気の記事 
ExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload