Voice of the DBA

Tag: syndicated

  • Getting a Dedicated Admin Connection

    Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way.

    I tested this on a SQL Server 2008 instance, having a normal connection, as seen in the lower status bar:

    admin_connection2

    Right click in the query window, and select “Change Connection”. In the dialog, not add “Admin:” before the server name, as shown below.

    admin_connection

    When you connect, you’ll have an admin connection, which you can see in the status bar.

    admin_connection1 

    Pretty cool.

  • Rebuilding my laptop

    I finally got around to adding the new memory (16GB), removing the old 4GB and then replacing the DVD drive with an SSD. Now he hard part: rebuilding the machine.

    In order to use the 16GB, and get VMs to run more smoothly, I need 64 bit Windows 7. I had left the x86 install when I received it since I was worried about my Google calendar sync, and at the time I had a few 32 bit programs that didn’t work well with my 64 bit desktop.

    Almost a year later things are fairly smooth on the desktop, and since I plan on doing more presenting, and more VM work, I need to take advantage of the RAM. Which means a rebuild.

    First step is to back up my machine, which I’m doing now using my Windows Home Server. The next step is to then clone my drive to be safe, and finally I’ll do a reinstall of Windows and begin setting everything back up.

  • The Twelve Days of (SQL) Christmas

    Once upon a time a group of twelve bloggers agreed to each pick a post (or posts)  they found interesting from the previous year, blog about them, comment, and call attention to them. I was tapped to summarize things, and here we go.

    On the twelfth day of Christmas Stuart gave to me, the ghosts of SQL Christmas past, present, and future to read. (A few posts that remind us blogging is a great way to save code)

    On the eleventh day of Christmas Mike Walsh gave to me, a post that I’d like to read to thee. (It’s a great one, well written, and enjoyable on backups)

    On the tenth day of Christmas Chrys Manson gave to me, a reason the transaction log we need… (OK, a bad rhyme, but a great look at why the log is required)

    On the ninth day of Christmas Kendra Little gave to me, a deep dive into locks that we can’t see (a look at shared locks, or those missing locks)

    On the eighth day of Christmas Karen Lopez gave to me, the rules of design that so many don’t seem to read (over normalization, is it possible?)

    On the seventh day of Christmas Yanni Robel gave to us, a reminder of all changes we must not trust (production needs to be controlled)

    On the sixth day of Christmas Tim Ford gave to me, the advice that I need to learn to heed. (listening is a skill we can all improve)

    On the fifth day of Christmas Erin Stellato gave to me, a series that teaches parallels in threes. (a great series on parallelism from Adam Machanic)

    On the fourth day of Christmas Andy Leonard gave to me, a look forward to what SSIS really needs. (Denali SSIS parameters)

    On the third day of Christmas Dave Stein gave to us, a post that covers SSIS over lunch. (Todd McDermid looks at SSIS)

    On the second day of Christmas Grant Fritchey gave to me, a way to execute Powershell from the lee. (remoting with Powershell)

    On the first day of Christmas Jeremiah Peschka gave to me, a way to find a table lost at sea (or in this case, you’ve deleted it).

    It has been a wonderful year for blogging, speaking, and the general sharing of information with others. The SQL community seems to be unlike any other technical community, much more willing to share, help, and work with each other in a way that reminds me of an extended family. It is wonderful to be a part of this community, and I look forward to an even great 2011.

    Happy Holidays and don’t forget to set some goals for the next year, and maybe become a part of the 12 days in 2011.

  • The MCM Journey

    I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me to do it. I’m not consulting, and not planning on doing it anytime soon. If I studied enough to pass the lab, likely my skills would atrophy without some real work. At this point in my life, I don’t have the time for getting real work.

    Actually, I don’t have the time for real studying, either. However MVPs have the chance to take the written exam for free, instead of $500, and I can’t really justify passing up this opportunity. I scheduled it in January, and last week started studying by downloading some of the MCM Readiness videos from SQL Skills.

    I’ve been slowly starting to watch them, and I realize how much I don’t know about SQL Server as I go through them. It’s not all bad news as I also realize how much I do know in terms of general concepts and understanding of how the pieces and parts work.

    I don’t expect to pass, especially after seeing that someone like Jason Strate didn’t on his first try, but this is a good chance for me to focus on a task and also to get an idea of where I stand.