SQL Server Monitoring Week continues. Many clients struggle to monitor SQL Server health, so today I take a brief look at SQL Diagnostic Manager (SQLDM).
SQL Server Monitoring Week – Database Performance Analyzer
Day one of my SQL Server Monitoring Week: clients often ask which tool fits them best after a Health Check. Today I briefly look at Database Performance Analyzer.
Detect and Diagnose SQL Server Performance Issues with Spotlight Cloud
Apps run fast in testing and slow down once live. Spotlight Cloud helps detect and diagnose SQL Server performance issues with workload analysis and smart alarms.
How to Change Language for SSMS? – Interview Question of the Week #194
How do you change language for SSMS? A workshop attendee asked me and I had to research it, but the steps are simple and start in the Tools menu.
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
A client’s SSIS package failed: “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. I explain which metadata and the fix.
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
How do you Schedule a Job in SQL Server? First make sure SQL Server Agent is running, then follow these simple screens to add the job, its steps and a schedule.
SQL SERVER – 5 Tips to Optimize SQL Server Application Performance
I recently talked with Mark Wright, CTO of Nitrosphere, a company that optimizes SQL Server application performance. Let us talk about it.