Sebastian Meine


Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server.

Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development, and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor & lead developer of tSQLt.

The Phenomenal IT Consultant – A Blueprint to Getting New Clients, Charging More, and Working Less

Saturday, March 24th, 2018 at 3:00 pm in

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.

If you are like most independent consultants, you spend all your waking hours chasing after new clients. But somehow, you just can’t get enough of them to say yes.

It’s time for a change. Imagine having potential clients call you and demand that you take their money, instead of you calling them and being rejected. Imagine being able to pick and choose who you want to work with instead of having to take on everyone with a wallet. Imagine being able to increase your prices and spend less time working while still growing your income.

Discover how this is possible: Join Sebastian Meine, Ph.D. for this unique session where he will introduce a simple way to attract new clients to your business: The NICER Client Attraction Method™.

In this session, you’ll
• Learn why your current way of finding clients is actually driving them away.
• Experience ways to stop feeling like the best-kept secret in your field and instead be seen as a sought-after authority.
• Identify the five steps every client has to take before they will ever pay you. (Ignore them, and you’ll lose a lot of business.)
• Discover the one thing you can do today that’ll make any conversation with a potential client easy. No more feeling like a used-car salesman.

So, if you feel like you are treading water when it comes to marketing and growing your business, join this session and get started on your way to becoming a Phenomenal IT Consultant.

SQL Server Indexing for Developers and Accidental DBAs

Saturday, March 24th, 2018 at 1:30 pm in

So you have been tasked with making that query faster. You know that indexes often can help with query performance, but how do you even start going about it.

Join Sebastian Meine, Ph.D. for this truly interactive session and discover how indexes in SQL Server work. After attending, you’ll be able to answer common index questions, like:

– Which columns should I add to my index?
– How many indexes should I add to my new table?
– Does the column order in my index have to match that in my query?
– Does it hurt to have too many indexes?
– When should I consolidate Indexes?
– Are there queries that get slower after I create an index?

But even more important, you’ll be able to explain how indexes are organized in SQL Server and what mechanism is responsible for the amazing performance gains you can achieve with them.

Don’t miss this unique session. Attend, and you might just turn into an indexing superstar.

The Phenomenal IT Consultant

Saturday, April 9th, 2016 at 3:00 pm in

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone. In this session we cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you, even if you hate selling. We will close with a brief look into the world of online marketing and see how to make this elusive thing they call “passive income” happen. Join this session and get started on your way to becoming a Phenomenal IT Consultant.

Is Your Data Secure?

Saturday, April 9th, 2016 at 10:00 am in

Your company probably stores a lot of data about your customers. You might store simple content like customers’ order histories or more sensitive information like credit card numbers or health related information. For most businesses, the data they store is the business foundation, and its loss can crush the business. But, if the data gets “out” the effects can be similarly detrimental, not only for your business, but for each of your clients. Credit card misuse can cause financial ruin; published health records could cost them their job and their future. Even a simple leaked password can be used to gain access to more sensitive data.
So let me ask you a simple question: Is your data secure?
Join security expert Sebastian Meine, PhD in this session and discover the 10 most common database security vulnerabilities. These are the wide open doors that hackers are using now to gain access. Will they be able to steal your data?

SQL Server 2016 Always Encrypted

Saturday, October 10th, 2015 at 10:00 am in

Join this session by security expert Sebastian Meine (PhD) for an introduction to the fascinating new SQL Server 2016 feature Always Encrypted. In this session, geared towards the Database Developer, you will learn what makes Always Encrypted more secure and easier to use than prior encryption technologies available in SQL Server. After exploring the architecture behind this new feature, you will be able to observe how to implement Always Encrypted in SQL Server and discover how it might affect your maintenance and recovery strategies.
After attending this session, you will be able to:
• Explain how Always Encrypted works.
• Setup and use Always Encrypted in your own SQL Server 2016 environment.
• Identify places in your application that might require small changes.
To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and not be scared when seeing C# code.

SQL Server Cryptology – A Primer

Saturday, March 21st, 2015 at 1:30 pm in

So, you got told you need to encrypt “the database”. Now what?
Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies.
After attending this session, you will be able to
• explain the difference between symmetric and asymmetric encryption.
• select the right cryptographic technology for your special security requirement.
• identify when to use one-way hashing instead of encryption.
To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and have basic permission management skills.

Securing a Multi-Database Application

Saturday, June 21st, 2014 at 1:30 pm in

It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable.
In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.

Five Secret MERGE Patterns

Saturday, November 23rd, 2013 at 3:00 pm in 305

Abstract
The MERGE statement was introduced into the SQL Standard with SQL2003 and into SQL Server with version 2008. SQL Server goes far beyond the standard and implements the MERGE statement as a very powerful combination of the three statements INSERT, UPDATE and DELETE.

In this talk I am going to show five use cases that you might not have thought of before. We will also cover some issues that you must be aware of to avoid problems when using the MERGE statement.

Prerequisites
This is a 100 level No-Slide-Demo-Only talk. To get the most out of it you should feel comfortable using the INSERT, UPDATE and DELETE statements and write simple join queries.

5 Key Points for Effective T-SQL Unit Testing

Wednesday, February 20th, 2013 at 5:30 pm

In this session we are going to look at the five things you need to know when starting to unit test your T-SQL code. After attending the session you will know how to pick a good unit testing framework, how to write your first test, how to spy on procedures, how to fake tables and how to deal with constraints. We will also briefly cover test case heuristics that help with these questions: “How do I pick the first test?” and “How many tests is enough?”

Index Internals

Saturday, November 17th, 2012 at 8:30 am in 305

In this session we will examine one of SQL Servers’ most fundamental yet most important functions – how does SQL Server store data on disk and how does it find it again when executing a query. Using a combination of demos, lecture and discussions we will begin with the structure of the data on disk by delving into the world of HoBTs and Extends, RIDs and Keys and especially Pages. From there we will tackle topics concerning the retrieval of data such as Index levels, Index Scans and Seeks and Lookups.