Browse by Tags

All Tags » Maintenance   (RSS)
CU1 for SQL Server 2008 is now Available!
23 September 08 06:38 AM | Buck Woody | 1 Comments   
Many people wait for the “first” service pack of a product to work with it. Well, the CU#1 for SQL Server 2008 is now available. This is a new service model where we get out fixes far faster than a full Service Pack. You should read the article Read More...
A Friendly Reminder to Check Those Backups
30 July 08 09:05 AM | Buck Woody | 1 Comments   
As I rode home on the bus yestereday a young lady sitting next to me noticed me typing on my laptop, and asked me a question about, of all things, backups! She worked in a medical facility, and wondered why their backups took longer by the end of the Read More...
SQL Server 2008 Feature Pack RC0
02 July 08 09:22 AM | Buck Woody | 3 Comments   
The SQL Server 2008 Feature Pack for RC0 is now live - if you haven't downloaded this and played with it yet, shame on you! :) OK - just kidding - it's not like you don't have a day job. However, if you'll take a few moments and look this download over Read More...
SQL Injection Attacks
30 May 08 03:12 PM | Buck Woody | 5 Comments   
You might have read recently that there have been ongoing SQL injection attacks against vulnerable web applications occurring over the last few months. These attacks have received recurring attention in the press as they pop up in various geographies Read More...
SQL Server Management Studio Standard Reports – The Full List
17 April 08 06:42 AM | Buck Woody | 1 Comments   
I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information Read More...
SQL Server Management Studio Standard Reports – Top Jobs
14 April 08 09:51 AM | Buck Woody | 0 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu Read More...
SQL Server Management Studio Standard Reports – Job Steps Execution History
31 March 08 08:40 AM | Buck Woody | 0 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu Read More...
The Enterprise DBA
25 March 08 09:19 AM | Buck Woody | 1 Comments   
In a couple of other posts, I’ve covered some of the challenges and strategies for dealing with those challenges that DBAs face. I mentioned that in my experience, the answers depend on the “kind” of DBA you are. I've covered the “single-seat” DBA and Read More...
SQL Server Management Studio Standard Reports – Notification Services - General
24 March 08 10:05 AM | Buck Woody | 0 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that Read More...
SQL Server Management Studio Standard Reports – Number of Errors
20 March 08 08:59 AM | Buck Woody | 0 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that Read More...
SQL Server Management Studio Standard Reports – Tasks
17 March 08 08:58 AM | Buck Woody | 0 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that Read More...
Time-based Optimization
14 March 08 09:02 AM | Buck Woody | 0 Comments   
One of the primary jobs of both developers and DBAs is optimization, or its more common name, performance tuning. Lots of the management tools improvements for SQL Server 2008 are aimed at performance, such as the new activity Monitor. Using the tools Read More...
The Organizational DBA
13 March 08 08:17 AM | Buck Woody | 4 Comments   
I posted another entry about a question I received as to the most effective management processes are for a DBA, and in that post I mentioned that the answer was "it depends". There are a lot of ways to slice and dice the information, but I think a convenient Read More...
SQL Server Management Studio Standard Reports – Resource Locking Statistics by Logins
12 March 08 09:48 AM | Buck Woody | 1 Comments   
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the Security reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Logins node underneath the Security Read More...
The Small Shop DBA/Developer
11 March 08 08:55 AM | Buck Woody | 2 Comments   
I’ve been asked what the most effective management processes are, and of course the answer is (as always) “it depends”. It depends because the size of the shop often dictates how much time you have to devote to your systems, how big those systems are, Read More...
More Posts Next page »
Page view tracker