SQL Saturday Los Angeles, 2019 is coming up quick! This is a FREE one-day training event for Microsoft Data Platform platform professionals. The event will be held on Saturday, June 15th at Layola Marymount University (“LMU”), 1 LMU Drive, Los Angeles, California, 90045. Click on the link below for more details and to reserve your spot today. I will be presenting a session on Master Data Services and hope to see you there!
SQL Saturday Orange County, 2019 is now less than one month away. The event will be held on Saturday, April 13th at Golden West College, 15744 Goldenwest St, Orange County, California, United States, 92647. There is still time to register! I will be presenting a session on Master Data Services and hope to see you there!
SQL Saturday San Diego is just over a week away! It will be held September 22nd, 2018 at UCSD Extension – University City Center, 6256 Greenwich Dr., San Diego, California, 92122.
I will be presenting a session on performance tuning jobs. Learn performance tuning strategies on how to cut hours (not minutes) from your jobs.
I hope to see you there!
SQL Saturday L.A. is just around the corner! It will be held on June 9th, 2018 at Loyola Marymount University (“LMU”), 1 LMU Drive, Los Angeles, California, Los Angeles, California, 90045.
I will be presenting a session on performance tuning jobs. Learn performance tuning strategies on how to cut hours (not minutes) from your jobs.
There is still time to register so be sure to signup today!
http://www.sqlsaturday.com/773/EventHome.aspx
SQL Saturday Orange County, 2018 is quickly approaching! The event will be held on Saturday, April 14th at Golden West College, 15744 Goldenwest St, Orange County, California, United States, 92647. There is still time to register.
Also, I will be presenting a new session on performance tuning jobs and strategies. Hope to see you there!
http://www.sqlsaturday.com/740/eventhome.aspx
While only a few days away, there is still time to register and attend the SQL Saturday San Diego event! I will be presenting on SQL Injections and how to stop them. Come spend the day learning about SQL Server and listening to a great lineup of speakers.
The event will be held at UCSD Extension – University City Center, 6256 Greenwich Dr., San Diego, California, 92122 on Saturday, September 23. See you there!
I’m excited to announce that I’ll be presenting at the very first SQL Saturday event in Los Angeles!
The event is coming up fast but there is still time to register. It will be on June 10th, 2017 at the Microsoft Technology Center aka MTC, 13031 W. Jefferson Blvd Suite 200, Los Angeles, California, 90094.
Reserve your spot today! http://www.sqlsaturday.com/640/EventHome.aspx
@SQLSatLA
April is shaping up to be a fun, yet busy month. I have also been selected to present two topics at SQL Saturday #497 in Huntington Beach on April 2nd! I will be presenting on SQL Injections and Master Data Services. Here are descriptions of my presentations.
Right now, there are hackers all around the world trying to get into your web applications. How safe are you? By using a technique called SQL injections, hackers can wreak havoc with web applications by compromising security, manipulating data, hoarding system resources, retrieving sensitive information, and manipulate data database objects such as dropping databases!
During the demo, we will take on a couple of different roles. As a hacker we will walk through steps a hacker might take to compromise a web application in order to retrieve sensitive data such as credit card information, usernames, passwords, and social security numbers. Assuming the role of a developer, we will then show various prevention techniques and their effectiveness in preventing SQL injections.
Attend this session to learn how SQL injections work, identify if you are being attacked, and how to stop them.
Update: Thank you to everyone who attended my session. We had a full room! 🙂
As requested, you can download the presentation and scripts here.
As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft provides the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you can ensure that your MDS data is always up-to-date and accurate.
In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.
To register for this event and to find additional information, you can visit the SQL Saturday Huntington Beach page here:
http://www.sqlsaturday.com/497/EventHome.aspx
I recently moved from Minneapolis, Minnesota to San Diego, California. I’m certainly enjoying the warmer weather and am excited that I can check out SQL Saturday events in a new area. Along those lines, I am happy to announce that I have been accepted to present on Master Data Services at SQL Saturday #492 in Phoenix on April 16th! Below is a description of my presentation. I hope to see you at this event!
As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft provides the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you can ensure that your MDS data is always up-to-date and accurate.
In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.
To register for this event and to find additional information, you can visit the SQL Saturday Phoenix page here:
http://www.sqlsaturday.com/492/EventHome.aspx
On Saturday, November 22nd I will be at the Winnipeg SQL Saturday #350 event and will be giving a presentation on SQL Injections. The event will be held at the Red River Community College – downtown, 160 Princess St., Winnipeg, MB R3B 1K9, Canada. This is a great opportunity to learn more about SQL Server and I highly encourage everyone to attend.
Here is the topic I will be presenting on:
SQL Injections and How To Stop Them
SQL injections are a technique where malicious users can inject SQL commands into a SQL statement, through web page input. If left unprotected, SQL injections can cause havoc with web applications by compromising security, manipulating data, hoarding system resources, retrieving sensitive data, removing databases and database objects, or taking databases offline! This session will show how SQL injections work, identify if you are being attacked, and cover various prevention techniques and their effectiveness.
To register for this event and to find additional information, you can visit the SQL Saturday Winnipeg page here:
https://www.sqlsaturday.com/350/eventhome.aspx
SoCalSQL - Jeff Prom's SQL Server Blog 