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”.
All You Need to Know about SQL Server in the Cloud (Not Accepted)
Length: Pre-Conference Session (full day)
Track: Enterprise Database Administration & Deployment
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:
How to choose between SQL Server as a service and SQL Server on a virtual machine
How to choose the right hardware for your workload
Performance considerations and best practices
How to work in a hybrid environment where your data is both on-premise and in the cloud
Backup, restore, high availability and disaster recovery options
What to watch out for
How does SQL Server fit in the cloud ecosystem
How to automate your work
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.
Experience working with SQL Server
Understand the difference between running SQL Server on a VM and SQL Server as a service
Understand the benefits and limitations of running SQL Server in the cloud
Get insights about different ways for getting the optimal performance when running SQL Server in the cloud
Cloud as always (from last few years) is on the top of sessions. This pre-conf looks really good and it’s interesting.
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
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.
Abstract: detailed, well written Topic: relevant Subjective rating: interesting
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.
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
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.
Experience writing T-SQL and administrating SQL Server databases
Understand why some old best practices are not relevant anymore
Understand why relying on old and outdated best practices is not a good use of your time
Understand where your time should actually be spent and where you should focus
I would attend this session.
Abstract: not detailed Topic: new, very interesting Subjective rating: it seems a really cool session
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.
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
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.
Experience designing tables and writing queries against SQL Server
Understand the different types of NoSQL databases and the reasons for their rising popularity
Understand what a Document Database is and the use cases for using it
Understand how MongoDB works, how to set it up and how to perform various data loading and retrieval operations using it