Mathew Phan
Follow /19 Jul 2017 at 11:37pm / Toad for SQL Server Blog

Running Scripts Across Multiple SQL Server Instances Using Toad Group Execute

Hi follow Toadies! As a SQL Server administrator you're likely managing dozens if not hundreds of databases. It's extremely time consuming to run a script on each and every one of those databases and then check the results. To make things even...
134 1 /
Michael.Micalizzi

Toad for SQL Server? Who Needs It?

That’s how a lot of my conversations begin when I talk to people about Toad for SQL Server. Most database pros understand why we have Toad solutions for databases like Oracle, DB2 and SAP. However, when it comes to SQL Server, Microsoft has a good...
1310 3 /
Gita Sharifi

What is new in Spotlight on SQL Server Enterprise version 11.6?

Spotlight on SQL Server Enterprise 11.6 is here! So what’s new? Spotlight introduces Federation architecture A Spotlight Client can now monitor connections from multiple Spotlight Diagnostic Servers in a federation. Spotlight Clients in...
838 0 /
kevinstern

SQL Tuning - Let SQL Optimizer Do The Work For You

The SQL Tuning Problem If you ask most DBA's what their #1 pain point is the likely response would be database performance issues. The quickest and least expensive way to solve database performance issues is to try and tune the database workload...
1304 0 /
Richard To

Test Running a Tuned SQL is Not An Easy Job

In SQL Optimizer for SQL Server, we have built a very sophisticated test run facility for users to find the best SQL alternative from all generated SQL alternatives to solve the user’s specific problem. But I have found that many users are just...
1767 0 /
Jason Hall

Integrating Spotlight on SQL Server Enterprise with Your Enterprise Monitoring Tool

I very frequently come across DBA's that that are either overwhelmed with the complexity of their organizations enterprise monitoring platform, or underwhelmed with its out of the box monitoring and diagnostic capabilities. These DBA's typically...
2406 0 /
Carlos Jimenez

Monitoring Your Server at a Glance – A Coffee Shop Conversation by Pinal Dave

A few days ago I was visiting a large Database Shop and I happened to meet quite a few DBAs there. After my session was over we all went to the company’s cafe for a quick coffee. While having a coffee in the relaxed environment, I shared details...
1257 0 /
Carlos Jimenez

10 Common T-SQL Mistakes - Live Webcast on 2/6/14

Webcast Registration: https://software.dell.com/event/10-ways-to-abuse-tsql-859618 Date: Feb. 6, 2014 Time: 12:00 PM -1:00 PM EST Join us as Tracy McKibben shows us how to discover simple, easy-to-implement ways to avoid common performance mistakes...
1098 0 /
Carlos Jimenez

Customized Alerting with Spotlight on SQL Server

Recently MSSQLTips Greg Robidoux wrote an editorial on Spotlight. Here is some of what he said. Problem Managing SQL Server requires many tasks to be performed by DBAs. These include making sure databases are backed up, performance is acceptable...
884 0 /
Jason Hall

Connecting to a Clustered SQL Server Instance in Spotlight on SQL Server Enterprise

Spotlight on SQL Server Enterprise provides very powerful capabilities for monitoring, and checking up on the health of clustered SQL Server instances. The following post walks you through how to configure Spotlight to connect to a SQL Server instance...
5238 0 /