Browse by Tags

Tagged Content List
  • Blog Post: Backup those keys, citizen

    Periodically I back up the keys within my servers and databases, and when I do, I blog a reminder here. This should be part of your standard backup rotation – the keys should be backed up often enough to have at hand and again when they change. The first key you need to back up is the Service Master...
  • Blog Post: Backup Meta-Data

    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and modified it to this...
  • Blog Post: Have you backed up your keys lately?

    Did you know that you already have a Server Master Key (SMK) generated for your system? That’s right – while a Database Master Key (DMK) is generated when you encrypt a certificate or Asymmetric Key with code, the Server Master Key is generated automatically when you start the Instance. So you should...
  • Blog Post: The SQL Server Health Check

    My friend Brent Ozar, who is a top-notch SQL Server Professional, mentioned on his blog ( http://www.brentozar.com/archive/2007/04/sql-server-health-check/comment-page-1/#comment-17520 ) that he brought in Microsoft Support to do a “Health Check”. There were some questions about what this actually entails...
  • Blog Post: Tracking SQL Server Time

    In the past few blog posts I’ve showed you how to use several methods to track things in SQL Server. You can use the “tags” to the right of this post here at this site to list things like PowerShell, Performance Tuning and so on. Now that you’re armed with these tools, what should you track? Well, one...
  • Blog Post: Listing the Central Management Servers Programmatically

    I don't normally advocate hitting the system tables in any database with direct queries, preferring instead to use views or functions that the vendor provides. But so far I haven't been able to find the view or function that would return the list of servers in the Central Management Servers group on...
  • Blog Post: Security Patches and the Conficker Worm

    Well, the media has done their usual stellar job on computer technology subjects, so after this weekend you may have gotten some questions about the Conficker worm. Here's a few pointers to hand out to the relatives and associates: Microsoft released an out of band security bulletin last October that...
  • Blog Post: Check that database before you restore it...

    I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as a test. Then things started going awry... Then this...
  • Blog Post: Versioning the Database

    If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire DB again and version that as well. That allows...
  • Blog Post: Have You Backed Up Your Database Master Key?

    If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here's the short version of the command: BACKUP MASTER KEY TO FILE = '<complete path and filename>...
  • Blog Post: SQL Server 2005 Service Pack Three is Available

    Load this after you thoroughly read the release notes - no, seriously, take a little time and do that. And as always, test, test, test! SP3 (Std, Dev, Ent) SP3 Express SP3 Express Advanced SP3 express Toolkit SQL 2005 Feature Pack Refresh December 2008 SQL 2005 BOL Refresh SQL 2005...
  • Blog Post: The Great American Shakeout

    Yesterday here in the U.S. the state of California had a "Shakeout", which was a practice for what to do in case of an earthquake. Although not everyone was involved, many government agencies were, and some companies also joined in. Japan also has drills like this as well. Sure, it's a bit...
  • Blog Post: CU1 for SQL Server 2008 is now Available!

    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 to see if you face any of these issues, and...
  • Blog Post: A Friendly Reminder to Check Those Backups

    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 week than the beginning. You can probably guess the...
  • Blog Post: SQL Server 2008 Feature Pack RC0

    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 and find out how it can help you, you might find...
  • Blog Post: SQL Injection Attacks

    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 around the world. These attacks do not leverage any...
  • Blog Post: SQL Server Management Studio Standard Reports – The Full List

    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 into use in your organization. A lot of work went...
  • Blog Post: SQL Server Management Studio Standard Reports – Top Jobs

    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 that appears, click the Standard Reports , and...
  • Blog Post: SQL Server Management Studio Standard Reports – Job Steps Execution History

    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 that appears, click the Standard Reports , and...
  • Blog Post: The Enterprise DBA

    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 the Organization DBAs and today I’ll talk a little...
  • Blog Post: SQL Server Management Studio Standard Reports – Notification Services - General

    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 appears, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports – Number of Errors

    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 appears, click the Standard Reports , and then select...
  • Blog Post: SQL Server Management Studio Standard Reports – Tasks

    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 appears, click the Standard Reports , and then select...
  • Blog Post: Time-based Optimization

    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 such as Management Studio, Profiler, Tuning...
  • Blog Post: The Organizational DBA

    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 one is one the size of your organization....
Page 1 of 3 (75 items) 123