redgate

SQL in the City Summit

  • New York October 12

SQL in the City Summit New York takes place at the Microsoft Conference Center in Times Square, and will focus on the concept of Compliant Database DevOps.

With world-class speakers, thought-provoking sessions, engaging panel discussions, workshops, keynotes, and time for networking, the Summit will support senior data professionals to deliver value quicker while keeping their data safe.

Key discussions:

  • Reduce manual tasks to free up teams to spend more time on development
  • Break down silos to enable Dev and Ops to work together to deliver value
  • Reduce the risk of downtime or compliance breaches going undetected
  • Processes and solutions that equally balance the need to release faster while ensuring data security

Who should attend?

The sessions are for C-level IT executives, directors, managers, and senior database engineers and administrators who work with the Microsoft Data Platform.

Professionals interested in learning about all things DevOps will learn what’s needed to effectively balance the demand for delivering software faster, while protecting and preserving business critical data.

From healthcare to finance, government to technology, today’s leaders should be embracing the benefits of DevOps and supporting the implementation of change across IT teams.

There is a limited number of tickets available for the Summit, to support effective networking and ensure a friendly and inspiring atmosphere for all.

You'll need to use an Access Code to register, please reach out to your regional Redgate Account Rep to obtain a code.

Session schedule

Time (BST)Session / Activity
9:00AM - 9:30AMRegistration and networking Tea, coffee, and pastries
1-to-1 Meetings with Account ManagersBook a meeting
9:30AM - 10:00AMOpening Keynote: The Four Keys To Unlocking DevOps
Kendra Little, Microsoft Data Platform MVP and Evangelist at Redgate
10:00AM - 11:00AMDevOps for the SQL Server Database
Brian Randell, Visual Studio ALM MVP

DevOps is hot, but the database is often the missing link. How do you manage the necessary changes needed to support your applications? How do you track these changes and follow a change from development to test to production? You need an effective DevOps plan.

In this session, you'll learn where SQL Server fits in the world of DevOps and how you can use tools to extend your infrastructure to make the database a first-class citizen, just like your source code. You'll see how to track changes with version control; create update packages; and deploy to multiple environments like development, test, UAT, and even production—all complete automated. You'll learn the process as well as see examples using the current versions of Team Foundation Server and SQL Change Automation. You’ll also learn how you’re a critical aspect to making SQL Server “DevOps” a success!

Show abstract

11:00AM - 11:20AMMorning break Networking & delicious bites
1-to-1 Meetings with Account ManagersBook a meeting
11:20AM - 12:00PMStrategies For Solving Compliance Challenges
Steve Jones, Microsoft Data Platform MVP and Editor at SQLServerCentral.com

According to Gartner, more than 80% of companies use sensitive data in dev and test. Hackers view non-production environments as a tempting target since they often have less rigorous security controls.

In this session, you’ll learn about the challenges that we, as technology professionals, face in our software development and administrative work. Learn compliant DevOps strategies for reducing your attack surface area by ensuring you know where sensitive data is located and avoid copying that data to non-production environments.

Show abstract

12:00PM - 12:45PMPanel discussion: Compliant Database DevOps Adoption
Host: Steve Jones, Microsoft Data Platform MVP and Editor at SQLServerCentral.com
Panelists
Bob Ward, Principle Architect at Microsoft
Brian Randell, Microsoft Visual Studio ALM MVP and Partner at MCW Technologies LLC
Derik Hammer, Microsoft Data Platform MVP and Senior Data Manager at Subway
Alex Chianuri, Founder at ISC Advisors
12:45PM - 1:30PMLunch
1-to-1 Meetings with Account ManagersBook a meeting
1:30PM - 2:15PMMaximize Availability and More with SQL Server Estate Monitoring
Grant Fritchey, Microsoft Data Platform MVP and Product Evangelist at Redgate

As estates grow in size and complexity, the process of manually monitoring them becomes untenable. Not only do manual checks take time, they are also prone to missing crucial elements that can leave your organization vulnerable and miss the historical context that can enable proactive data management. Without the right processes or tooling in place, your operations can be blind to the performance of your estate, and you may not realize a compliance breach until it’s too late. In this session learn how to monitor your SQL Server estate to maintain compliance and ensure availability.

Show abstract

2:15PM - 2:30PMAfternoon break Networking & delicious bites
1-to-1 Meetings with Account ManagersBook a meeting
2:30PM - 3:45PMWorkshop 1: Technical Approach To Implementing Compliant Database DevOps
Brian McRae Pre-Sales Engineer, Redgate

