Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 23
Cloud adoption of database-related services continues to accelerate, but the choices for which service to select – IaaS, DBaaS, and PaaS – all impact the features available to your applications. Selecting a service is a critical first step in the migration process, and selecting poorly can lead to cost overruns and significant time spent going down the wrong path. The questions you do not ask or consider prior to a migration can make or break your cloud experience. The most important ten questions to answer, such as your availability requirements, database-level dependencies, migration strategies, and other critical concerns, will all be discussed so that you are ready to move to the cloud with confidence to your platform of choice.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 1:00 PM - 2:15 PM

Room: Room C: Cloud & Infrastructure Presented by Involta

Azure Data Studio (ADS) provides a cross-platform tool for SQL Server.  With ADS, you can manage connections, develop and execute code, and build and run Jupyter Notebooks.  Notebooks allow formatted text to be combined with executable code and can be render in a browser, making them ideal for wiki pages and runbooks.  With the November 2019 release, both T-SQL and PowerShell code can be executed in a notebook.  This allows docker commands to build and manage SQL Server containers from within a notebook.  Join me for this introduction to ADS and SQL Server containers.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 01

Time: 11:40 AM - 12:55 PM

Room: Room B: DevOps Presented by KingFisher

Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.

This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.

We will discuss

- the challenges of implementing DevOps
- setting up a database solution project
- getting started with source control
- testing your database releases using tSQLt
- setting up your Azure Devops pipelines

After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.

If you want to see a session about using Azure DevOps with SQL Server, co-presented by a Microsoft MVP and somebody who is Microsoft certified for both, this is the session for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 01

Time: 9:00 AM - 10:15 AM

Room: Room B: DevOps Presented by KingFisher

Azure Synapse provides a complete platform to ingest and process data at scale in the cloud. In this workshop we will be learning and applying its features to all stages of data processing and understanding best practices and pitfalls. From ingesting to data lakes to transform data in big data services to apply machine learning models, including data remodeling, this workshop will guide to through a full implementation of Azure Synapse all the way to presentation and reporting.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: August 01

Time: 11:40 AM - 12:55 PM

Room: Room A: BI Presented by Microsoft

Your query returns the correct results, but even with supporting indexes it seems slow. Can it go any faster? In this session, we focus on T-SQL query antipatterns – commonly used techniques that are unintentionally counter-productive. Through an interactive story of user requests, we identify several antipatterns, examine what makes them troublesome, and show alternative methods to improve performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 01

Time: 2:20 PM - 3:35 PM

Room: Room D: Tools & Techniques Presented by Redgate

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: August 01

Time: 10:20 AM - 11:35 AM

Room: Room A

The skills that make you a brilliant technologist don't always map over when you want to take the next step into a leadership position. In this session, we will look at key skills to develop in order to prepare for the next step in your IT career.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 01

Time: 1:00 PM - 2:15 PM

Room: Room B: DevOps Presented by KingFisher

SQL Server has a very good store of data about your SQL Server operations that you can gather for trending. These include index usage, index operational, disk space, database space, etc. In this session you'll first learn the basics of what this data is and what it can be used for. Second you will see the solution I have developed to gather this information, as well as how you can modify it to get more data very simply. And last you will see some data I've gathered and reports that show you what your environment is like. You will learn how simple it is to get a wealth of information using my favorite tool (PowerShell) and hopefully it will become yours. If you are interested in operational insights into what is happening in your database and how simple it is to gather this data, this session is for you. You will get all demo scripts. This session is demo heavy so come hungry.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 10:20 AM - 11:35 AM

Room: Room C: Cloud & Infrastructure Presented by Involta

You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks?
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered.
Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 10:20 AM - 11:35 AM

Room: Room B: DevOps Presented by KingFisher

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any area that may be impacting performance or security.  If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment.  During this session we will discuss when assessments are useful, what should be included in the assessment as well as how to interpret the results.  We will use a SQL script that will capture all the data needed.  This script will more than 88 data points, including fragmentation of indexes, performance counter values, server and database security information, queries that consume the most CPU time including execution plans as well as many other data points. This session will also cover how to document your findings and recommendations.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 01

Time: 11:40 AM - 12:55 PM

Room: Room C: Cloud & Infrastructure Presented by Involta

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important.  Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening.  This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive.  We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers.  Additionally, some suggestions as to where to find more information will be provided.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 9:00 AM - 10:15 AM

Room: Room C: Cloud & Infrastructure Presented by Involta

For anyone new to Power BI, we'll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we're through we'll have several BI components available to share via the Cloud!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: August 01

Time: 2:20 PM - 3:35 PM

