Toni

🚀 ¡El 27 de marzo estaremos en @GofiGeeks (Gran Canaria) con dos sesiones sobre Front End! Una sobre Astro y otra sobre TanStack Start🎙️✨ 📍 Gofi Geeks, Gran Canaria 🔗 Más info: meetup.com/gofigeeks/even… Gracias a @GofiGeeks y al @GranCanariaCab por hacerlo posible 💙

Looking for Speakers for the 2025 calendar year for the Hampton Roads SQL Server User Group 3rd wed of every month IN PERSON If you would like to visit Virginia Beach to speak let me know We usually book up really quickly as of now I only have 7 spots left meetup.com/hampton-roads-…

To explain this a bit more to those who have asked: The documentation for CAST & CONVERT says: Starting with SQL Server 2012 (11.x), when using supplementary character (SC) collations, a CAST operation from nchar or nvarchar to an nchar or nvarchar type of smaller length won't truncate inside a surrogate pair. Instead, the operation truncates before the supplementary character. Under an SC collation, each character has a variable byte length. For example, N'X' takes 2 bytes, while N'😎' uses 4 bytes. The string N'X😎' (both characters together) requires 2 + 4 = 6 bytes of storage, corresponding to nvarchar(3). The number in brackets is the number of byte-pairs, not the number of characters. Three byte-pairs = 2 * 3 = 6 bytes. Yes, it's confusing but that's how it is. -- Returns 6 (bytes) and 2 (characters) DECLARE @y nvarchar(3) = N'X😎'; SELECT DATALENGTH(@y), LEN(@y); If we convert the string to a smaller type, truncation occurs: -- Returns "X", 2 (bytes), and 1 (character) DECLARE @y nvarchar(3) = N'X😎'; SELECT CONVERT(nvarchar(2), @y), DATALENGTH(CONVERT(nvarchar(2), @y)), LEN(CONVERT(nvarchar(2), @y)); This is the correct behaviour. Truncation stores as many whole characters from the string as will fit in the destination type. nvarchar(2) offers 2 * 2 = 4 bytes, which is only enough to store the first character, N'X'. There is not enough space left to store the 4 bytes of N'😎'. The bug occurs when the source is a LOB type, the destination is nvarchar (or nchar), truncation is needed, and the truncation point occurs within a (variable length) character. Using the same example with a LOB source: -- Returns "X�", 4 (bytes), and 2 (characters) DECLARE @y nvarchar(max) = N'X😎'; SELECT CONVERT(nvarchar(2), @y), DATALENGTH(CONVERT(nvarchar(2), @y)), LEN(CONVERT(nvarchar(2), @y)); The funny-looking second character is the first 2 bytes of N'😎' (which requires 4 bytes). Conversion has split this character in half! This is the bug.

Oye ¿Y si desarrollamos una herramienta open source online para crear mocks UI de baja fidelidad (wireframes)? Alumnos... "¡ a por ello!" :), nos lo estamos pasando en grande: github.com/Lemoncode/quic… esperamos tener primera alfa en los próximos meses 🚀, muy agradecidos si RT

Como crear una canción de regueton? Aquí una master class!!

¡Regístrate gratis, colabora con tu donación y disfruta! #OpenSouthCode24 Con el patrocinio de @CervezaVictoria 🤗 mailchi.mp/3881904768e8/d…

@plainconcepts @AzureMalaga Muchas gracias por todo ☺️

@AzureMalaga ¡Esperamos que la disfrutes! 🎒

No te pierdas mañana a las 10:00 el #GlobalDevopsx en maps.app.goo.gl/ZbCRgriJDRjTUz… Gracias a @plainconcepts se sorteará una magnífica mochila y dos entradas para la #dotNET2024 🤟

#OpenSouthCode24 Ya puedes consultar el programa. Estas son las charlas de la Sala Fuengirola del 21 de junio ¡Inscríbete gratis! 👉 opensouthcode.org/conferences/op…

@DataGrillen Thanks

@Iceblack2k Around January each year. We typically "sell out" inside a week or so

Soon

So, you want to see changes in SSMS? And you're a developer? Now's your chance! The engineering team I work with (and love) is hiring for a Senior Software Engineer 🖥 Job posting here: jobs.careers.microsoft.com/global/en/job/… 1/x

7 Aplicaciones para aprender a programar! youtu.be/T4s_7pPlIe8?si…

@erinstellato Is it planned to integrate with Copilot in future?

So we're all on the same page, SSMS has not been abandoned 😉 It is true that we don't update as frequently as VS, but there are some changes on the horizon. Stay tuned!

same DB in 2 subscriptions in azure with the following tier Service tier: General Purpose Compute tier: Provisioned Azure Hybrid Benefit: Applied vCores10: vCores Max storage: 750 GB The cost are double in one subscription than in another any clue where to look for Ta #sqlhelp

Toda la vida llevando pantalones pitillos elásticos y viene a atacarme el Hombre Elástico #CalicoElectronico #Cómic #humor Puedes comprar los cómics de #CálicoElectrónico "Las tiras de Cálico" ( 0xword.com/es/comics/151-… ) y "Las tiras de Cálico 2" ( 0xword.com/es/comics/214-… )

Acertijo.

Nuevo curso en el Blog/Canal, como siempre todo primero en el blog, va a tratár sobre las librerías más populares de este nuestro lenguaje mas querido dentro de #dotnet netmentor.es/curso/libreria…

📬 A Little About Windowing Functions And Joins In SQL Server: ift.tt/gGSFlxN 📬

🧑‍💻Azure Data Studio 1.45 is now available! Blog post coming soon😅 For now, please peruse the release notes while you update ADS, and then let me know what new item you're most excited about! learn.microsoft.com/en-us/sql/azur…

Lo pedisteis y aquí está, repo genérico para entity Framework #dotnet #efcore youtu.be/pZ8E0V0bHfo