THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DBA » Tips   (RSS)
Showing page 2 of 2 (19 total posts)
  • Process Improvement and the Data Professional

    Don’t be afraid of that title – I’m not talking about Six Sigma or anything super-formal here. In many organizations, there are more folks in other IT roles than in the Data Professional area. In other words, there are more developers, system administrators and so on than there are the “DBA” role. That means we often have more to do than the ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 6, 2010
  • System Variables, Stored Procedures or Functions for Meta Data

    Whenever you want to know something about SQL Server’s configuration, whether that’s the Instance itself or a database, you have a few options. If you want to know “dynamic” data, such as how much memory or CPU is consumed or what a particular query is doing, you should be using the Dynamic Management Views (DMVs) that you can read about here: ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 11, 2010
  • 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 back all of those keys up periodically, and ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 1, 2010
  • Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure. On the other hand I have several systems I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 18, 2010
  • Plan and Prepare or Just Do It? How about Both!

    I'm kind of a type ''A'' person. OK, I'm a VERY type ''A'' person. I even cook by setting things up ahead of time. I'm definitely more in the ''Plan and Prepare'' camp than the ''Just Do It'' camp. But I do realize that there are times when you just can't stop and prepare. Sure, it would be great to know that server is going to melt down just ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 7, 2010
  • SQL Server Chargeback Strategies

    It seems the more things change the more they stay the same. One of the things I used to create on the mainframe system when I started years ago was a “charge-back” system.  It tracked the time and resources used by the employees so that we could charge their department money for the time they spent on the (very expensive) mainframe. When ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 29, 2009
  • SQL Server Best Practices: Protect CmdExec

    In SQL Server, there are times that you need to do things in the operating system, and to allow that there is a feature called CmdExec. This is not always a good thing –whenever you leave the confines of SQL Server and go out to the operating system, you can cause issues, not the least of which are security-related. This best practice is ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 3, 2009
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
  • Changing the Primary Key After You Have Data

    Yesterday I blogged about changing a Primary Key (PK) during the design phase, and before you have data in the database. Even then, it’s not trivial to change the data type or column(s) that make(s) up the PK. When you have data in that Primary Key and/or you have Foreign Keys (FK) that point to a PK field, this becomes a much more involved ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 24, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement