mssqldbatechsupport

Hello Everyone, Last weekend, I was watching a movie and came across the FLAMES logic. That got me thinking — why not build the same using T-SQL? It’s a fun reminder that even simple mini-projects can sharpen logical thinking, improve problem-solving skills, and help you get more creative with T-SQL. https://lnkd.in/gzDEr7CW #SQLServer #TSQL #DatabaseAdministration #DBA #Programming #CodingChallenge #SQLDeveloper #TechLearning #MicrosoftSQLServer #ProblemSolving

Make SQL Performance Tuning Easier in SSMS 22.6.0 With Statistics Parser If you’ve worked on SQL Server performance tuning, you know how difficult it can be to read raw IO and execution time output from query analysis. Recently explored the StatisticsParser Extension for SSMS, and it makes performance troubleshooting much simpler. 1.Converts performance output into an easy-to-read tabular format 2.Makes identifying performance bottlenecks easier 3.Saves time for DBAs and developers Sometimes, small tools make a huge difference in daily productivity. Have you used any SSMS extensions that genuinely improved your workflow? https://lnkd.in/g4JYti74 #SQLServer #SSMS #PerformanceTuning #SQLDBA #QueryOptimization #DatabaseAdministration #TSQL #DBA #MicrosoftSQLServer #StatisticsParser

Hello Everyone, it's nice to see in ms SQL server 2025 express edition database size limit has been increased to 50 GB from 10 GB in older versions

Hi Everyone, As someone who has spent years in the database world, I genuinely enjoy seeing communities come together to learn, share, and grow. Whether you work with SQL Server, PostgreSQL, Azure data platforms, or are simply curious about open-source databases, these kinds of gatherings always bring valuable perspectives. It's useful for ms SQL DBAs to have postgress in your resume and also this kind of meetups helps us to increase our network. If you're in Bengaluru and interested, worth checking out. https://lnkd.in/dECbX7_7 #Database #PostgreSQL #DBA #Learning #TechCommunity #OpenSource #SQLServer #Cloud #Networking

Hi Everyone, There is a webinar from Geopits. Below is the info for the same.utilize this opportunity. Microsoft Azure for Data Engineers by Apoorva Sharma, where we introduce Azure fundamentals, cloud concepts, and the essential skills needed to begin your journey in cloud and data engineering. This session is ideal for beginners looking to get started with Azure and data engineering, so join us. Date: 22-5-2026 Time: 5:00 PM – 6:00 PM Registration Link: https://lnkd.in/d3Hf2R6D

Hi @Everyone, I have a habit of building home labs for every MS SQL Server version that gets released. While working on a demo video, I noticed that the new version of VMware VMware Workstation Pro is now free, and no serial key is required anymore. #MSSQLServer #SQLServer #DBA #SQLDBA #HomeLab #VMware #VMwareWorkstation #Virtualization #DatabaseAdministration #TechLearning #LabSetup #SQLServerLearning #ITInfrastructure #DemoVideo #LearningByDoing

Hi Everyone, We faced an interesting scenario related to Row-Level Security (RLS) in Microsoft Fabric. The user was able to retrieve data correctly when querying through SSMS, because the RLS policies were applied based on the user’s region access. However, when the same data was accessed through ADF, the user was receiving blank results. This happened because the connection from ADF was configured using a Service Principal (SPN) Initially, we granted the SPN with Admin access and also added it as a user access Rls table, but the issue still persisted. During a troubleshooting call, we ran the following query to identify the actual identity hitting the SQL endpoint: SELECT CURRENTUSER 124ffjfdhj@gjkmvtjkmbgg later we identify the first was spn id and second part was tennet id <SPN_ID>@<TENANT_ID> After adding this exact identity combination into the UserAccess table used by the RLS logic, the issue was resolved and the user was able to retrieve the data successfully through ADF. Root Cause: ADF was authenticating through the Service Principal, and the SPN identity was not mapped in the RLS access table, causing the query to return blank results. Resolution: Added the SPN_ID@TENANT_ID identity into the RLS access table.

Hi Everyone, In recent days the below free monitoring tool is gaining much popularity for Ms SQL servers monitoring. https://lnkd.in/g4eubc7k

Hi Everyone, In the below video i have explained with demos Configuring copilot in ssms 21 Configuring github copilot in ssms 22 SSMS 22 New features https://lnkd.in/g4cWZXDT

Hi Everyone, Thanks for showing interest in our MS SQL DBA Trainings Here is the day 02 highlights ===================== Evolution of storage Systems Evolution of storage Systems from MS Fathers of DBMS and RDBMS Differences between DBMS vs RDBMS EF codd Rules Various Data Models Editions of MS SQL Server and  Differences between Editions Microsoft SQL Server licenses Download and install MS SQL Server 2025 https://lnkd.in/gxSx2MSj