Monitoring your SQL Server Agent jobs is important to ensuring that all of the automation you have created on your server is working correctly. Thomas LaRock brings us another article on Operations Manager and its integration with SQL Server.
2008-09-08
7,568 reads
Longtime expert DBA Thomas Laorck brings us a short article about how he uses Operations Manager to watch the SQL Servers he is responsible for and ignore others.
2008-07-23
5,878 reads
Monitoring your servers for issues and alerts is something every DBA should be doing on a regular basis. However even with a small number of servers, a DBA can easily be overwhelmed if some level of automation is not implemented. Thomas LaRock brings us a method of scanning your error logs automatically and notifying the DBA of problems.
2007-12-12 (first published: 2006-12-27)
8,590 reads
It is an interesting question and one I hope every DBA can answer positively. New author Thomas LaRock brings us his method for ensuring that the backups have occurred and the files are still on disk.
2006-03-21
8,011 reads
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
Comments posted to this topic are about the item Why Would You Do That?
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers