SQL Server 2016, which at the time of writing is in preview release CTP 2.1, has a great new feature called Live Query Statistics. In this article, Koen Verbeeck introduces the new feature which allows you to view a live execution plan of an active query, giving a fantastic opportunity for troubleshooting and debugging.
Putting together a portfolio allows you the chance to showcase what you're good at doing. Steve Jones thinks this might be a good thing for technical people.
The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers and profilers that developers seem to resent the idea that applications should be designed and developed so as to be measurable. Tony Davis looks at the issue.
Is a software deployment responsible for a plane crash? That's a scary thought.
Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.
MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.
This Friday Steve Jones looks at the setup for your software pipeline. He's wondering how complex it is with how many separated environments.
In this chapter, we will learn how to use some DMX functions in our mining models.
In this chapter, we will learn how to use some DMX functions in our mining models.
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Comments posted to this topic are about the item Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers