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 » Tips   (RSS)
Showing page 2 of 2 (20 total posts)
  • PowerShell Version Two – Get Continuous Perf Counters

    In version 2.0 of PowerShell, you can now use a direct command-let (get-Counter) to get at the Performance Monitor counters. For instance, to show the current value of the Processor Percent Time, use this command:  Get-Counter '\Processor(*)\% Processor Time'    The interesting part of get-Counter is that you can add a ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 25, 2010
  • How to get Microsoft to speak at your event

    If you’re holding a special event, such as a SQL Saturday or a user group, one of the challenges is to get speakers for the event. Now, the best speakers come from the community – people who use the product day-in, day-out. They have a wealth of expertise, and many of them are really great presenters. But from time to time you might want to get a ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 22, 2010
  • Attaching a Database

    I had someone ask me yesterday how they could get to a database used by a product that they owned, but that was installed using SQL Server Express. They didn’t have access to the database, and they didn’t know the password for the service that started Express, so they wanted to know if they could look at the data. There are a few ways to do ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 26, 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
  • New Year’s Goals, not New Year’s Resolutions

    Many people use the New Year as a time when they promise themselves to behave differently. They plan to be healthier, eat less, workout more and so on. My family and I have for several years had a similar tradition. We find a restaurant that is open early on New Year’s day (no small feat) and sit down with a little leather-bound book I write in. ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 4, 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
  • Plans are useless. Planning is essential!

    I do lot of cooking, and I was taught to prepare everything ahead of time, and put everything in its place – something called “Mise en Place”. I chop everything and put it in little bowls, measure out the spices, lay out all of the pots and pans and so on, all before I turn on the oven or stove. It forces me to plan, and to be ready to put ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 2, 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