Browse by Tags

• Maintenance
• Performance
• SQL Server Agent

• Spooky: What do you connect to?

  I only recently discovered that SSMS will connect to different things. For instance, press the "New query" button. What were you connected to? The answer is the same server as your "current" server. But what is the current server? It is the server where Read More... Posted Friday, June 26, 2009 5:12 PM by TiborKaraszi | 2 Comments Filed under: Tools, SQL Server 2008

• sp_altermessage is back in business!

  Just a quick note that we again can modify whether system messages are to go to eventlog/errorlog again. I.e., we can change the is_event_logged column in sys.messages. This is very valuable in general and specifically is you want to define Agent alerts Read More... Posted Thursday, May 14, 2009 11:36 PM by TiborKaraszi | 2 Comments Filed under: Tools, Maintenance, SQL Server 2008, SQL Server Agent

• Missing F8 or ctrl-N in SSMS 2008?

  Short story: Turn on 2000 keyboard layout and then back to Standard layout. Long story: This topic has been discussed in both the MCT (MS Certified Trainer) as well as MVP groups. Also, see http://sqlblog.com/blogs/andy_leonard/archive/2008/08/08/sql-server-2008-management-studio-function-keys.aspx Read More... Posted Tuesday, August 26, 2008 10:22 AM by TiborKaraszi | 8 Comments Filed under: Tools, SQL Server 2008

• Make sure you play with data collector on a virtual machine

  I'm in a situation where I have configured the new data collector functionality for three instances. And there's no way to undo the config performed by the wizard! It cannot be undone by the wizard, and BOL doesn't have information on how to do this. Read More... Posted Monday, August 25, 2008 7:42 PM by TiborKaraszi | 0 Comments Filed under: Tools, Performance, SQL Server 2008