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 ...

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...

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 ...

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 ...

Last Thursday, Greg Nerpouni gave me a briefing about and demo of Embarcadero Technologies’ three new and enhanced performance optimization tools for Java and SQL applications: J Optimizer 2009 for ...

Using SQL Server Agent in AzureSQL Managed Instance, you can create and schedule jobs that could be periodically executed against one or many databases. These SQL Agent jobs run Transact-SQL (T-SQL) ...