Voice of the DBA

Category: Blog

  • The Powershell Challenge

    indexI’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve dabbled in various ways, using it to handle small tasks. However I haven’t really committed to learning a bunch of PoSh.

    Last month I was with Grant Fritchey on the 2013 SQL in the City tour and in one of his sessions, he uses some Powershell to audit his SQL Server instance. I thought that was pretty cool, and it made me want to dig in further. At the end of his talk, he mentioned a book, and I decided to grab it.

    It’s Learn Windows Powershell 3 in a Month of Lunches from Don Jones. The name alone made me want to grab it, and it has a catchy title.

    My plan is to take time every day or two and read a chapter and work through exercises in the book. I really want to get more comfort in PoSh because I do believe in it and I think it’s a fantastic way to get things done. I don’t work at scale, but I suspect with a little practice I’ll be using PoSh more often for simple things and saving those scripts.

    I’ll blog along the way and see how things are going. Once I get through, I expect that I’ll be digging into more with other articles and books that deal specifically with SQL Server.

    The days in the Challenge:

  • Transactionally Consistent

    What does this mean? I had someone ask me in a session recently, and I think I have a good explanation, but I thought this was worth a blog.

    Transactionally Consistent means that there is a snapshot of the database at a point in time that ensures committed transactions are actually reflected in the database and uncommitted transactions are not. I haven’t found a better concise definition, but Paul Randal has a great longer explanation.

    This is reflected in the ACID RDBMS model as the C for consistent.

    In a SQL Server backup process, this is accounted for by including some amount of the transaction log in the full database backup. The amount included depends on your workload and the amount of data you back up, and if you read Paul’s explanation, you’ll understand more.

    Make sure that your backups are transactionally consistent. Don’t export, don’t use open file managers, don’t use anything that doesn’t respect transactions. The native SQL Server backup process does this. If you want a few other features, my employer makes SQL Backup Pro, which also respects transactions.

  • Learn about Encryption at SQL Saturday #265

    You can learn about encryption at SQL Satuday #265 is Portland, Oregon in a couple weeks. I’ll be heading out to the event on November 16, 2013, my first visit to Portland in 15 years.  In addition to my session on the various encryption options in SQL Server, I’ll be talking about your career with my branding talk, plus there are many other amazing sessions.

    A few quick links:

    Register for SQL Saturday #233

    Register for the FRIDAY, November 15, 2013, FREE Red Gate Seminar

    With the MVP Summit in Redmond the following week, you have the chance to learn about:

    Check the schedule for the details and to pick the best sessions for you. It’s a tough choice, but no matter what you choose, I’m sure you’ll learn a lot.

    It’s a busy day for me, as I’ll also have a lunchtime session where I’m looking to talk about Red Gate Software’s vision and experience with database deployment. We’ve been working hard to find ways to deliver our software faster, and we’ve put that knowledge into a few products. Our goal is to try and make it easier for you to deploy changes to your databases, so come let me know what challenges you face and what holes are in our solutions.

    It should be a great event, and if you’re in the area on Friday, November 15, 2013, and you want to learn about better database development and deployment strategies, Red Gate has a free SQL in the City Seminar that you can register for. Grant Fritchey and I will be talking about version control, continuous integration, and deployment in this FREE, half day seminar. It’s aimed at beginner to intermediate level people, so register today if you can attend.

  • One day in the office

    I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling and speaking this week. Today I’m in the office, but only today.

    Tomorrow I’m outside.

    I have more vacation scheduled tomorrow, along with Monday and Tuesday. Given the nature of my job, that means I need to ensure things are prepped and scheduled for the next few days until I return next Wednesday.

    It’s been a busy day. Some of my prep was done last week, but with three days in Las Vegas this week at SQL Intersection, I wasn’t completely prepared. I’ve been editing content, scheduling things, recording podcasts and more.

    I’m almost done, which means I should get a good vacation. I should have the chance to start work on another project tomorrow: building a horse shelter.