#Tsql
💡Looking for easy-to-understand SQL Server interview questions & latest updates?

Subscribe to our channel: @MadeSimpleMSSQL

Visit at madesimplemssql.com

#TSQL #TransactSQL #SQLQueries #DBA #SQL #diy #madesimplemssql #sql #data #ukreels #usa #usareels #usagirl #eu #uk
November 17, 2026 at 8:28 PM
📢 Campagne T-SQL cible des serveurs MS SQL exposés pour déployer un miner XMR et Gh0st RAT

FortiGuard Labs (Fortinet), publié le 12 novembre 2026. La campagne a été découverte début octobre 2026 et cible des instances Microsoft SQL…

🟢 vérification factuelle haute
#Gh0stRAT #TSQL #Cyberveille
Campagne T-SQL cible des serveurs MS SQL exposés pour déployer un miner XMR et Gh0st RAT
FortiGuard Labs (Fortinet), publié le 12 novembre 2026. La campagne a été découverte début octobre 2026 et cible des instances Microsoft SQL Server accessibles sur Internet via des credentials faibles. La chaîne d'attaque complète est la suivante : 1. dllhost.exe (binaire Go, packé UPX) récupère une plage IP cible via hxxp://site.vietnam852[.]com:88/ip.php 2.
cyberveille.ch
November 17, 2026 at 1:30 AM
Meistere die String-Sortierung in T-SQL! 📚Daten sind mächtig, wenn man weiß, wie man sie sortiert. ✨Lerne heute, wie es geht und optimiere deine Abfragen! 👇 https://www.datenbanken-verstehen.de/blog/sql-tsql-plsql/string-mit-t-sql-sortieren #SQL #Tsql #Datenbanken
November 11, 2026 at 10:00 AM
Jeff Iannucci's T-SQL Tuesday #204 asks: are blogs still relevant for people working with databases? Here's my take.

https://www.gethynellis.com/2026/11/are-blogs-still-relevant-tsql-tuesday-204/
Are Blogs Still Relevant? T-SQL Tuesday #204 - Gethyn Ellis
Are blogs still relevant for data professionals in 2026? A ten minute phone call in 2008 and a new client last week say yes. My T-SQL Tuesday #204 answer.
www.gethynellis.com
November 10, 2026 at 7:45 AM
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
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
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
🚨 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
Tsql
October 20, 2026 at 6:30 AM
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
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
Boy, do I hate sloppy TSQL.
October 4, 2026 at 4:40 PM
🔁 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
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
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
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
September 3, 2026 at 3:58 PM
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
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
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