Welcome to SQLSaturday in Albany, NY
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on July 25, 2015 at SUNY Albany, 1400 Washington Ave, Albany, NY 12222. Admittance to this event is free, but we do charge a fee of $5.00 so that we can provide a great lunch! Please register soon as seating is limited, and let friends and colleagues know about the event.
The following is a map indicating the location of the SUNY Albany uptown campus and is centered on the State Purple parking lot. Signs will direct you from there to the lecture centers & fountain area, where all events will be taking place.
Google Map: State Purple Parking Lot
All events will be held in the Lecture Centers, which are located at the center of campus encircling the large tower & fountain. A Google map of SUNY Albany's campus can be found here, as well as a printable PDF version, as well.
The State Purple lot is the closest and most convenient place to park on campus, with easy access to the center of campus. All lots allow for free parking on the weekend, so you may park elsewhere, if desired. We will be using Lecture Centers (LCs) 20 - 25 for all sessions, and the concourse area outside of them for sponsors & registration.
SQL Server Security: Protecting the Data
Need a Place to Stay?
The Hilton Garden Inn @ SUNY Albany has reserved a block of rooms for attendees at a discounted rate. The hotel is located at:
1389 Washington Ave, Albany, NY 12206 and you can reserve a room online or by calling them at (518) 453-1300. The block is reserved under Professional Association of SQL Server.
2 Full-Day Precon Sessions!
We are Excited to announce 2 all-day precon events on Friday, July 24th at the Hilton Garden Inn in Albany, NY: "SQL Server Security: Protecting the Data", by Thomas Grohser, and "Practical Self-Service BI with PowerPivot for Excel", by William Pearson:
Practical Self-Service BI with PowerPivot for Excel
Presenter: William is a six-time SQL Server MVP and Business Intelligence Architect with many years of practical experience, as well as speaking experience. His background as a CPA, Internal Auditor, and Management Accountant allow him to provide unique insight into information relationships, data reliability, security, and more.
Course: The focus of the course is to help those new to PowerPivot to become familiar with the assembly of data from diverse sources into models that deliver business intelligence upon demand. Participants will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.
Logistics: Breakfast and lunch will be provided. The Hilton Garden Inn is located at 1389 Washington Ave, Albany, NY 12206. This is directly across the street from the campus of SUNY Albany, where the SQL Saturday will be held. The precon will run from 8:00am until 5:00pm. Breakfast is served at 8:00, and everything will begin by 8:30.
In my 25+ years as an IT professional I spent the majority of the time exploring the deeper inner workings of SQL Server while working for entertainment, pharmaceutical and financial companies. Focusing to architect, plan and provide reliable, highly available, secure and scalable infrastructures.
Eight years ago I decided it's time to share the findings with the community. Since then I have given more than a hundred presentations at local user groups, SQL Saturday’s, PASS Summit’s, SQL Connection, TechEd’s, and SQL Rally’s all around the globe.
This PreCon will cover all aspects of security around SQL Server. Starting with basic security concepts, physical security, operating system, SQL Server Instance level security including logins and certificates and database level security all the way to object security and data encryption. Everything will be covered in both PowerPoint and actual demos that all attendees will be able to take home.
Basic security concepts and technology to get everyone in the room onto the same page. It will also define what the enemies are we are protecting our data from.
Ensuring no one just walks out the front door with all your data.
Making sure the operating system SQL Server runs on is secure is a very good starting point in an end to end security strategy to protect the data. This module will also cover the basics of Active Directory that is needed to manage SQL Sever
SQL Server Instance Level Security
A big module because it covers large sub topics like logins, instance level permissions, server roles and the communication between SQL Server and the clients and it all starts with choosing the right service account to install SQL Server.
Database Level Security
Mapping the instance level security to the database users, roles and database level permissions is covered in this module as well as the introduction to the GRANT/REVOKE/DENY concept
Object Level Security
We finally arrive at the data and will learn how to use the various permissions and the hierarchy between schemas, tables, views and stored procedures to secure the data on an object level and even deeper on a per column level. We will also cover the concept of row level security
Keys and Certificates
Are the basis for data encryption, this module will show what is available and how to manage them
How to encrypt (and decrypt) data in the database in a secure way using the keys and certificates we created in the previous module
Transparent Database Encryption (TDE)
Encrypting the whole database and as a side effect the backups is the primary goal of this module but it will also show how TDE can be used to control which servers can restore a database.
Configuring security of a linked server can easily lead to a mayor backdoor. This module will explain the pitfalls, show the right way of doing it and will also explain how Active Directory constraint delegation can help making this easier.
Securing Data from the DBA
More and more companies have the requirement to prevent the DBA’s to access the actual data. This module will show how easy it is to manage SQL Server without having sysadmin privileges.