Room: Room A: BI Presented by Microsoft

In this session, we will look at the new Query Store feature in SQL Server 2016, 2017, and 2019.  Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Plan Correction capabilities.  Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session, we will walk through the features of the Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 10:20 AM - 11:35 AM

Room: Room D: Tools & Techniques Presented by Redgate

Extended Events have been available since 2008. At the time, there was a steep learning curve, and many folks decided to wait for a GUI. Even though a GUI was provided in 2012, many still depend on Profiler and Trace to understand what’s going on under the hood of SQL Server. 
During this session, you will learn how to make the transition to Extended Events. You’ll find out that it’s easier than you think!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 01

Time: 11:40 AM - 12:55 PM

Room: Room D: Tools & Techniques Presented by Redgate

Lately it seems more sysadmins are embracing Windows Server Core as the OS of choice for virtualized servers. SQL Server is (almost) perfectly happy to run in this environment but how do you manage on an OS without a full desktop.

We'll cover what versions and features are supported, how to install sql server via a configuration file,  and what common activities are changed when you move into a Core environment.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 3:40 PM - 4:55 PM

Room: Room C: Cloud & Infrastructure Presented by Involta

One in four Americans suffers from a mental health challenge each year. In the tech community, this number rises to 42%. The stigma associated with discussions around mental health, as well as how it can negatively impact your work and home life, make people reluctant to discuss the topic. Now is the time to start discussing mental health in tech and how to take advantage of the opportunity to safeguard our most precious resource: people. We'll discuss how mental health affects job quality, including sharing examples from my professional life. We'll discuss the four primary workplace factors which play a pivotal role in mental health challenges in the tech community. I'll provide tips on what is best to say and not say to people you know whose lives are being affected by their mental health. Lastly, we'll cover how to make your workplace a safe place where mental health can be talked about and how to encourage your company to offer resources to help maintain everyone's mental health.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 01

Time: 2:20 PM - 3:35 PM

Room: Room B: DevOps Presented by KingFisher

New to SQL Server 2016 (okay, it's a few years old already, but it still feels new) is Row Level Security, which allows database developers and architects to effectively lock down tables, giving users access to a defined subset of data in the table.  It sounds easy enough, but there are a number of design considerations and pitfalls to be aware of.  This session will work through a few demos to implement RLS and dive into those pitfalls that need to be avoided.  For anyone considering implementing Row Level Security or have tried but have run into issues, this should be a session you want to attend.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 01

Time: 3:40 PM - 4:55 PM

Room: Room A: BI Presented by Microsoft

As the SharePoint Intern for Smithsonian Institution’s Office of the Chief Information Officer, I created an interactive organization chart in SharePoint so users can find information on all the Smithsonian units in one place. I will go in depth on how I used SharePoint web parts, HTML/CSS, and JavaScript to create an image map with modals to display each unit’s information and the obstacles I faced with the customizations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: August 01

Time: 1:00 PM - 2:15 PM

Room: Room A: BI Presented by Microsoft

SQL Server 2019 is the latest release only 7 or 8 months old. It is time now to learn about some awesome features of this release. Like previous versions, SQL Server 2019 comes with a plethora of new features as well as with enhancements to the existing ones. 
In this session, I will discuss and show demos of Intelligent Query Processing family of features. IQP has taken the performance of SQL Server to the next level, never seen or imagined before. We will see in action how with minimum or no changes from DBA or Developer, your query performance improves automagically just by going to compatibility level 150 (SQL Server 2019).
You will leave this session with a solid understanding of some of the best new features of SQL Server 2019 and hopefully you will be motivated to try them yourself.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: August 01

Time: 9:00 AM - 10:15 AM

Room: Room D: Tools & Techniques Presented by Redgate

As a DBA for a financial clearing house and we are audited by multiple government regulators to 
make sure our database instances are configured to standards. When configuring an instance we have a checklist of configurations which must adhere to those standards. Then those configurations must be monitored to make sure they remain set according to those standards. This is time consuming, and labor intensive. If only there was a quick way to template those standards so that they could easily be applied and enforced to database instances. Well one way that can be done with SQL Server Policies !! SQL Server Policies can be used to both configure and enforce standards within a database instance. SQL Server Policies have been around since SQL Server 2008 , but have not gained much traction in the industry. SQL Server Policies been the "Rodney Dangerfield" of SQL Server features getting no respect. I'll show you how I used this feature to configure and enforce standards.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: August 01

Time: 2:20 PM - 3:35 PM

Room: Room C: Cloud & Infrastructure Presented by Involta

Sessions Found: 23
Back to Top cage-aids
cage-aids
cage-aids
cage-aids