This is a link to previous related posts that you may find interesting https://sqlserverutilities.com/maximize-sql-trace/ https://sqlserverutilities.com/use-sql-trace-to-capture-database-exceptions/ If we want to capture all the commands being sent
In this post I will discuss and present some practical use cases for SQL Trace also known as “Server Side Trace”. Before we move forward
For the previous post discussing SQL Trace see this post For the TraceExceptions stored procedure presented in this post see my Traces project at Github.
SQL Server allows marking any stored procedure as a “startup” procedure which means it will get executed upon a service restart. A “startup” procedure has
Working with partitions at different environments has led me to think that a generic unified code to manage partitions can be very useful and practical.
Among the many tasks that are under the DBA’s responsibilities is keeping the database performing well and in good health. And when mentioning performance the
