Voice of the DBA

Category: Blog

  • 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.

  • Stairway to Development–Coming to Oregon

    SQL Saturday #265 is coming to Portland, Oregon on Nov 16, 2013 and the day before, on Friday, we have another SQL in the City Seminar. Grant and I will be in the city talking about database version control, automated build and test, and database deployment best practices.

    This is another of our SQL in the City Seminars. We’ve had 4 this year so far and we’re looking to do a few more this year and even more in 2014. This is a free, half day event where you can come and learn about some of the tips and techniques that Red Gate has learned about database development.

    I’m not sure who will be covering which sessions, but we have three that all build on the theme of better deploying software. We’ll be presenting:

    • Team-based Database Development with Version Control
    • Automated Build and Test
    • Best Practices for Database Deployment

    We walk through the steps for better tracking code, testing it, and then moving it from one environment to the next.

    These are intermediate level concepts and suitable for DBAs, developers, managers, anyone that wants a smoother software delivery process.

    Join us if you’re in the Portland area on Nov 15 by registering today. It’s free, but we have a limited amount of space.