sqlsathistory

Nr: 899

Back to Main list

SQLSaturday #899 - Birmingham 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Hilary Wilkie	BI Platform Architecture, Development Administration	User Experience Brilliance in Power BI Dashboards
08:30:00	Kevin Wilkie	Cloud Application Development Deployment	Azure Data Factory V2
08:30:00	Rob Volk	Application Database Development	That's So Metadata: Discover Your Database From The Inside
09:40:00	Thomas Norman	Application Database Development	Database Project Makes Deployment Consistent
09:40:00	Mike Robbins	Enterprise Database Administration Deployment	PowerShell + SQL Server = Better Together
09:40:00	Jared Rhodes	Cloud Application Development Deployment	AI on the Edge
10:50:00	Ed Watson	BI Platform Architecture, Development Administration	The Psychology of Better Power BI Reporting
10:50:00	Robert Cain	Enterprise Database Administration Deployment	PowerShell Core for Linux
10:50:00	Rie Irish	Enterprise Database Administration Deployment	How to Build Your Disaster Recovery Plan
12:40:00	Sven Aelterman	Application Database Development	The New Tool in Your Kit: Azure Data Studio
12:40:00	Ken Muse	Cloud Application Development Deployment	The Art of Data DevOps with SSDT
12:40:00	Nathan Boster	Application Database Development	Turbo-charging SSMS for Beginners
13:50:00	William Assaf	Professional Development	Certification Exams Inside Out
13:50:00	Dustin Dorsey	Application Database Development	Exploring the latest T-SQL enhancements
13:50:00	Paco Gonzalez	BI Platform Architecture, Development Administration	Power BI Architecture
15:00:00	Peter Doyle	Application Database Development	Become a T-SQL Pivoting Ninja in 60 Minutes Or Less
15:00:00	Kevin Boles	Application Database Development	Recent SSMS Performance Tuning Enhancements
15:00:00	Christine Assaf	Professional Development	Mastering your Resume Interview: Tips to Get Hired

SessionID: 93698

User Experience Brilliance in Power BI Dashboards

Back to calendar

Event Date: 27-07-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Hilary Wilkie

Title: User Experience Brilliance in Power BI Dashboards

Abstract:

User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway?

Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that give the best user experience? In this session we will explore in a hands-on exercise what UX and Design thinking is, how to apply the methodologies to our daily work and then how we could apply it to BI to make kick ass dashboards and reporting for our internal and external customers.

SessionID: 93768

Azure Data Factory V2

Back to calendar

Event Date: 27-07-2019 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Kevin Wilkie

Title: Azure Data Factory V2

Abstract:

Moving data around in On-Prem databases is easy.

Moving data around when involving Azure - may be not. Especially if you don't have a VM or an On-Prem server to move things around on.

We'll look at moving data around from On-Prem to Azure, moving files to Azure, and moving data between Azure databases.

SessionID: 94665

That's So Metadata: Discover Your Database From The Inside

Back to calendar

Event Date: 27-07-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Rob Volk

Title: That's So Metadata: Discover Your Database From The Inside

Abstract:

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

• Document your database schema objects such as procedures, functions, tables, columns and indexes
• Investigate performance and look for bottlenecks and tuning opportunities
• Discover metadata to administer your databases backups, index maintenance, and security
• Apply your own metadata using extended properties

We will also cover the official Microsoft documentation on these features and other resources on how to use them.

SessionID: 93844

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 27-07-2019 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.

SessionID: 93883

PowerShell + SQL Server = Better Together

Back to calendar

Event Date: 27-07-2019 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Robbins

Title: PowerShell + SQL Server = Better Together

Abstract:

As a SQL Server professional, are you able to make a rhyme or reason to this thing called PowerShell? Need to accomplish something? Do you use Windows PowerShell or PowerShell Core? How will you interface with PowerShell? With the PowerShell console, ISE, VSCode, SAPIEN PowerShell Studio, or something else? Will you use Cmdlets from one of the various SQL related PowerShell modules? If so, which one? SQLPS, SQLServer, DBATools, etc. Or maybe you should use the SQL PS provider? What about SMO? Or write your own custom .NET code that can be executed with PowerShell? With it being so difficult to determine how to go about running something in PowerShell, it’s no wonder that most people resort to searching the Internet to figure it out. The sad thing is that most of the PowerShell code you’ll find on the Internet is less than optimal to say the least. I'll demonstrate how and when to use different approaches along with adhering to the community’s best practices for writing PowerShell code.

SessionID: 94346

AI on the Edge

Back to calendar

Event Date: 27-07-2019 - Session time: 09:40:00 - Track: Cloud Application Development Deployment

Speaker: Jared Rhodes

Title: AI on the Edge

Abstract:

The next evolution in cloud computing is a smarter application not in the cloud. As the cloud has continued to evolve, the applications that utilize it have had more and more capabilities of the cloud. This presentation will show how to push logic and machine learning from the cloud to an edge application. Afterward, creating edge applications which utilize the intelligence of the cloud should become effortless.

SessionID: 94676

The Psychology of Better Power BI Reporting

Back to calendar

Event Date: 27-07-2019 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: The Psychology of Better Power BI Reporting

Abstract:

In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.

SessionID: 94893

PowerShell Core for Linux

Back to calendar

Event Date: 27-07-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Cain

Title: PowerShell Core for Linux

Abstract:

