• Madeira Team

My PASS Summit 2016 Session Submissions Feedback

I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this year! The session is called “MongoDB for the SQL Server Professional”.

More about the session in the future. For now, after Brent Ozar and Steph Locke published their abstract review feedback, now it’s my turn.

All You Need to Know about SQL Server in the Cloud (Not Accepted)

Length: Pre-Conference Session (full day)

Track: Enterprise Database Administration & Deployment

Topic: Hybrid-solutions

Level: 200

Abstract:

The cloud is here, and you want to start working with it. When starting to work with SQL Server in the cloud, there are many things that need to be taken into account.

Through extensive demos on both Amazon Web Services and Microsoft Azure, this full day seminar will take you through the steps of moving SQL Server to the cloud the right way. From choosing the right cloud model, to architecture and performance considerations, and finally to performing the actual deployment.

By the end of the day, you will have a firm understanding of the options for running SQL Server in the cloud, when and how to use which, how to do it the right way, and how to leverage the benefits of the cloud.

The seminar will cover:

  1. How to choose between SQL Server as a service and SQL Server on a virtual machine

  2. How to choose the right hardware for your workload

  3. Performance considerations and best practices

  4. How to work in a hybrid environment where your data is both on-premise and in the cloud

  5. Backup, restore, high availability and disaster recovery options

  6. Security considerations

  7. Scaling options

  8. What to watch out for

  9. How does SQL Server fit in the cloud ecosystem

  10. How to automate your work

  11. How to cut your expenses

The seminar will include a deep dive into both the PaaS options (Azure SQL Database and Amazon RDS) and IaaS options (Azure Virtual Machines and Amazon EC2).

Whether you plan to migrate a current project to the cloud or start a new one, this seminar is for you.

Prerequisites:

  1. Experience working with SQL Server

Goals

  1. Understand the difference between running SQL Server on a VM and SQL Server as a service

  2. Understand the benefits and limitations of running SQL Server in the cloud

  3. Get insights about different ways for getting the optimal performance when running SQL Server in the cloud

Feedback:

  1. Cloud as always (from last few years) is on the top of sessions. This pre-conf looks really good and it’s interesting.

  2. Abstract: The outline and detail for this abstract are well written and cover pretty much what the audience will get out of this pre-conference. Topic: This is a hot topic. More organizations are preparing their infrastructure to utilize cloud offering and this will be a great session for any DBA/System Engineer to learn Subjective: I will attend this subject

  3. The outline seems well developed. The outline seems to clearly describe the contents of the presentation. The topic and goals should be compelling to attendees. The topic appears to be timely, new and relevant. There appears to be a reasonable amount of live demonstrations in relation to the topic being presented. The topic and goals appear to deliver an appropriate amount of material for the time allotted.

  4. Abstract: detailed, well written Topic: relevant Subjective rating: interesting

  5. Abstract: Clear and well written abstract. Seems to cover a wide range of cloud technologies. Topic: Great trendy topic that will attract attendees. Subjective: Sounds like a fun full day session.

My Thoughts:

I submitted this abstract even though I knew it wouldn’t get in.

First, I assumed I needed a little more international speaking experience to get in (I’m working on it).

The second and main reason is the list of prerequisites for a pre-conference speaker, which one of them is delivering a pre-conference session in events like PASS Summit, SQLBits and SQLSaturdays. I totally respect that and understand the rationale behind it, as it’s very important to maintain a high standard of precons. I also have LOTS of respect to the good people who are in charge of the review process – they have a very hard job.

The only feedback I have about it is that PASS needs to make sure it doesn’t turn the precons into a closed club where no new members can get in. Getting a precon at a SQLSaturday, for example, is very tough, as they have the same problem too, and many of the SQLSaturday precons are closed behind the scenes without opening it to everyone with a call for speakers.

So why did I submit it? For me to have it ready for other conferences, and in case something changes for some reason, and speakers who hadn’t yet delivered a precon would be considered.

As for the abstract comments, I feel I did a good job and the review team seem to have liked it. Hopefully next year.

It’s 2016! Stop Doing This! (Not Accepted)

Length: General Session (75 minutes)

Track: Enterprise Database Administration & Deployment

Topic: Database Maintenance

Level: 200

Abstract:

Many years ago, some SQL Server related operations were considered as best practices, and since then we’ve been implementing many of them automatically.

The problem is that things have changed. Some of them aren’t considered a best practice anymore, some of them are not suited to the hardware and software changes that have occurred over the years, and some of them were overrated from the beginning.

In this session, we will go over those best practices, explain where they came from, explain why they are not relevant anymore, and where your time, effort and money should actually be spent today.

Among others, we will cover your index maintenance processes, your code, plan reuse and recompilations, your disk layout and your thoughts about where the time goes in your queries.

Prerequisites:

  1. Experience writing T-SQL and administrating SQL Server databases

Goals:

  1. Understand why some old best practices are not relevant anymore

  2. Understand why relying on old and outdated best practices is not a good use of your time

  3. Understand where your time should actually be spent and where you should focus

Feedback:

  1. I would attend this session.

  2. Abstract: not detailed Topic: new, very interesting Subjective rating: it seems a really cool session

  3. Abstract: Clearly written abstract. Topic: Title is fun and should get people to bite. Subjective: Sounds like it could be a great session, I’d attend it. Could also end up being too broad and not technically deep enough, if too many topics are covered.

My Thoughts:

Didn’t have too much hopes for this session. It would be a nice, provocative one, but I assumed other ones in the category will be more appealing to the reviewers.

MongoDB for the SQL Server Professional (Accepted!!)

Length: Half-Day Session

Track: Application & Database Development

Topic: .NET Framework Integration

Level: 200

Abstract:

NoSQL databases are on the rise. Today, many data-oriented applications use a NoSQL database and not a relational database like SQL Server.

MongoDB is the leading NoSQL database today. It provides a rich set of features and supports many programming languages. Many organizations move from SQL Server to MongoDB, and many DBAs and database developers are required to know it in addition to SQL Server.

In this session, we will talk about:

* The reasons for the rising popularity of NoSQL databases

* What a Document Database is and the use cases for using it

* MongoDB terminology compared to SQL Server terminology

* How to setup and configure a MongoDB cluster

* How to load and retrieve data from MongoDB

* Performance tuning with MongoDB

* Do’s and Don’t Do’s with MongoDB

* Hybrid solutions combining SQL Server and MongoDB

* How to run MongoDB on Azure

MongoDB is here. It’s time to know how, when and why to work with it.

Prerequisites:

  1. Experience designing tables and writing queries against SQL Server

Goals:

  1. Understand the different types of NoSQL databases and the reasons for their rising popularity

  2. Understand what a Document Database is and the use cases for using it

  3. Understand how MongoDB works, how to set it up and how to perform various data loading and retrieval operations using it

Feedback: