Browse by Tags

My head hurts from hitting it against a wall–SSMS log viewer

Every time I go to a client to do a review I find I’m looking in the event log trying to find information. Every time I feel like I’m hitting my head against a wall as the process is awful and painful. Given SQL is a relational database production the error log makes its best to hide that fact. You can...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 31 2011
Agent XPs disabled

When you expand object explorer and see “Agent XPs Disabled” don’t worry. This happens when SQL Agent is stopped. I guess the idea is to reduce the surface area if SQL Agent isn’t running. You don’t have to manually enable them. They will be enabled automatically when SQL Agent is started. This was prompted...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 31 2011
Intellisense: the ghost in the machine

Intellisense really does have a mind of its own. I installed SQL 2008 R2 on my dev machine side by side with my existing 2005 installation and Intellisense worked fine. Granted it has some really annoying habits. (Dude, I typed a valid keyword followed by a space - why did you change it to something...

Posted to DavidWimbush (Weblog) by DavidWimbush on Fri, Nov 12 2010
Controlling what appears on your tabs

You can control what appears on your tabs from SQL 2008 onwards. Its still not ideal, IMHO you need to have multi line tabs to show server, database, filename etc. Anyway to control what appears go to Tools | Options and then select the Tec Editor node and the Editor Tab and Status Bar sub node This...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jul 19 2010
SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

Profiler, Perfmon, DMVs & scripts are legendary tools for a DBA to monitor the SQL arena. In line with these tools SQL Server 2008 throws a powerful stream with policy based management (PBM) framework & management data warehouse (MDW) methods, which is a relational database that contains the...

Posted to SQL Server Knowledge Sharing Network (Weblog) by ssqa.net on Mon, Apr 5 2010
A better way to arrange your query windows

The developers of Management Studio and, before that, Query Analyzer have made a bit of a habit of building killer features and then hiding them in the small print of Books Online. Now you may already know that SQL 2000 introduced a new way to arrange your query and result windows, but I only just found...

Posted to DavidWimbush (Weblog) by DavidWimbush on Sat, Nov 28 2009
Restoring an Expressmaint backup using SQL Server Management Studio Express

This post describes step by step how to restore a full database backup taken with Expressmaint (or by any other means) using SQL 2005 Management Studio Express (SSMS). The same steps apply to SQL 2008. To download this free tool for SQL Server Express Edition use the links below Download SQL 2005 Management...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on Wed, Oct 21 2009
First thing to do after installing SQL Server Management Studio 2008

One of the strangest UI design decisions in Management Studio for SQL 2008 is that by default the Start Debugging button is right next to the Execute button as shown below I myself have hit it by accident more times than I'd like to admit and I have seen many a demo (by MS staff as well) run into...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on Wed, Sep 10 2008
SQL Server Integration Services and Clustering - confguration gotcha to ensure SSIS works with failover of cluster!

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Read more from here.

Posted to SQL Server Knowledge Sharing Network (Weblog) by ssqa.net on Mon, Mar 17 2008
Data Warehouse Scalability Features in SQL Server 2008

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within my work place, I have browsing through the Technet...

Posted to SQL Server Knowledge Sharing Network (Weblog) by ssqa.net on Fri, Mar 7 2008

Page 1 of 2 (20 items) 1 2 Next >