SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2009

Saying Goodbye To 2009

I'll close out 2009 with an update on the goals I set at the beginning of this year and things that I've accomplished. Call it a bit of shameless self promotion, but this is my blog after all. :-)

  1. Learn…
    • Powershell. Although I dropped using the command prompt in favor…

Read more

1 comments, 1,371 reads

Posted in Kendal Van Dyke on 31 December 2009

My Biggest Weakness

I took some time off in December and I'm finally getting around to catching up on RSS feeds. Turns out I’ve been tagged by Ken Simmons to contribute to another chain post to answer the classic interview question "What is your biggest weakness?" I've been told in the past that… Read more

0 comments, 1,491 reads

Posted in Kendal Van Dyke on 31 December 2009

Stored Procedures to Store and Get Database Users with All Permissions

Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the Generate Scripts wizard to script all logins and permissions. This approach can take several minutes and as I recently learned does not script database level permissions.

Bothered by… Read more

0 comments, 1,600 reads

Posted in Adventures in SQL on 31 December 2009

[OT] Happy New Year

Well, it's been an interesting year. I got to teach four different brand new SQL Server courses, and teach classes in four different countries on two continents. Two books were published with chapters I wrote. Microsoft published a whitepaper I wrote....(read more)

Read more

0 comments, 1,320 reads

Posted in Allen White on 31 December 2009

Got a slow holiday seaons? Why not spend it learning?

Traditionally, the time between Christmas and New Years is a bit slow.  Many people take time off from work and, for those of us still working, it’s a good time to catch up on all of those low priority projects that have been on the back burner for the last… Read more

0 comments, 1,490 reads

Posted in Kevin E. Kline on 31 December 2009

Final Recap – 2009 Goals

Well, I set 7 professional goals for 2009 and I did okay in meeting them, but I was not successful in all and, really, that is only because I did not put in the time to get them all done.  So let’s go through them and see how I did: Read more

1 comments, 1,365 reads

Posted in Wise Man or Wise Guy on 31 December 2009

Goals for 2010

Last year I wrote about my goals for 2009. Yesterday I looked over them and evaluated my performance. I think it was pretty good, not not perfect. However setting goals that you easily reach every year is probably not the best way to do things. I feel like I’m cheating… Read more

4 comments, 1,872 reads

Posted in The Voice of the DBA on 31 December 2009

Running a Small User Group - Remember, It's Not Exclusively Yours

I'm going to conclude this series on running a small user group with a topic that came up for discussion earlier in the week. A friend of mine, and a member of Midlands PASS, made a remark that whenever the officers of Midlands PASS talk about the group, we call it the… Read more

2 comments, 1,387 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 December 2009

Script Individual User Rights in a Database with PowerShell


Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a specific user. I wrote a script once that I was pretty sure did that so I jumped in to help. It turns out that I lost that particular script… Read more

0 comments, 1,388 reads

Posted in Adventures in SQL on 31 December 2009

Wrapping Up Blogging for 2009

I think I’ve met my goal of blogging every day. I’m at almost 800 posts now over the past 2.5 years and forcing myself to write something every day has been useful. I won’t say that what I write every day is note worthy, but it’s practice, both in writing… Read more

2 comments, 1,381 reads

Posted in SQLAndy on 30 December 2009

A Small Collection of I/O Specific DMV Queries

It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many people seem to buy “big” servers with lots of CPU capacity and lots of RAM, but they treat the I/O subsystem as an afterthought. I have run into this situation… Read more

2 comments, 4,195 reads

Posted in Glenn Berry's SQL Server Performance on 30 December 2009

Practice Your Restores

Steven Jones posted an excellent editorial today all about how your backups are only good if you know that you can restore from them. He couldn’t be more correct. I posted the following thoughts in the comments, but I know not everyone reads the comments in articles & editorials. Although,…

Read more

0 comments, 1,296 reads

Posted in The Scary DBA on 30 December 2009

Running a Small User Group - The Tools

Because running a small user group is a labor of love, we look for time savings wherever we can to get done what has to be done. Most of this involves meeting announcements. You've got to advertise the next meeting, and it helps if you can provide little things, like… Read more

3 comments, 1,802 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 December 2009

Looking back at 2009 Goals

I set goals at the start of 2009 for the year. They were:

  • Continue with 400 posts a month
  • Blog Daily
  • Speak at each Denver area user group
  • Speak at one SQLSaturday
  • Comment on blog posts that I think are interesting.
  • Update my blog roll to show who I think…
  • Read more

    4 comments, 1,709 reads

    Posted in The Voice of the DBA on 30 December 2009

    Writing Proposals for Training

    I had a student recently who said that to get any type of training she had to write a proposal and get it approved first. I think that’s interesting, because it’s useful to make an employee learn to build a business case for an expense, especially one that has an… Read more

    1 comments, 1,504 reads

    Posted in SQLAndy on 29 December 2009

    The Other Server

    I had a fun support call I need to share. A developer called up to tell me that a particular dev instance was offline. He informed me that the server SQL08\DEV01 (the names have been changed to protect the innocent) server was completely inaccessible. I knew that multiple development teams…

    Read more

    0 comments, 1,278 reads

    Posted in The Scary DBA on 29 December 2009

    The Power of Networking

    I was contacted recently by someone that was hiring a new employee. They had searched out applicants on the Internet and found that one of them had a blog on my SQLServerCentral site. They sent me a note asking about my interactions with the applicant.

    I can’t disclose who… Read more

    5 comments, 1,437 reads

    Posted in The Voice of the DBA on 29 December 2009

    Starting the year out right

    It's the end of another year, and thus the beginning of the next one. Whether you had a successful 2009 for your career or not, now is the time to set a goal and make a plan for the new year. Take an hour over the next day and think… Read more

    2 comments, 1,386 reads

    Posted in The Voice of the DBA on 29 December 2009

    Analysis Services Performance Optimization Tips

    Over the last few weeks I have focused most of my blog energy into writing a couple articles.  So I wrote about something I was really interested in learning more about myself.  The result was three articles on performance tuning Analysis Services.  These articles not only explain the benefit to… Read more

    2 comments, 1,832 reads

    Posted in Devin Knight on 29 December 2009

    Windows ReadyBoost in Windows 7

    Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results? The idea behind ReadyBoost is to take advantage of flash memory as a cache for random disk I/O. Microsoft made some improvements to Windows ReadyBoost in Windows 7, which… Read more

    7 comments, 2,956 reads

    Posted in Glenn Berry's SQL Server Performance on 29 December 2009

    Older posts