Your business depends on minimizing the risk to your most valuable asset: your data. To achieve this, you need processes that guarantee your data stays protected and changes to your database are flawless, every time, without slowing things down. But how do you increase the speed of your releases and continue delivering value to your customers while remaining compliant? By extending DevOps practices to SQL Server databases, high performing organizations are protecting business-critical data, while also improving the efficiency and quality of software delivery. In this workshop we will cover:

  • The key benefits of extending DevOps practices to the database
  • The current state of Database DevOps
  • How to benchmark and improve your Database DevOps practices against your competitors
  • Demo of how Redgate’s solution can help with Compliant Database DevOps

Show abstract

Workshop 2: Capturing the Value of DevOps
Kendra Little, Microsoft Data Platform MVP and Evangelist at Redgate

How do we measure the value of DevOps? It varies, based on our perspective. In this workshop we will examine the four pillars of DevOps through three lenses: the viewpoint of the CEO, the CIO, and the IT Manager or Team Leader. We'll discuss the values and concerns that come naturally to each of these roles regarding standardization, automation, protecting data, and monitoring. You'll leave the workshop with a new understanding of the business advantages of DevOps, and next steps to take to bring the benefits of DevOps to your customers.

Show abstract

3:45PM - 4:45PMSQL Server 2017 and Beyond
Bob Ward, Principal Architect, Microsoft Data Group

SQL Server 2017 has brought to market a new modern data platform including support for Linux, Docker Containers and rich features in intelligent performance, security, HADR, machine learning, and graph database. Come learn about what makes SQL Server the data platform of choice for enterprise workloads and developers including DevOps. We will discuss how SQL Server enables GDPR compliance and discuss the roadmap for the future of SQL Server.

Show abstract

4:45PM - 5:00PMClosing remarks
5:00PMRedgate Happy Hour at Brazen Tavern (W 44th & 9th) - Networking, appetizers and drinks

Please note: The session schedule may be subject to change, check this page for updates.

Speakers

Steve Jones

Data Platform MVP, Editor at sqlservercentral.com

Steve is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001.

Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

@way0utwest

Kendra Little

Microsoft Data Platform MPV, Evangelist at Redgate Software, littlekendra.com

Kendra is a Microsoft Certified Master and a Microsoft MVP. She has taught developers and DBAs around the world to write fast, reliable code for SQL Server.

Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to manage and deploy changes to performance critical databases at Microsoft Corporation, working with systems from internal source control databases to customer-facing very large databases (VLDBs). Since then, Kendra has worked internationally as a trainer and consultant, specializing in performance tuning and practical code patterns for SQL Server. She joined Redgate as a Product Evangelist in 2018.

@Kendra_Little

Grant Fritchey

Data Platform MVP, Product Evangelist at Redgate, scarydba.com

Grant is a SQL Server MVP with over 20 years experience in IT including time spent in support and development.

Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant volunteers at PASS with the Editorial Committee and is president of the Southern New England SQL Server Users Group (SNESSUG). He has authored books for Apress and Simple-Talk, and joined Redgate as a Product Evangelist in January 2011.

@GFritchey

Bob Ward

Principle Architect at Microsoft

Bob is a Principal Architect for the Microsoft SQL Server Data Services Group, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 25 years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2017 including Linux. He has worked in customer support as a principal escalation engineer and Chief Technology Officer (CTO), interacting with some of the largest SQL Server deployments in the world. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as SQL PASS Summit, SQLBits, SQLIntersection, and Microsoft Ignite.

@bobwardms

Brian A. Randell

Visual Studio ALM MVP and Partner at MCW Technologies LLC

Brian is a partner with MCW Technologies, LLC. For more than 30 years, he has been building software solutions. He educates teams on Microsoft technologies via writing and training—both in-person and on demand. He’s also a consultant for worldwide companies of all sizes including Fortune 100 companies like Microsoft. Brian is a passionate software craftsman who still enjoys coding as he helps teams to improve their processes from idea to shipping to production management and monitoring. He's currently a 15 year Microsoft MVP and co-author of “Professional Application Lifecycle Management with Visual Studio 2013” from Wrox Publishing.

@brianrandell

Derik Hammer

Microsoft Data Platform MVP and Senior Data Manager at Subway

Derik is a Microsoft Data Platform MVP who builds data solutions from front-line OLTP systems to MPP data warehouses and all the integrations in between. He is passionate about cloud computing, performance, and automation.

