#tSQL

Ran a query in SSMS yesterday and didn't save it? If it's still in the plan cache, you can often get it back. Swap Customers for a word you remember: Limits: only what's still cached, and it needs VIEW SERVER STATE. #SQLServer #TSQL

Book Review: Expert T-SQL Window Functions in SQL Server | @CloudExpo #API #Cloud #TSQL #SQLServer #cloud

Would you pass my job interview? A quick #TSQL challenge for you. * Review the following code * DECLARE @t TABLE (Id INT); BEGIN TRAN INSERT INTO @t VALUES (1), (2); ROLLBACK SELECT Id FROM @t; Q: How many rows will be returned? :) @SQLServer @AzureSQL

🚫 Tired of running into T-SQL anti-patterns? ✅ Meet your new favorite (and free) tool: the T-SQL Analysis Dotnet Tool! @ErikEJ, the author of the tool, wrote a great introductory post to get you started: #AzureSQL #SQLServer #TSQL

This morning working on upgrading a solution for working with dates from a SQL-Server database for teaching tomorrow. In the screenshot below, Calendar table is awesome. GitHub repository link to follow once finished. #csharp #tsql #sqlserver #net8 #visualstudio

💡Looking for easy-to-understand SQL Server interview questions & the latest best practices? Subscribe to our channel:- YouTube-> @MadeSimpleMSSQL Visit-> #TSQL #TransactSQL #SQLQueries #DBA #SQL #diy #madesimplemssql #sql #data #uk #usa #goon #LUNAR

Build a strong T-SQL foundation with this playlist by learning how to create a database for real-world apps: #AzureSQL #TSQL

Today, I built one-page, cheat sheet PDF version of the comparison table between #ADFDF activities, #SSIS components and #TSQL scripts. Enjoy!

#AzureSQL and @SQLServer got a bunch of updates to #TSQL. 🚀 Generate a list of numbers with GENERATE_SERIES; have an improved WINDOW function support; use JSON_OBJECT and JSON_ARRAY to create JSON and more! Test drive 🛵 everything using @SQLDBA demos!

Another one hot off the press - revamped #TSQL content! If you're ready to dip your toe into the #SQL pool (😆), this new learning path is for you! #data #Analytics #AlwaysLearning @MicrosoftLearn

Blog post: Presenting T-SQL Analyzer CLI - identify anti-patterns in SQL Server scripts with 140+ rules - T-SQL Analyzer is a free, open-source new command line tool. #dotnet #sqlserver #tsql

💡Looking for easy-to-understand SQL Server interview questions & the latest best practices? Subscribe to our channel:- YouTube-> @MadeSimpleMSSQL Visit at madesimplemssql com #TSQL #TransactSQL #SQLQueries #DBA #SQL #diy #madesimplemssql #sql #data #ukreels #usa #usareel

Dear #ITpros, let's sit by the fire and talk #TSQL theory. You'll find its beauty uncanny.

💡Looking for easy-to-understand SQL Server interview questions & the latest best practices? Subscribe to our channel:- YouTube-> @MadeSimpleMSSQL Visit at #TSQL #TransactSQL #SQLQueries #DBA #SQL #diy #madesimplemssql #sql #data #ukreels #usa

Calling the #PowerBI REST API from #TSQL in #AzureSQL DB

controversial hot take🔥🔥🔥🔥🔥 #python runtime, should be the default in #Microsoftfabric notebook, especially now that we have #TSQL support

Dopdolu bir içerikle TSQL ile veri tabanı programlamayı ve TSQL’in yeteneklerini uçtan uca öğrenmeye hazır mısın?😎 🔗 @omer_colakoglu #tsql #veritabanı

#SqlServer tools may add a #tsql formatter in @code - would you be willing to help us improve a basic formatter and make it great? #mssql

[Video] Query Tuning - Improvising T-SQL Code for better performance. If you learned something useful, do share/RT. #SQLServer #AzureSQL #TSQL #MVPBuzz @SQLMaestros @SQLServerGeeks @thedatageeks @DataAISummit @SQLServer @AzureSQL #SQL #developers

Prep for #Microsoft certification Exam 70-461 on #SQLServer & #Tsql w/ on-demand labs.