// T-SQL Tuesday 161
This months T-SQL Tuesday is number 161 and is hosted by Reitse Eskens (T, L, B) - you can read the original invitation here or by clicking the image below.
The topic of this month is about our most fun T-SQL script. It can be either a procedure or statement that I’ve written.
My fun T-SQL script A couple of years back I needed to find the latest used parameters from a reporting services - SSRS (yes, it is old!
[...]
// T SQL Tuesday 160
This months T-SQL Tuesday is number 160 and is hosted by Damien Jones (T, L, B) - you can read the original invitation here or by clicking the image below.
The topic of this month is really interesting as we are to discus our personal wishlist for the partnership between Microsoft and OpenAI. As I’m a SQL and Kusto guuy to the bone, this will also be my stepstone in this blogpost.
[...]
// T-SQL Tuesday 159
This months T-SQL Tuesday is number 159 and is hosted by Deepthi Goguri - you can read the original invitation here or by clicking the image below.
The topic of this month is two fold:
Favorite feature from SQL Server 2022 or SQL server in Azure What is my new year resolution and how to keep the discipline My favorite new feature in SQL server. This must be the new Optimized Locking feature released to Azure SQL Database.
[...]
// T-SQL Tuesday 158
This months T-SQL Tuesday is number 158 (wow, tempo fugit) and are hosted by Raul Gonzalez - you can read the original invitation here or by clicking the image below.
The topic of this month is if there exists a “worst practice” that actually has some use case in the real world.
Interesting topic indeed - and I’ll have the following to bring to the table.
Cursors for bulk loading data 😱 Now this should get some of you up from the chair.
[...]
// Call REST API Directly From SQL Server
When I attended the PASS Summit in Seattle in November 2022, we got a list of new releases from Microsoft. Among those releases we got the ability to call an external REST API directly from the SQL server in Azure.
The feature is, at this post is written, in public preview, so you might see or experience some minor problems.
The approach The SQL server in Azure (all versions in Azure - besides the one on a VM) has now gotten a new stored procedure named:
[...]
// Week 24: Database Maintenance
Wow, time goes by! Welcome back to the last and final installment of the SQL Server Performance Tuning series. Today I will talk in more details about database maintenance in SQL Server, especially about index maintenance operations, and how to perform database maintenance.
Index Maintenance Database maintenance is a very crucial part for your job as a DBA to make sure that you get the best possible performance out of your database.
[...]
// Week 23: TempDb
In today’s installment of the SQL Server Performance Tuning series we talk about TempDb - the public toilet of SQL Server, as I describe that special database in SQL Server. Everyone of us uses TempDb regularly. Some people use it directly, some people use it indirectly. Today I want to give you an overview of TempDb usage in SQL Server, and I will give you some best practices on how to configure TempDb for better performance.
[...]
// Week 22: Wait & I/O Latency Statistics
Hello and welcome back to the 22th week of the SQL Server Performance Tuning series. Last week I have talked about baselining in SQL Server, and today I will continue by talking about Wait Statistics and I/O Latency Statistics in SQL Server. When I perform SQL Server Health Checks, I always use these two metrics to get the big picture about the health of SQL Server.
Wait Statistics Every time you execute a query in SQL Server, the query will wait.
[...]
// Week 21: Performance Monitoring
Hello and welcome back to the last and final month of the SQL Server Performance Tuning series. Over the last 5 months we have covered various performance related topics about SQL Server, and we have covered specific performance tuning techniques and problems.
But what are your options, when you have a SQL Server in front of you that doesn’t perform as expected? To help you with that situation, we will cover performance monitoring techniques today, and next week we will have a more detailed look at the so-called Wait Statistics in SQL Server.
[...]
// Week 20: Deadlocking
Hello and welcome back to the SQL Server Performance Tuning series. Today we will complete the 5th month by talking about Deadlocking in SQL Server. A deadlock occurs when 2 queries are waiting for each other, and no query can continue its work anymore. In the first step I want to give you an overview how SQL Server handles deadlocks. And finally I will show you some specific deadlock types in SQL Server, and how you can avoid and resolve them.
[...]