An introduction to the SQL Trace catalog views and functions used to view existing trace definitions targeted at DBAs and Developers. The article discusses T-SQL queries to view defined traces, query trace status and start/stop/delete traces.
How to import a trace file into a table using T-SQL and the Profiler tool, for subsequent ad-hoc analysis.
How to use SQL Jobs, scripts and SSIS to manage traces and trace data collection.
Level 8 of this stairway series looks at the automation of your tracing using Integration Services.
In this level you will see how to employ the Data Collector feature of SQL Server to automate management of SQL Traces among multiple servers.
What are PowerShell and SQL PowerShell and how do you use them? Level 1 of this Stairway will help you answer these questions, and start to show you why you might want to use this great tool.
Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.
This level will cover some of the Input/Output operations you can use with PowerShell.
This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.
Examines the proxy subsystem, which allows job steps to impersonate another user account in order to perform tasks as a user other than the SQL Server Agent service account. This is especially useful when you want jobs to run as lower privileged users of your SQL Server.
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers