#TSQL
LightNews LightNews
dbtools.bsky.social
tsql is a typescript sql query builder that catches db errors at compile time instead of runtime, with a fluent api for building complex queries safely.

https://dbtools.dev/tools/tsql

#orm #database
November 4, 2026 at 12:00 AM
powerbitips.bsky.social
575 - Classify IPv6 prefixes from T-SQL. That's the demo example they picked, after showing PDFs and emails. The real story got buried under a networking use case nobody asked for.

youtu.be/oB9GQPX_7Fc

#fabric #tsql #powerbi #dataengineering
November 3, 2026 at 10:35 PM
albertomorillo.bsky.social
This article introduces pattern-based masking with examples and limitation. Last updated by Microsoft with disclosed AI involvement.

#databases #Azure #AzureSQL #AzureSQLDatabase #AzureSQLDB #DataProtection #DataSecurity #Cybersecurity #TSQL #SQL

learn.microsoft.com/en-us/azure/...
Regex-based dynamic data masking (preview) - Azure SQL Database
Use REGEXP_REPLACE in Azure SQL Database dynamic data masking to define pattern-driven masks for emails, phone numbers, and other structured string data.
learn.microsoft.com
October 26, 2026 at 2:42 AM
discover.holos.social.web.brid.gy
Alberto Morillo (@amorillo@mastodon.social)
This article introduces pattern-based masking with examples and limitation. Ite was last updated by Microsoft Learn with disclosed AI involvement in March 2026.#databases #Azure #AzureSQL #AzureSQLDatabase #AzureSQLDB #DatabaseSecurity #DataProtection #DataSecurity #Cybersecurity #TSQL #SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-regex?view=azuresql&wt.mc_id=DP-MVP-4015656
mastodon.social
October 26, 2026 at 2:52 AM
alvinashcraft.com
Modern Query Editor for Azure SQL Database is now generally available

buff.ly/XXVDAPx

#database #azuresql #azure #cloud #sqlserver #tsql #data
Modern Query Editor for Azure SQL Database is now generally available | Microsoft Community Hub
We're pleased to announce the general availability of Query Editor for Azure SQL Database. The updated experience brings a multi-tab query workspace, easier...
buff.ly
October 23, 2026 at 2:00 PM
4-randomletter.bsky.social
Tsql
4-letter word: Tsql
October 20, 2026 at 6:30 AM
euvd-bot.bsky.social
🚨 EUVD-2026-106884
📊 8.3/10
🏢 triggerdotdev

📝 Trigger.dev before 4.5.6 contains an SQL injection vulnerability in the TSQL query compiler, which concatenates window-function names into generat...

🔗 https://euvd.enisa.europa.eu/vulnerability/EUVD-2026-106884

#cybersecurity #infosec #cve #euvd
October 21, 2026 at 2:09 AM
proactiveitrec.bsky.social
We have partnered with a leading British brand in their search for a BI Engineer. This key role is responsible for the delivery and development of the organisation-wide BI infrastructure.

www.proactive.it/job/bi-engin...

#SQL #TSQL #Python #PySpark
October 14, 2026 at 7:29 AM
powerbitips.bsky.social
567 - Total revenue, written once, in DAX and T-SQL side by side in the same definition. Define the metric in one generic spot and every model and SQL database can use it.

youtu.be/caiTPz9yaVI

#dax #tsql #semanticmodel #microsoftfabric
October 12, 2026 at 10:17 AM
airbornegeek.com
Boy, do I hate sloppy TSQL.
October 4, 2026 at 4:40 PM
devartsoftware.bsky.social
🔁 What Is a Cursor in SQL? Syntax, Examples, and SQL Server Usage

Row-by-row processing, the 5-step lifecycle, and when a JOIN or CTE would just be faster.

📖 Read the guide: cutt.ly/Nykoj0DN

⚡ Try #dbForgeStudio for SQL Server: cutt.ly/hykoky6E

#SQLServer #TSQL
September 30, 2026 at 6:12 AM
alvinashcraft.com
MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more

buff.ly/emnLo7y

#sqlserver #vscode #azuresql #database #agents #tsql #data #mssql
MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more - Azure SQL Dev Corner
Explore the MSSQL extension for VS Code v1.46 release. Discover quick actions, guided workflows, and enhanced SQL formatting now available.
buff.ly
September 29, 2026 at 8:00 PM
albertomorillo.bsky.social
Resolve last-page insert PAGELATCH_EX contention in SQL Server. Article recently updated by Microsoft using AI.

#TSQL #transactsql #databases #SQLServer #troubleshooting #performance
learn.microsoft.com/en-us/troubl...
Resolve PAGELATCH_EX contention - SQL Server
This article describes how to resolve last-page insert PAGELATCH_EX contention in SQL Server.
learn.microsoft.com
September 18, 2026 at 4:22 AM
albertomorillo.bsky.social
Troubleshoot slow queries affected by query optimizer timeout. Article recently updated by Microsoft using AI.
#TSQL #transactsql #databases #SQLServer #troubleshooting #performance
learn.microsoft.com/en-us/troubl...
Troubleshoot slow queries due to query optimizer timeout - SQL Server
Introduces how Optimizer Timeout can affect query performance and how to optimize the performance.
learn.microsoft.com
September 11, 2026 at 5:33 AM
albertomorillo.bsky.social
Troubleshoot queries that seem to run endlessly in SQL Server.
#TSQL #transactsql #databases #SQLServer #troubleshooting #performance
learn.microsoft.com/en-us/troubl...
Troubleshoot Queries That Seem Never to End in SQL Server - SQL Server
Provides steps to help you identify and resolve issues in which a query runs for a long time in SQL Server.
learn.microsoft.com
September 11, 2026 at 6:21 AM
rezarad.bsky.social
Fabric Insider Ep. 18 with Jovan Popovic from Microsoft. 🎬

📺 youtu.be/mMRepnWAf1I

#MicrosoftFabric #FabricDataWarehouse #AIFunctions #TSQL #FabricInsider #SQLServer #DataEngineering #GenerativeAI #FabricAnalytics #BusinessIntelligence #SentimentAnalysis #DP800
September 3, 2026 at 3:58 PM
albertomorillo.bsky.social
This article helps troubleshoot query performance difference between database application and SSMS. The article was recently updated by Microsoft using Artificial Intelligence.
#TSQL #transactsql #databases #SQLServer #troubleshooting #performance

learn.microsoft.com/en-us/troubl...
Query is slower in database application than in SSMS - SQL Server
Troubleshoot the performance issue where a query is slower in a database application than in SSMS.
learn.microsoft.com
August 31, 2026 at 4:44 AM
albertomorillo.bsky.social
This article helps troubleshoot decreased query performance after upgrade from SQL Server 2012 or earlier to 2014 or later. The article was recently updated by Microsoft using AI.

#TSQL #transactsql #databases #SQLServer #troubleshooting #performance

learn.microsoft.com/en-us/troubl...
Decreased query performance after upgrade from SQL Server 2012 or earlier to 2014 or later - SQL Server
Provides troubleshooting steps for an issue where a query runs slower after upgrade from SQL Server 2012 or earlier versions to 2014 or later versions
learn.microsoft.com
August 31, 2026 at 12:14 AM
albertomorillo.bsky.social
Troubleshoot a query that shows a significant performance difference between two SQL Server servers

#TSQL #transactsql #databases
#SQLServer #troubleshooting #performance

learn.microsoft.com/en-us/troubl...
Troubleshoot a query that shows different performance between two servers - SQL Server
Provides troubleshooting steps for an issue where a query shows significantly different performance on two servers.
learn.microsoft.com
August 30, 2026 at 10:33 PM
datamechanic.pro
Newly Certified: Microsoft Certified: SQL AI Developer Associate

mrneilbryan.substack.com/p/newly-cert...

#SQLServer #TSQL #AI #MicrosoftCertified #SQLAIDeveloper #DataEngineering #Azure #VectorSearch #RAG #MachineLearning #DataPlatform #ContinuousLearning #Microsoft #ArtificialIntelligence
Newly Certified: Microsoft Certified: SQL AI Developer Associate
I’m pleased to share that I’ve passed the Microsoft Certified: SQL AI Developer Associate exam.
mrneilbryan.substack.com
August 30, 2026 at 6:49 AM
azureweekly.info
Launch: T-SQL Analyzer live analysis now in VS Code by Erik Ejlskov Jensen
https://erikej.github.io/sql/dacfx/vscode/2026/08/12/tsql-analyzer-vscode.html?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
Launch: T-SQL Analyzer live analysis now in VS Code by Erik Ejlskov Jensen
I'm excited to announce that the T-SQL Analyzer is now available for Visual Studio Code! You can now catch T-SQL mistakes as you type, directly in the VS Code editor — no build step required.
erikej.github.io
August 27, 2026 at 10:55 PM
kwman.bsky.social
youtube.com/watch?v=TSqL...
Podium AUDIO proves Trump shooting staged. Flag Lowered?!
YouTube video by Algeist Nydream
youtube.com
August 27, 2026 at 1:14 AM
albertomorillo.bsky.social
Troubleshoot slow-running queries in SQL Server. Article recently updated by Microsoft using AI.
#TSQL #transactsql #databases #SQLServer #troubleshooting
learn.microsoft.com/en-us/troubl...
Troubleshoot Slow-Running Queries in SQL Server - SQL Server
Learn how to diagnose and fix slow-running queries in SQL Server by determining whether a query is waiting on a bottleneck or running on the CPU.
learn.microsoft.com
August 27, 2026 at 5:20 AM
albertomorillo.bsky.social
Troubleshoot high-CPU-usage issues in SQL Server. Article recently updated by Microsoft using AI.
#TSQL #transactsql #databases #SQLServer
learn.microsoft.com/en-us/troubl...
Troubleshoot High CPU Usage Issues in SQL Server - SQL Server
Troubleshoot high CPU usage in SQL Server by identifying CPU-intensive queries and apply targeted fixes to restore performance.
learn.microsoft.com
August 27, 2026 at 3:58 AM