Voice of the DBA

Tag: Redgate

  • A Great SQL in the City 2015 Seattle

    Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a couple weeks ago for the first event, and we closed out the year in Seattle on Monday.

    I had some, fun, as you can see here.

    IMG_1541

    Slava Murygin has a bunch more pictures on his blog. Check them out and you can see how much everyone enjoyed the event.

    The day started early for me, and with rehearsals early and the need to iron a shirt, I didn’t get a chance to work out in the am. That was disappointing. It still was a 10k step day, but I’m looking forward to yoga or running today. We arrived and practiced, working through the demos and talks with our CEO, Simon, and  Alastair, a developer working on Visual Studio stuff. We felt a little less polished than in London, and I think we were all more nervous this time.

    The keynote seemed to go OK. We missed a few lines and I was hoping it wasn’t too cheesy showcasing tools, but people seemed to enjoy it.

    My Version Control talk started slow, and I was a bit worried about time, but ended up going long with some questions and had to skip some of the branching stuff. I need to write more and get some things up on this blog since I didn’t cover the topic well enough. I have to apologize to Brian Randall for running long. I gave him about 3 minutes to setup before his session.

    The rest of the day was chatting with people before the panel at the end. I think the panel is one of the more interesting sessions, with us debating and chatting about building software and we got lots of questions. There were 4 or 5 more hands in the air when I had to cut things off. I’d really like to see us do two panels a day, with only 3 people and the chance for more questions from attendees that are struggling with issues.

    I had to rush out of the event for the networking dinner with Andy Warren, but it was an enjoyable day and one I hope we repeat in 2016.

  • SQL in the City Comes to Seattle in 3 Days

    Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had a wonderful event, and I’m looking forward to Seattle. Lots of good questions and comments in my version control talk, good feedback on the keynote, which I really enjoyed. I thought our end of day panel was outstanding, and I wish we had 2 hours for that as the questions were amazing.

    I’m looking forward to a duplication of SQL in the City in Seattle on Monday, just a few days away. We’re going to be at the Hyatt in downtown Seattle, and we’d love to have you come. You can register and join us, but please don’t register unless you can come.

    There are also a few workshops in Seattle on Tuesday, so if you want hands on practice, come sign up for on of these.

  • Git Push in SQL Source Control

    I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you don’t see the release of 4.1.x, you need to update. The update should be available for everyone.

    I do like Git. I’m working with SVN, TFS, and Git on a regular basis. However I tend to prefer Git overall. Now I can do most things I want to do in SOC, which is exciting. No forgetting to push or the need to drop to the command line or another interface.

    The Git Additions

    In a previous post, I set up a link between a database and a Git repository. Let’s see how the Git push now works.

    I’ve got this database on my local instance.

    soc_git_push_2

    It’s linked with SQL Source Control to a local Git repository.

    soc_git_push_3

    Let’s change something. I’ll pop open a stored proc.

    soc_git_push_4

    Let’s make a simple, but real, change. I’ll add a NOCOUNT setting in there, which is a good idea.

    soc_git_push_5

    In the Commit tab for SQL Source Control, I see my change. Note that most everything looks the same here and I can see the code differences like I always could.

    soc_git_push_6

    Now I commit this change. In this case, it goes to my local Git repo, but isn’t pushed.

    NOTE: In the real world, I’d pull before I commit to be sure I wasn’t causing a merge issue.

    Once that’s done, my Commit tab changes.

    soc_git_push_7

    SQL Source Control (SOC) detects the change and knows we have an unsynced Git repo. I can now push the “Push” button. Once I do this, I get a warning if I haven’t turned this off. I turn it off, but you should always be aware that SOC isn’t managing your Git repo. It’s linking to it. If you make changes in the repo with some other app, like Visual Studio, the entire repo is pushed, not just the change SOC committed.

    soc_git_push_8

    Once this is done, I once again see a clean Commit tab.

    soc_git_push_1

    However, if I go to the remote repo, which is on GitHub in this case, I see my change.

    soc_git_push_9

    I love Git. I think it’s really cool, and it’s a great way to work with distributed Version Control. I am playing with TFS as well, but I prefer Git, and I think this support is great.

    There are still things needed, things I want, and more, so be sure you add your votes to the SQL Source Control UserVoice page and let the SOC team know what’s important to you.

    If you’re not using SQL Source Control, you might check it out and give it a try for a month: http://www.red-gate.com/products/sql-development/sql-source-control/

  • Traveling in Wales

    It’s SQL Relay Cardiff day today. This is my first time in Wales, and it’s a busy day at SQL Relay. It’s a bit of deja vu with me delivering the same session on Version Control today that I presented 18 ours ago at SQL Relay Bristol.

    It’s interesting being on part of the SQL Relay tour, with some of the same speakers, some different, the rapid travel from one city to the next, and orienting myself in a new environment. The venues are much different, with a set of hotel conference rooms yesterday and a large arena facility (the Motorpoint Arena) today.  It’s surprisingly confusing trying to find toilets, speaker rooms, and more.

    However the people are nice, and friendly, although quiet. I got lots of good questions both days, on a semi-confusing topic, and that will help me revisit the session and make some changes over the next few days.

    I get to help on a second session today as we have a speaker that’s ill. Then it’s some work as I prep for travel back to London and SQL in the City in London on Friday.