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 5 of 5 (50 total posts)
  • The Dark Sides of Consolidation

    Consolidation, as it applies to databases, is simply putting more databases or SQL Server Instances on less hardware. This is a good thing, normally, because it allows you to save on hardware costs and use what you have at it’s highest capacity. It also saves on energy costs, floor and rack space, and in some cases even licensing and ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 10, 2009
  • SQL Server Best Practices: Use Roles When You Can

    SQL Server has two major security vectors: “Principals”, which are primarily users and roles (groups), and “Securables”, which are primarily objects on the server or in the database, like tables or views. Many applications use Logins for their users, and then tie those Instance Logins to Database Users. The Database Users are then given rights and ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 7, 2009
  • After the Upgrade, it runs differently…

    I got a question yesterday in the mail that I thought I would just answer here in a broad context. While I can’t troubleshoot or do performance tuning from a distance, there are some interesting concepts and suggestions this e-mail brings up: “I have recently seen a change from SQL Server from 2005 to 2008 in where it handles CASE statements ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 1, 2009
  • Aren’t DBA’s Just System Admins for Databases?

    Last week I ran into an argument I’ve had since I left the mainframe space decades ago. A developer told me “DBA’s don’t design databases.” The inference was that DBA’s (i.e., Database Administrators) only worry about hardware, security, OS, database backups, things like that. He seemed amazed that a DBA would ever do “data” work. It may be the ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 30, 2009
  • The Magical World of SQL Server Licensing

    Licensing. Sometimes it feels like to you need a specialized degree, a black robe and a secret handshake to really understand it – but it’s not quite that bad. There are several licensing “models”, from just buying SQL Server off the shelf to Software Assurance, or SA, where you just install to your heart’s content and then “true up” or pay at ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 26, 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
  • Who Thinks Like Database Professionals?

    Introduction I was talking to my team this morning and we were wondering about some design decisions. One of the things that came out of the discussion was: Database professionals think differently. Differently? How? A little story: Before I was a database person I did web development. That's a little misleading because I wrote very little ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 31, 2009
  • Things I Know Now

    Introduction I was tagged by Joe Webb for this question circulating through the inter-tubes. Joe and I shared a cab to the airport after the PASS Summit 2008. If you've never had the opportunity to share a cab with Joe, I highly recommend it. He's one of those people. You know the type - they talk to you for a few minutes and ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 17, 2009
  • A Follow-up to Database Professionals: An Enterprise Requirement

    Eric Wise drew some heat from the developer community at CodeBetter.com with this post about the need for a DBA during development (see my post on the subject here). I think Eric makes a couple good points, one explicit, one implied: 1. (Explicit) A DBA - or Database Developer, more accurately (and there is a difference) - adds ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 13, 2007
Privacy Statement