Tag: syndicated

  • Spring SQL Server Connections / DevConnections

    I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I talked about Encryption, Filestream/Filetable, and Contained Databases. Always cool to see your name in print

    Photo Mar 28, 9 15 56 AM

    It was a nice event, with decent crowds in the SQL Server. I didn’t have a ton of people, but when you’re competing with the SQLskills crew, Brent Ozar, Allen White, Glen Berry and a few others, it’s hard to draw a large crowd.

    Photo Mar 27, 11 13 04 AM

    Grant and Brad both presented as well, filling up the slots in our SQLServerCentral track, and talking about a wide range of topics. Grant’s talk on continuous integration and deployment was really good, with lots of interesting information. It was good to hear from a few people in the audience that face challenges on this particular topic. We have a whitepaper from Red Gate that talks a little about how we solve this, but Grant gave some other alternatives that you could use to tackle this.

    Photo Mar 29, 3 29 29 PM

    The show was at the MGM Grand this time, and I have to say I really like that resort. Things seemed a little closer together, more food/dining choices, and close to other places on the strip. A walk to the Bellagio was no big deal. There were also three of my favorite morning stops on the road

    Photo Mar 27, 7 51 14 PM

    It wasn’t just me that liked the hotel. I left Paul Randal, Kimberliy Tripp, Brent Ozar, and Glenn Berry at Craftsteak Thur night to go to the airport. I say down before my flight to see a tweet that the First Lady of the US was having dinner that night in the restaurant.

    The sessions I attended and delivered were interesting. Lots of system administrators and developers mixed in with the DBAs, looking for information on various features. It was a twist to get questions that sometimes were more basic for DBAs, and at the same time, had a different view and some challenges when presented from another perspective. On a panel with Grant Fritchey and Brent Ozar, we had some interesting HA/DR questions from the audience about 2012 as well, things that made us think a bit.

    The exhibition hall was a little small, but it’s nicely set up with long breaks between some sessions for people to wander around and see what new third party tools are available. I spent a little time at the Red Gate booth and had some very interesting conversations with people, including a nice long one about .NET development.

    Photo Mar 27, 9 23 26 AM

    As I do everywhere on the road, I start the mornings out with a run. This time the loop around the MGM complex is a little over a mile and a half, which I enjoyed all three days with Allen White at 6:30 every morning. #sqlrun in Las Vegas!

    Photo Mar 29, 6 25 37 AM

    This time the Windows and Visual Studio tracks were on another floor, and with three sessions to prepare for, I didn’t get the chance to visit those tracks. I did see a great talk from Allen on Server Core, which I’ve been wanting to experiment with. Look for most of my future server VMs to be Server Core, which should make things run faster on my little Air.

    I also saw a couple talks from Mark Minasi on Windows 8 and that looks rather interesting in a few ways. I’m not sure I like the client interface, but some of the architectural changes look like good moves on the part of Microsoft. The server side, especially seems like it will end up being a good server OS for management by IT staffs.

    The other great thing about a show in Vegas is the wide variety of shows. I asked in my sessions and a few people saw Ka, one of the Cirque du Soleil shows. Someone saw David Copperfield as well, which I would have liked to see. Oh well, there’s always next time.

    My entertainment this time was a wonderful dinner with Brent Ozar and Grant Fritchey at e by Jose Andres in the Cosmopolitan. Brent invited us and I wasn’t sure since it’s a very fancy dinner. However I thoroughly enjoyed it. Not sure I’d go back myself, but I’d take someone else, just for the experience. The food was very interesting (I’m not a foodie), and the presentation amazing. I had a great time. Here was one of our “courses”

    Photo Mar 28, 5 44 38 PM

    Overall a great show, and a fun time. SQLServerCentral is one of the sponsors, and we have a track there every show.

    Photo Mar 29, 12 23 12 PM

    We should be back in the fall, this time at the Bellagio, Oct 29-Oct 1. Hopefully you can join us, and we look forward to seeing you then.

  • Contained Databases in SQL Server 2012

    Abstract:

    One of the problems with databases in SQL Server is the dependency of the database on various parts of the host instance. In SQL Server 2012 there is an enhancement to the database format that allows for partial containment of your database, and will make the movement, migration, and management of the databases much simpler. This session introduces the new database structure and explains how it can be used in your environment.

    This talk looks at the new partially contained databases in SQL Server 2012.

    Agenda:

    • What is a contained database
    • Contained databases in SQL Server 2012
    • The Future

    The talk will demonstrate the issues with uncontained databases, provide demos on how to create and alter contained databases, look at security and collation issues in SQL Server and speculate on the future.

    Level: 200

    Length: 60 minutes

    Slides:

    Demo Code: ContainedDB.zip

    Related Posts

    You can read all the posts I’ve written on contained databases by examining that tag

    Presentations

    You can view my complete speaking schedule here: http://wp.me/P14wgJ-1tV

  • The Encryption Primer

    This talk deals with SQL Server encryption options. I have given a few variations, and you can get the different decks below.

    SQL Server has a number of encryption features that allow you to better secure your data. This session will examine the basics of encryption and cover the various ways in which you can encode and decode your data to protect it from unauthorized access. Cell level encryption, Transparent Data Encryption, and backup encryption will all be discussed. This session is designed for those who want to learn the basics of how to protect their data.

    This talk looks at the encryption options in SQL Server that are available, including the changes in SQL Server 2012. The agenda is:

    • What is Encryption
    • Encryption in SQL Server
    • Transparent Data Encryption
    • Hashing
    • Symmetric Keys
    • Asymmetric Keys
    • Certificates
    • SSL Communications

    The presentation features basic demos of how these features are implemented in SQL Server.

    Level: 200

    Length: 60-75 minutes

    Demo code:

    Slides:

    Presentation Schedule

    You can view the my speaking schedule here. The upcoming and past deliveries of this session are:

    1. Apr 27, 2013 – SQL Saturday #175 – Fargo
    2. Apr 10-12, 2013 – SQL Intersection, Las Vegas, NV
    3. Apr 9, 2013 – SQL Saturday #197
    4. Mar 9, 2013 – SQL Saturday #187
    5. Mar 7, 2013 – Richmond SQL Server User Group
    6. Nov 15, 2012 – Denver SQL Server Users Group
    7. Nov 13, 2012 – Boulder SQL Server Users Group
    8. Nov 5, 2012 – SQL in the City Seattle, WA 2012
    9. July 28, 2012 – SQL Saturday #144 Sacramento, CA
    10. June 9, 2012 – SQL Saturday #132 – Pensacola
    11. Apr 28, 2012 – SQL Saturday #131 – Phoenix
    12. Mar 26-29 – SQL Connections, Spring 2012

    Related Blog Posts

  • Unstructured Data in SQL Server

    Abstract:

    More and more of our data does not fit neatly into a structured, relational model of rows and columns of data. In this session, you will learn about how SQL Server stores unstructured data, with a special emphasis on how to use Filestream, which integrates SQL Server with the NTFS file system by storing varbinary(max) binary large object data as files stored within the file system. You will also learn about the new SQL Server 2012 filetable feature, which builds on Filestream and provides the ability to read, write, and update Filestream objects directly through the file system. This session is designed for DBAs and developers who need to learn how to manage large quantities of unstructured data.

    This covers SQL Server 2008, R2, and 2012. The basic Agenda:

    • What is unstructured data
    • Filestream
    • FileTable

    There are demos that look at how Filestream works and how FileTable can be used in SQL Server 2012.

    Level: 200

    Length: 60 Minutes

    Demo code: UnstructuredData.zip

    Slides: UnstructuredData.ppt

    Related Posts:

    Presentations:

    You can view my speaking schedule here: http://wp.me/P14wgJ-1tV