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 » SQL Server » DBA   (RSS)
Showing page 3 of 6 (51 total posts)
  • It’s OK to take a Shortcut Sometimes

    I was working this weekend with a fairly simple Excel spreadsheet, and I had to decompose one cell in it out to three columns in a SQL Server table. There are tools within SQL Server Integration Services (SSIS) that should be able to do that, but I just couldn’t find my way around them properly. I’m not as familiar with SSIS as I would like to be ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 8, 2010
  • ROI and the DBA

    I love them three-letter acronyms! An “ROI” is a Return On Investment – it’s a basic financial calculation that places investments in a standard number so that they can be compared. If the number is positive, then it has a “good” return on investment, and if it’s negative, you probably shouldn’t make the investment. The basic form of the ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 4, 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
  • Lessons from Volunteering

    Saturday I volunteered at a work-day at our church. Our building is one of the first buildings built in this area of Washington, so it’s a beautiful old structure, which of course means there’s lots of maintenance. I’m fairly decent with tools, I’ve done some woodworking in my day, and I’ve even rebuilt a car or two. But working on a structure ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 23, 2010
  • Code that Writes Code - A Good Idea or Not?

    I’m a big fan of code that writes code – most of the time. For instance, whenever you use the “templates” feature in SQL Server Management Studio (SSMS) or the Maintenance Wizard, you’re using code that writes other code. There’s even a trick of writing Transact-SQL (T-SQL) code that in turn creates other code. But there is a class of code ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 16, 2010
  • How Does Microsoft Do IT?

    Microsoft is a big company – and of course we have a lot of IT infrastructure that we have to manage. It might surprise you to learn that we have an IT group, just like at your company. We have a networking team, a server hardware team, software teams, DBA’s, the whole bit. In fact, we have more Mac computers than just about anyone (other than ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 3, 2010
  • Data Design

    I give series of classes and presentations on Data Design. I say “data” design instead of “database” design because we should consider more than just the database. Data might actually be stored in non-relational stores, such as Excel or XML files, and it might also be located in remote data stores like “cloud” technologies.   Here are the ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 2, 2010
  • FILESTREAM: Storing Binary Objects in a database – or not

    Many shops need to store binary large objects (sometimes called BLOBS) in a database. There are really only two ways to do this: store in them in a table structure in the database itself using a binary data type, or store them in the operating system in a file folder somewhere and point to the file using a text field in a table. Both of these ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 28, 2010
  • 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 of the items I track is time. I track the ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 25, 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
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement