You can grab the demo scripts here. Azure SQL Database Managed Instance I’ve now tuned the world of SQL Server instances on Windows and Linux. Why not tune the cloud as well? I have been speaking at ...

Joey on SQL Server Why Activity Monitor May Be Hurting Your SQL Server's Performance As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data.

Performance monitoring and tuning tools [!INCLUDE SQL Server] [!INCLUDE msCoName] [!INCLUDE ssNoVersion] provides a comprehensive set of tools for monitoring events in [!INCLUDE ssNoVersion] and for ...

While working with SQL Server databases, if you often find the database performance sluggish, it could be due to bad coding of procedures or incorrectly set database variables. Here's a tool that can ...

Enhance indexing The performance of your SQL server will be closely tied to indexing, and part of the tuning process will be establishing whether index fragmentation has occurred. A fragmented index ...

When SQL Server 2012 comes out, so, too, will SQL Server Data Tools (SSDT), code name "Juneau," which will provide full-fidelity database design and development experience that can work offline or on ...