In a previous tip, we did an overview of Extended Events and the different components that make up Extended Events. Now that you know what Extended Events offers, how do you use it to help troubleshoot performance issues? In this tip we take a step by step look at how to implement and use Extended Events.
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
How to set the default locations for backups, data files, and log files in SQL Server.
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
A free day of training in Reston, VA, just outside Washington DC. Come join Andy Leonard, Allen White and others for some SQL Server learning.
SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common way that things can go wrong with statistics, and how to put matters right.
Could we ever have computers automating our cars and handling the driving for us? Steve Jones doesn't think so, despite some ongoing projects.
This article shows how you can dynamically split data based on transaction type to its own destination table using Integration Services.
Tim Mitchell is the SQLServerCentral correspondent at the 2010 PASS Summit.
In this tip we look at Extended Events for SQL Server 2008 and how they are different from earlier tracing and troubleshooting methods.
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers