SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

The Extended Events (XEvents) architecture enables users to collect as much or as little data as is necessary to monitor, identify, or troubleshoot performance in SQL Server, Azure SQL Database, Azure ...

Explore server-side performance optimization with profiling, slow query analysis, caching and concurrency fixes for faster ...

PASADENA, USA: DiscountASP.NET, leader in Windows hosting, announces enhancing their SQL Server hosting with the launch of SQL Server Profiling as a service. SQL Profiler is a powerful tool that ...

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...

SQL Server 2019 (15.x) builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud environments, and operating ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

The much-used Microsoft SQL Profiler is a tool headed toward obsolescence. What options are available once the tool is deprecated? We examine SQL Server Extended Events as a possibility. The ...

Power BI experts discuss ways to preserve data types with queries, optimize CPU usage, and connect with Power BI Premium User with SQL Profiler. Chris Webb built off a recent blog topic about enabling ...