With the advent of SQL Server for Linux, you need a tool you can use to manage it. Sure, you could try to learn bash, python, or some other tool, but wouldn't it be nice to be able to use a scripting language you're familiar with? Or maybe you are a long time Linux admin, now having to work with all this new Microsoft technology. Wouldn't it be great to leverage tools that make your life even easier?

In this session you'll learn all about PowerShell Core for Linux. You'll see just how quick and easy it is to install PowerShell Core, then interact with it from the terminal. But wait, there's more! You'll want a good editor to compose your PowerShell Core scripts in, and that's where VSCode comes in. You'll see how easy it is to install VSCode, then work with your PowerShell Core project within it.

We'll wrap up the session showing how to install SQL Server in a Docker Container, all using PowerShell Core!

SessionID: 95980

How to Build Your Disaster Recovery Plan

Back to calendar

Event Date: 27-07-2019 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Rie Irish

Title: How to Build Your Disaster Recovery Plan

Abstract:

So your boss asked for a copy of your DR plan. Once you've wiped that deer-in-the-headlights look off your face, you realize "We've got database backups," isn't exactly a plan. You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations. We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.

SessionID: 93696

The New Tool in Your Kit: Azure Data Studio

Back to calendar

Event Date: 27-07-2019 - Session time: 12:40:00 - Track: Application Database Development

Speaker: Sven Aelterman

Title: The New Tool in Your Kit: Azure Data Studio

Abstract:

Azure Data Studio is a newer tool in the database developer and DBA's toolkit. It's a cross-platform and extensible application for connecting to on-premises and cloud data. Does it replace SSMS? How is it different? Can it really check if my Diet Coke needs replenishing? Come and find out in this demo-driven session, that will hopefully have you convinced to install Azure Data Studio before 60 minutes are up.

SessionID: 93970

The Art of Data DevOps with SSDT

Back to calendar

Event Date: 27-07-2019 - Session time: 12:40:00 - Track: Cloud Application Development Deployment

Speaker: Ken Muse

Title: The Art of Data DevOps with SSDT

Abstract:

The heart of software systems today is data storage. As software development cycles get shorter, database development is being forced adapt the same pace. It’s increasingly important to be able to combine Agile practices with SQL Server database development. Learn how to take advantage of SQL Server Data Tools and Azure DevOps to enable rapid, iterative development.

SessionID: 94586

Turbo-charging SSMS for Beginners

Back to calendar

Event Date: 27-07-2019 - Session time: 12:40:00 - Track: Application Database Development

Speaker: Nathan Boster

Title: Turbo-charging SSMS for Beginners

Abstract:

This session is for SQL Server Management Studio (SSMS) rookies who want to work like veterans. Nathan will share lots of "tips and tricks" he's learned in his 15 years of SQL Server administration and development.

SessionID: 94037

Certification Exams Inside Out

Back to calendar

Event Date: 27-07-2019 - Session time: 13:50:00 - Track: Professional Development

Speaker: William Assaf

Title: Certification Exams Inside Out

Abstract:

Preparing for Microsoft certification? Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation from an item writer's viewpoint, what rules item writers must follow, and why questions sometimes have strange phrasing. For any technical skillset pursuing certification, we'll review non-technical sample questions and walk through the process of using information at your disposal. You'll better understand how to deconstruct the problem statement. We'll leave time for QA with a veteran of the Microsoft certification exam writing process.

SessionID: 94689

Exploring the latest T-SQL enhancements

Back to calendar

Event Date: 27-07-2019 - Session time: 13:50:00 - Track: Application Database Development

Speaker: Dustin Dorsey

Title: Exploring the latest T-SQL enhancements

Abstract:

With the most recent release of SQL Server 2017 and the upcoming release of SQL Server 2019, there are several enhancements that were introduced for the T-SQL language. This includes new string functions, bulk access options and approximate query processing among others that address several challenges that SQL developers have to confront.

In this demo heavy session, we will go over several of the new features, provide a demonstration of how you can use them, and share any considerations that you may need to consider before doing so. This session is intended for anyone interested in what’s new in the T-SQL language and will focus primarily just on enhancements to traditional T-SQL for the database engine.

SessionID: 96279

Power BI Architecture

Back to calendar

Event Date: 27-07-2019 - Session time: 13:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paco Gonzalez

Title: Power BI Architecture

Abstract:

Having the right architecture is key to the adoption of Power BI, and to make the most of your business intelligence solution. This session guides you through different Power BI architectures, such as Direct Query, Import, Connect Live, Composite Models, and Embedded. We will analyze different techniques in data refresh, incremental extraction, integration and collaboration to provide a quick overview of the different approaches available.

SessionID: 93655

Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Back to calendar

Event Date: 27-07-2019 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Peter Doyle

Title: Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Abstract:

Stop wasting time using Excel Pivot Tables. Create them in SQL with ease.

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible

SessionID: 94285

Recent SSMS Performance Tuning Enhancements

Back to calendar

Event Date: 27-07-2019 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Recent SSMS Performance Tuning Enhancements

Abstract:

SQL Server Management Studio has for some time been undergoing very rapid changes and improvements! Many of the improvements are focused on helping improve SSMS's ability to help with performance tuning problems. The SQL Server engine itself has had many such improvements too. Join me for a demo-filled run down of some of the highlights of these changes!

SessionID: 94379

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 27-07-2019 - Session time: 15:00:00 - Track: Professional Development

Speaker: Christine Assaf

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract:

Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.

This site is open source. Improve this page.