We have here an easy, handy-dandy way to find out how much CPU is in use on your server. Of course you can find out by opening up task manager, or by running perfmon, but that’s not really the point. We want something quick and easy. We want something we could potentially use for monitoring, […]
Category: Admin
Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be a shame if, you know, they never ran. Where do we keep our job information? In MSDB tables: Your jobs are listed in dbo.sysjobs. Schedules are in dbo.sysschedules. The table dbo.sysjobschedules joins them together. (Remember, a […]
Hit Fast Forward: Converting and deploying DTS packages
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I used to convert about 40 SQL Server 2000 DTS packages to SSIS. Seriously, I just had to run the thing, and update a few data connections. YMMV, of course, but I was really happy not […]