Derik is currently a Senior Data Manager working for Subway, leading a team of solution architects in a hybrid environment blending Microsoft Azure, Amazon Web Services, and on-premises resources.

@SQLHammer

Alex Chianuri

Founder at ISC Advisors

Alex is a data practitioner who has worked closely with all versions of SQL Server going back to v6.5. For the past 20 years Alex has been actively building business intelligence applications at financial services firms in New York. Over the course of his career Alex has played various roles, including architect, developer, head of data management, and CTO at an e-payments company.

In 2013 Alex founded ISC Advisors, a data services firm. There, he currently leads development of Plexifact, a SQL Server-based data integration and agile data warehousing platform. Alex is responsible for client delivery of custom agile data warehousing solutions using Plexifact.

Brian McRae

Pre-Sales Engineer at Redgate

Although relatively new to Redgate, Brian is an experienced Pre-Sales Engineer with more than 20 years of technology experience as a developer, architect, and DBA. During that time, he worked in dozens of industries with hundreds of companies, from the Fortune 50 to venture-backed startups.

His breadth of experience and technical expertise allows him to understand the bigger picture implications of technology within the enterprise, and he specializes in helping clients architect Redgate solutions that are both technically sound and commercially viable.

More speakers will be announced soon

Venue

Microsoft Conference Center is up on the 6th floor of Microsoft’s office at 11 Times Square, between 41st & 42nd Streets on 8th Ave. This modern facility has a bright atrium, with incredible floor to ceiling views, and comfortable high-tech conference rooms, located in the heart of Times Square.

Subway

The New York MTC is conveniently located opposite the Port Authority Bus Terminal, which has direct underground passageways connecting the terminal with the NYC Subway lines (A, C, E, N, Q, R, W, 1, 2, 3, and 7), as well as the shuttle to Grand Central Terminal (S train).

More travel info and directions to the venue

Parking

  • 350 West 42nd Street between 8th and 9th Avenues: Entry on 42nd Street
  • 249 West 43rd Street between 7th and 8th Avenues: Entry on 43rd Street
  • 851 8th Avenue between West 51st and West 52 Streets: Entry on 8th Avenue

FAQ

How much is it?

Tickets for SQL in the City Summit New York are free. However, you’ll need to obtain an access code from someone at Redgate in order to register. If you have an Account Manager at Redgate, reach out to them via email to get an access code.

Why should I attend?

Discover why DevOps has been adopted by many successful organizations across various industries, and understand how your organization could benefit and how best to implement this positive shift in your IT team.

The fantastic line-up of presenters will share their knowledge and experience of how businesses can benefit from a DevOps approach to database development, while staying compliant and minimizing risk.

Refreshments will be provided throughout the day - pastries on arrival, morning and afternoon break-time snacks, and of course a delicious lunch.

You'll also have the opportunity to network with hundreds of other like-minded professionals.

Can I cancel my ticket after I've obtained it?

If you are unable to attend we ask that you cancel your ticket via Eventbrite as soon as possible, so that someone on the wait-list can take your place. If you’d prefer to send a colleague in your place, just email redgateevents@red-gate.com to let us know who'll be attending instead, so we can get things organized.

Can I order a special meal?

Because we’re putting this event on at no cost to you our catering options are limited - vegetarians and common intolerances will be covered as standard. When you register, please let us know about any dietary requirements/allergies. If you have a very special diet you might want to consider bringing your own lunch.

Where should I stay the night before?

There are a range of hotels and serviced apartments close to the venue. We don’t have a special rate with any of them.

How do I get there?

The subway and bus terminal are very close by, or you can take a taxi, or even drive - details are on our venue tab.

Do I have to bring my printed ticket to the event?

No, but you might like to make a note of the venue and time details, so you know when and where you need to be!

Can I update my registration information?

Yes - just log back in to Eventbrite and make any amendments. Or if it's easier, email us at redgateevents@red-gate.com.

Is this the only location that you're hosting SQL in the City Summit?

We’re hosting three events in October this year. Check out the locations of the other Summits and tell a colleague who might be located near one of those events.

What should I bring with me?

Depending on how you prefer to learn, you might like to bring a device to make notes during the sessions and workshop. We'll provide you with a notepad and pen.

What should I wear?

Wear something you feel comfortable in.

How can I contact the organizer with any questions?

If you have any questions about the event, please email Annabel and the Events team at redgateevents@red-gate.com

Hear from industry experts

Network with like-minded professionals

Get inspired to implement change

Discover the benefits of DevOps