Tag: syndicated

  • Exploring a Database in Azure

    After creating my Azure account, I wasn’t sure where to go next. Fortunately I had an immediate project that occupied my attention: a public Adventureworks database.

    As we noted, Red Gate and SQLServerCentral agreed to host the database and cover costs. Once Jamie Thomson transferred the database to my subscription, which didn’t seem too hard, although slightly confusing, it showed up in my list of objects.

    azure_i

    I drilled down to the sql databases to ensure this was the only object there, and it was.

    azure_j

    I wasn’t sure what I could do, so I clicked on the database. I do tend to be an RTFM guy at the beginning, but I was curious how easy they’ve made things. This is what I saw:

    azure_k

    It’s a good list of things, although since I have SSDT installed, I didn’t need the first item. I guess if you have SSDT installed you would know it, and the link is handy. The interesting thing for me was the “Server” string at the bottom of the panel.

    I wonder if it works.

    Jamie had given me the admin name and password, and I plugged this into Management Studio, along with the connection string.

    azure_l

    Sure enough, it connected, and changing to the AdventureWorks2012 database, I could query the objects.

    azure_m

    I decided to test Object Explorer as well, and that was interesting. I had a very cut down version of what I normally see for a SQL Server instance.

    azure_n

    Most of the “instance” level stuff was gone. I could see the master database, and my own database, but no others.

    Since this was a new instance, one of the first things I decided to do was create my own login account. I right clicked “Logins” and selected “New Login”. I go this:

    azure_o

    A template for a script. That’s interesting. No GUI version of the login creation dialog. I used CTRL+Shift+M to fill in the template stuff.

    azure_p

    That’s not my password, but I did choose a nice, long one. I executed the script to create a login and then went to add a user. Once again, I got a script from the GUI.

    azure_q

    I changed this and created my user to map to my login.

    This let me log into the system, and set myself as a db_owner. However I wasn’t an administrator. That’s for another post.

  • The 2013 SQL in the City Tour

    sitc_e

    Once again, Red Gate is planning on a tour of the US for the SQL in the City events. Last year we had a large tour, hitting 6 cities in the US during October and November of 2012. It was great fun, and very well received by the attendees. I enjoyed it quite a bit, though it was a bit of a stressful time for me with all the travel.

    This year we’ve scaled back slightly, but we’re still moving around the US. We have three dates scheduled, all packed into a week: Pasadena, Atlanta, and Charlotte.

    sitc_b

    Our first stop will be in California, on Wednesday, Oct 9, 2013. Red Gate has a sales office in the Pasadena area, and we’ll have a large staff coming out to meet customers and the SQL community. This event will be at the Pasadena Convention Center, in the North East LA area. It’s close to Arcadia Wilderness Park, where I’m hoping to get in a #sqlrun Winking smile

    Register today and join us if you are in the area.

     

    sitc_c

    Atlanta has a great SQL Server community. They consistently have the largest SQL Saturday events every year and there is a lot of excitement about the platform in this area. It would be a great place for a future Summit (hint, send your feedback to PASS).

    We’ll be in Atlanta on Friday, October 11, 2013 at the Blackburn Conference Center. This is at the John Marshall Law School in the heart of the city. I’m expecting this event to sell out soon, so register today.

     

    sitc_d

    The PASS Summit is in Charlotte this year, and once again we’ll open the week with a SQL in the City event in Charlotte on Monday, October 14, 2013. If you’re in town early, or live there, register and come spend a fun day on Monday with us, talking about lots of development and DBA SQL Server topics

    You can register now to join us at the Ritz-Carlton in downtown Charlotte.

     

    That’s our 2013 tour (along with sold out London), and I’m looking forward to seeing many of you and meeting even more this fall.

  • When will we look back at this?

    It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting to 40404 for basic twitter usage on my Windows 6.5 Mobile. That seems miles away from the apps I know use on my current iPhone 4S. I almost can’t comprehend what my life would be like if I didn’t have a smartphone now.

    I saw this video of a HoloDesk from Microsoft Research. It’s neat, and I can imagine the possibilities of what might come, but for not it’s very basic.

    It makes me wonder when we’ll have something more like this interface:

  • Starting with Azure

    I’ve been meaning to do this, and I finally had the chance recently to start working with Azure. Red Gate is investing in cloud tools, and more development tools, so it’s something I need to work on.

    I went to the Azure page, and noticed a “Member Offers” link.

    azure_a

    When I clicked through, I could see the benefits. Below this screen shot is the list of stuff you get, depending on your MSDN subscription. You can see the exact benefits on the MSDN benefits page.

    azure_b

    I clicked the activate link and was taken to the Windows Live login page. After signing in, I got a page that asked me to create an account. It listed my specific benefits and the requirements for an Azure account.

    azure_c

    Since I have a mobile phone and a credit card, I clicked the arrow to proceed. The first thing is to verify your account with a mobile phone. I assume this gives me some sort of two factor authentication as well as a way for them to reach me for billing issues.

    azure_d

    After receiving a text and entering it, I was taken to the billing area. I know this freaks many people out, however I’ve had a number of friends use the MSDN subscription trial and not been billed after 5 or 6 months. I’ve had a few that have been billed, but it’s been low amounts, in the $5-10 range. Grant Fritchey (b | t) is one of them, and with all the writing he’s done on Azure, some presentations, and research for Red Gate, he hasn’t had issues.

    It’s your career, it’s worth $5 a month. If you find you’re spending more, shut stuff down. I’d give it a try, however, if there is any chance your career will include work in the cloud.

    azure_e

    Once you enter a credit card, they’ll get to work.

    azure_f

    The welcome screen gives you lots of options. I’m sure I’ll end up here quite often across the next few months as I try to be sure that I’m not running up my cost. I can expense it back to Red Gate, but I do try to spend wisely.

    azure_g

    What now? There’s lots of options.

    azure_h

    I have a few things in mind, but I’ll probably start with a few light experiments based on some presentations I’ve seen. Buck Woody has a nice set of resources to get me started, and I’ll likely give one of these a try.