Learn more about SQL Server tools

   
   









































Connect with MSSQLTips




MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page


SQL Server DBA Tips and Tricks


Latest SQL Server Tips
Find SQL Server Agent Jobs That Exist on One Instance and Not on Another Instance
We have multiple SQL Servers across development, QA and production and we need to quickly determine what SQL Server Agent jobs exist in one environment, but not the other. This will help us determine if these jobs are necessary, currently in development, or being tested in development before landing in production. In this tip we look at how to use PowerShell to compare SQL Agent jobs across different SQL Server instances to find jobs that exist
What's Trending?
Find SQL Server Agent Jobs That Exist on One Instance and Not on Another Instance
We have multiple SQL Servers across development, QA and production and we need to quickly determine what SQL Server Agent jobs exist in one environment, but not the other. This will help us determine if these jobs are necessary, currently in development, or being tested in development before landing in production. In this tip we look at how to use PowerShell to compare SQL Agent jobs across different SQL Server instances to find jobs that exist
SQL Server Tutorials
SQL Server Webcasts
Free SQL Server tools to manage, optimize and monitor your environment
Managing a SQL Server environment can be quite challenging. There are several aspects and data sets to monitor, configure, tune, administer and optimize.

Microsoft provides tools that are pre-built into SQL Server such as DMVs, Activity Monitor, Import Export Wizard, Profiler and Database Tuning Advisor. Gaining a good understanding of your SQL Server environment requires an efficient set of tools, and sometimes these donít meet y
All Categories

 
Sponsor Information