Event Location:
LSU College of Business - Business Education Complex
Nicholson Drive Ext
Baton Rouge, Louisiana
Abstract:
So you think you have the ultimate Data Warehouse...well think again. The landscape or should I say the data lake is changing constantly. We are getting data from all over the place. How do we make it available and relevant for the consumers of a data warehouse. Is Kimbell obsolete now, what about unstructured data, how about the gazillioin rows of click data, etc. So the data and BI architects are all on suicide watch. Well its not really that bad. Microsoft has woken up and seen all that is going and has brought functionality to SQL Server to solve some of these issues. This presentation provides an overview of technologies such as Polybase, Temoporal Tables, Columnstore Index, In memory tables, JSON support, etc. that can be utilized to build the data warehouse of the future.
Speaker(s): Stan Geiger,
Abstract:
Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.” As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system. This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these: * Performance testing * Patterns for validating execution results at runtime * Validating package metadata before execution * Design time versus runtime testing * Making a graceful exit: testing for error
Speaker(s): Tim Mitchell,
Abstract:
Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious!
Speaker(s): Jennifer McCown,
Abstract:
Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.
Speaker(s): Jamey Johnston,
Abstract:
The key to finding creative solutions is not just creativity, although that will certainly help. The answer rests in our ability to identify options, research them, and then put things together in a way that works. Having a process to work through can take the anxiety out of problem solving and make decisions easier. That’s what this session is all about. Participants will learn how to: Apply problem solving steps and tools/Analyze information to clearly describe problems/Identify appropriate solutions/ Think creatively and be a contributing member of a problem solving team/ Select the best approach for making decisions/ Create a plan for implementing, evaluating, and following up on decisions/ Avoid common decision-making mistakes
Speaker(s): Mechelle Roberthon,
Abstract:
Whether you plan to run your own consulting business, be a freelancer, or be a healthy part of a software or design team you will need to understand the importance of engaging both your left- and right-brain in the future. Sure, you are smart and you have a good left-brain, but raw processing power, reasoning, and logic are not enough to compete, provide, or even survive in the coming "Conceptual Age." Just as manufacturing automation put much of the "human back" out of business in the Industrial Age, certain forces threaten to put the "human brain" out of business in the age to come. This talk will prepare you for its arrival and insulate you for its duration. Learn how to recognize and utilize the value of well-rounded thinking as you progress throughout your career.
Speaker(s): Calvin Fabre,
Abstract:
There are lots of things to consider when configuring systems in your on-premises datacenters with Desired State Configuration depending on what the state of your current environment is, whether or not DSC will be configured to apply and monitor or apply and autocorrect configuration drift, and whether or not you’ll be using push or pull configuration mode. During this session, PowerShell MVP Mike F Robbins will share his lessons learned while configuring both physical and virtual production systems in multiple datacenters with DSC during a recent hardware and software refresh cycle. We’ll briefly discuss writing configurations, applying configurations via push and pull mode, and we’ll have a quick discussion about DSC resources. You’ll leave this session with the basic concepts of the end-to-end process. Prior experience with PowerShell is recommended.
Speaker(s): Mike Robbins,
Abstract:
Interested in PowerShell but not sure how to get started? Already have some experience but still having trouble with the basic concepts? This session is for you! Learn to easily figure out what the commands are and how to use those commands without searching the Internet. Extend PowerShell’s functionality to manage products like SQL Server. During this presentation, PowerShell MVP Mike F Robbins will demonstrate several of the core PowerShell cmdlets along with writing one-liners and basics scripts. We’ll discuss how to prevent resume generating events when making changes with PowerShell. Learn what objects, properties, and methods are along with how they’re used in PowerShell. Not a developer? PowerShell is one of those technologies that you can be extremely effective with whether you’re a developer or an IT Pro.
Speaker(s): Mike Robbins,
Abstract:
We are quickly moving towards becoming a mobile first world and you don't want to be left behind. Leverage your vast .NET knowledge and learn how to build mobile apps on the .NET stack with Xamarin. Recently acquired by Microsoft, Xamarin allows you to build native, fast, beautiful cross-platform mobile applications in C# (or even F#). In this session we will go over the basics of creating a mobile application using Xamarin.Forms, utilizing C# to build a real-world application using a single shared codebase. We will also cover the latest from Build and Evolve, looking at the latest changes from Microsoft/Xamarin and what they will mean for you. This session expects that you have an understanding of the C# language and .NET development.
Speaker(s): James Alt,
Abstract:
Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables. This session is all about when and how to apply in-memory tables in a production environment. After this session you will 1. Understand what in-memory tables are and how to create and maintain them including their limitations 2. Be able to identify performance gains over equivalent disk back tables 3. Comprehend the new data monitoring needed for in-memory table
Speaker(s): Mike Byrd,
Abstract:
Did I really do that? If you didn't, you probably will. And even if you don't ever, it's a good bet that you will still have to deal with others' legacies of Anti-Patterns. Decades of practice by thousands of software and database developers around the world have produced a large corpus of recognized best practices, Anti-Patterns are the antithesis of best practice - they are recognized as approaches to be avoided. SQL databases including SQL Server are no exception. A number of SQL Anti-Patterns will be described here, along with better practices and exceptions where the Anti-Pattern may actually be a good answer. This presentation ought to be a spectator's delight - a chance to slow down and admire the train wrecks of others. For nothing is as instructive as mistakes or as fun to dissect.
Speaker(s): Ken Clement,
Abstract:
With the advantages of Office365/SharePoint Online, many organizations are evaluating their SharePoint on-prem environments for cloud migration readiness. If you are not sure where to start on the road-map to migration from SharePoint on-prem to SharePoint Online, this session is for you. In this session, we will cover the key points when developing a strategy for migrating to SharePoint Online. Whether you are currently using SharePoint On-Prem for Enterprise Content Management, Team Sites Collaboration, Process Automation, or all of the above, this session will provide tips for developing a migration road-map to make your migration successful.
Speaker(s): Cody Gros,
Abstract:
This session presents an overview of effective methods and strategies for capturing and managing useful information about how your software applications are running, what they are doing (which may or may not be what they are expected to be doing), and most importantly, when, where, and sometimes even why, they are malfunctioning. Software application logging is an often neglected, poorly implemented, and under-appreciated aspect of the software development process. But if implemented wisely, logging can be an invaluable tool for debugging, testing, error handling, and auditing. This session will present a case for a more diligent and rewarding approach to logging, and provide useful tips that can cost very little extra development time, but pay off in the long run, most especially when production issues arise and must be resolved quickly.
Speaker(s): Jason Rowlen,
Abstract:
Indexes are one of the most troubling and mysterious areas for DBAs and developers. Adding, deleting, or modifying them can yield dramatically positive or negative changes in query performance. The mystery is knowing how indexes need to be adjusted and what outcomes will result. This uncertainty often leads to great reluctance to eliminate indexes that are used sparingly or only because the optimal ones are missing. This leads to index proliferation, which ultimately produces inconsistent and poor query performance. Some believe that the SQL Server Database Tuning Advisor will solve all these issues, but it frequently does not. In fact, it often compounds the proliferation problem significantly. This presentation will enable a DBA to make informed decisions regarding what query and index metrics to monitor, determine how indexes are used, and devise appropriate index strategies to improve query performance through index addition, deletion, or modification.
Speaker(s): Jeffry Schwartz,
Abstract:
One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s): Chris Hyde,
Abstract:
Becoming a proactive DBA is something that most SQL administrators strive to be but many fall short. Meetings, doing non-SQL related tasks, excessive workload and sometimes corporate culture often work against a DBA by creating conditions where it is nearly impossible to pay attention to the tasks involved in taking care of your SQL instances. Our presentation will cover those proactive tasks and alerts that will provide a straightforward method of ensuring that maintenance and monitoring are working for all SQL instances you are responsible for. Additionally, we will cover some ways to identify emergency performance problems that will allow a DBA to quickly resolve issues while making them look like the expert they truly are.
  If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!
Speaker(s): Anthony Nocentino,
Abstract:
Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
Speaker(s): Amy Herold,
Abstract:
Past versions of SQL Server didn't include many options for encrypting data outside of network traffic and at rest. This is going to change with SQL Server 2016, which has a new feature named "Always Encrypted". This talk will show the fundamentals of using this technology and a demo of how to configure it and work with the encrypted data.
Speaker(s): Mel Lusk,
Abstract:
In this session we will build a partitioning architecture in SQL Server for high volume insert scenarios. We’ll begin with a short discussion of our problem scenario and motivation to partition. Then, we’ll create the partitioned tables and related supporting database objects. Next, we’ll create some data access code to perform crud operations. We’ll finish by creating data retention artifacts to complete a simple, production ready partitioning solution.
Speaker(s): Stephen Fulcher,
Abstract:
Have you ever tried to tune a query or searched for a performance bottleneck just to have SQL Server lead you down a rabbit hole? In this session we will look at some common performance issues that can occur that might be masked or hidden by misleading information you get from SQL Server. We will also talk about why SQL Server gives you the information it does, and how to see past this information and find the real issues causing your performance problems.
Speaker(s): Lance Tidwell,
Abstract:
This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker(s): Amy Herold,
Abstract:
In the spirit of Tim Ford's year long Entry Level Challenge, what do you do when given a SQL Server to manage? This presentation will walk you through how to gain access to a SQL Server you have never seen before, what are the basic tools to use to collect inventory information, and what scripts I use to best determine the "health" of the server.
Speaker(s): Robert Bishop,
Abstract:
Microsoft supplies us with many tools to produce business analytics with our company’s data. From health care to financial data, we need a friendly display of this valuable information in order for analyst to find what they are looking for or find new trends to focus in on. It all starts with formatting your data in a dimensional model. Then, you need to be able to take that model and create a fast database in analysis services. This will consolidate the business rules and give us fast retrieval of the information. PowerBI and Excel can be used by analysts to view this data and produced fixed dashboards and scorecards. But we also need to be able to create interactive displays for current data.
Speaker(s): Thomas LeBlanc,
Abstract:
As more businesses need technical acumen in their management ranks, acquiring and mastering leadership skills are paramount for a technical professional seeking career growth. Why and how should you approach the leadership discipline? Learn how you can approach your own leadership growth, as Niraj presents a case to view leadership with the lens of a Systems Engineer. You will gain an understanding of a leadership framework that you can start applying right away. Niraj started his career as a programmer, and later served in multiple management roles.
Speaker(s): Niraj Kumar,
Abstract:
No Documentation! No plan! those and other myths and lessons learned
Speaker(s): Steven McGee,
Abstract:
SVG is more than just an image format. It’s a solution that solves many problems with today’s rapidly growing web, especially in responsive design. SVG also contains many features to enhance the user's experience: accessibility, resolution independence, and interactivity. We'll see why we should use SVG, how to style SVG using CSS, how to animate SVG to bring the web to life, and much more.
Speaker(s): Quinton Jason Jr,
Abstract:
The secret to running a successful analytics program is knowing *which* projects to tackle, and how to use those analytics to improve your company’s overall performance. We'll review how SQL Server and Power BI technologies can play a role in the architecture of Enterprise Performance Management. Join Patrick Thompson, Sparkhound General Manager Partner and former CIO for several Louisiana Fortune 500 companies, as he highlights proven strategies for selecting the key lead and lag metrics to align IT with business goals, organizing those measurements and forecasts into a cadence management dashboard, and coaching your teams to use that dashboard effectively.
Speaker(s): Patrick Thompson,
Abstract:
Take a fascinating and entertaining journey into the binary and mathematical patterns found in music and how they can be used to learn the underlying language of music theory and applied to other disciplines.
Speaker(s): Brian Rigsby,
Abstract:
In this talk, we'll create an ASP.NET Web API from scratch, and then demonstrate how you can communicate with it and manipulate data using a cross-platform (iOS, Android, and Windows Phone) Xamarin Forms app. Because ASP.NET Web API is a RESTful framework, you'll also be able to use this API with any other platform that can make HTTP calls.
Speaker(s): Brandon Cornett,
Abstract:
Visual Studio Team Services has some new integrations for your Xamarin mobile apps. We#39;ll be taking an existing mobile app and adding Continuous Integration to ensure your app builds, connecting to build agents, and Continuous Deployment to HockeyApp. We will also discuss another CI/CD service, Bitrise, which has its own build agents. With all of the different platforms and integration points, there#39;s no reason why these steps should be manual. Learn how to leverage your existing Microsoft tools and subscriptions to get your app out faster and with less human interaction.
Speaker(s): Seth Valdetero,
Abstract:
Organizing the Chaos Utilizing JIRA Confluence to bring clarity to your projects and teams Do you have a difficult time keeping your teams organized? Do you struggle with providing real time reporting on your projects? Do you feel like your project tracking system is difficult to customize? We will show you how we have used JIRA and Confluence to organize and increase the visibility of not only our IT projects, but also our non-IT projects. We will also show you how these tools allowed us to improve client communication and satisfaction for a variety of our service lines.
Speaker(s): Josh Dicharry,
Abstract:
Stop relying on vendors to provide you with performance data. Between Windows and SQL Server you’ve already got all you need to collect and report on server performance. And it’s far more flexible than you’ll ever get from a vendor. This is often called a poor man’s method, but it’s so much more than that. I’m going to show you what your options are for collecting performance data for free and you’ll even walk away with a framework you can plug into your own environment and start using tomorrow with very little effort.
Speaker(s): Sean McCown,
Abstract:
I (and a team of people much sharper than me) tried to push unit testing onto established development teams on multiple occasions in the past, and we failed repeatedly... until we figured out the things that we'll discuss in this session. We will cover a set of rules and guidelines for bringing the practice of unit testing into a team of developers who may or may not be interested in persuing unit testing. We will include patterns and approaches for ensuring that the tests that we write are highly legible, maintainable, and bring genuine value to the team. We will learn to structure our unit testing practices so that our efforts do not fade away in time due to lack of upkeep. Unlike most of my sessions in the past, we won't be writing any code or doing demos in this session. This will be more about the patterns and rules. Target audience is anyone interested in bringing unit tests to their development team, or anyone has struggled to keep unit testing efforts afloat in the past.
Speaker(s): Steve Schaneville,
Abstract:
At the core of User Experience is Empathy. The ability to be empathetic to your end user can be deceptively challenging. Just because something works does not always mean it is the best and easiest functionality to serve to your audience. In this session, we will review some common areas of practice in the User Experience process to get into the mind of your target user and make design and development decisions based on empathy. As an added bonus, we will also discuss how to achieve empathy for the product team around you in order to build the best possible solution for your client together.
Speaker(s): Lynsey Gwin,
Abstract:
In this presentation, I will guide the audience through where and how Quality Assurance can be applied to all phases of a development project as well as practical instructions on how to full test and confirm requirements of a feature using ad hoc testing.
Speaker(s): Lizzie Broussard,
Abstract:
Do you dream about starting a business? You’re not alone—millions of Americans share that dream. And yet, not everyone has the courage to get started. But if you’re reading this, you have already taken the first steps toward turning your dream into reality. Obviously, dreaming alone isn’t enough.  You will have good days and bad ones. But don’t get discouraged. As Walt Disney said, “If you can dream it, you can do it. Always remember this whole thing was started by a dream and a mouse.” Simple Steps for Starting Your Business is more than just a guide to business ownership. It’s really a blueprint for helping make your dreams a reality. In this session Bob Breaux from the Baton Rouge SCORE chapter will introduce you to the foundations of starting your own business and give you insight into the resources that are available to you within the state of Louisiana to do so!
Speaker(s): Stacy Vicknair,
Abstract:
You know that F# .NET's functional programming language. You know that it supports default immutability, functions as types, and type inference, and even OOP. But do you know about the other awesome language features like pattern matching, discriminated unions, sequences, mailbox processors, type providers, and a plethora of other awesome tools? Learn how F# can make you productive in your day to day work using these awesome language features.
Speaker(s): Jeremy Abbott,
Abstract:
Microsoft SQL Server offers the several ways of speeding up backup and restore operations I will discuss and demonstrate way I took a backup that ran in 279 minutes down to 34 minutes with multiple options. I will also discuss the several backup types (full, differential, and log) to minimize to recovery time.
Speaker(s): Robert Canzonire,
Abstract:
Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring.
Speaker(s): Sven Aelterman,
Abstract:
In this presentation I will give an introduction to building UIs with React and managing application state with Redux. I will also demonstrate some cool tricks such as serverside rendering of react components, time travel debugging, and some general javascript and es6 best practices.
Speaker(s): Alex Clavelle,
Abstract:
As a manager or team leader giving effective feedback is vital to the success of projects. In this session we will discuss soft skills and best practices to give feedback, performance improvement, and even disciplinary actions. Learn how to handle confrontation tactfully.
Speaker(s): Christine Assaf,
Abstract:
So you've been developing PowerShell for a while, or perhaps you're taking over maintenance of an existing set of scripts. It would be great to get extra confidence in your scripts through testing, but how? You're in luck, there's a new module in town, Pester! Pester is a friendly testing framework designed for testing your PowerShells scripts and modules. In this session you'll be introduced to Pester. You'll see how to use Pester to uncover bugs, as well as using it for test driven development. Make your own PowerShell more robust through the use of Pester. Kill those PowerShell bugs, dead!
Speaker(s): Robert Cain,
Abstract:
Discussion regarding "Fun Facts" pertaining to AGs Review of AGs from pre requisites to backups and lots in between. Highlighting differences from everyday DBAdom either recommended for use with or mandated by the use of AGs. For Example "max worker threads" minus 40 or Cross database ownership chaining support in AGs
Speaker(s): Joe Hellsten,
Abstract:
75% of U.S. Americans have some level of fear of public speaking. A lot of that fear comes from not understanding the basic elements of effective presentations. In today's work world, your ability to present with authority and confidence can mean the difference between success and set-back. In this session, trainer Nicole Payne-Jack will bring these elements to help you to stand and deliver effective presentations. Topics include: finding your voice, elements of presentation construction, best visual aids practices, and how to overcome nervousness.
Speaker(s): Nicole Payne-Jack,
Abstract:
Governance is tricky within any organization no matter its size. This session will highlight best practices for gathering requirements and setting policies in the process of Records Management in SharePoint and what tools are available out of the box to help your organization succeed.
Speaker(s): Trace Armstrong,
Abstract:
With the release of ASP.NET Core 1, a slew of major changes have been made to the way ASP.NET applications are built. In this presentation, we will talk about the new structure of ASP.NET projects, covering aspects like project structure, the updated project file, the new request pipeline, dependency injection, and middleware. We will also cover the new features of ASP.NET Core 1 MVC like tag helpers, view components, and bundling changes. This presentation assumes the attendee has some experience with the ASP.NET MVC framework.
Speaker(s): Eric Trivette,
Abstract:
The launch of SQL Server 2016 means there will be a lot of blog posts and webinars of people talking about all the great administration features that come with this new release. Karen Lopez and Thomas LaRock will be sharing the best features from a database designers point of view -- from Always Encrypted to Zombie Datatypes. We'll look at the new features, why you should consider them, where they work, where they don't, who needs to be involved in using them, and what changes, if any, need to be made to applications or tools that you use with SQL Server.
Speaker(s): Karen Lopez,
Abstract:
In this session we will go over the benefits of using MEF and how to implemented it in a MVC web application.
Speaker(s): Andie Saizan,
Abstract:
SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Speaker(s): Thomas LaRock,
Abstract:
Occasionally, something comes along that causes a shift in the way we do things. In modern software development, that shift is agile project methodologies with Scrum leading the way. Though Scrum, organizations learn to focus on the product and embrace change. Adopting the Scrum methodology of software development will increase team performance and decrease development time. During this session, attendees will develop an understanding of agile project management and the basic techniques of Scrum.
Speaker(s): James Davis,
Abstract:
Are you tired of hearing SharePoint App part working in development environment but not working production ? Do you constantly find your self changing web part details because associated parameters changed ? Then you are ready for creating app part. App part development simply allow you to make web part responsive, light weight and robust. It also provide a user some contemporary features of bootstrap and makes maintenance of the app very easy. This session will also focus belief on JS framework knockout and how developer can benefit from combining that with SharePoint.
Speaker(s): Keyur Vadhvana,
Abstract:
A panel of regional CIO's gathers to discuss questions for modern IT Leadership and Enterprise Performance Management.
Speaker(s): Patrick Thompson,
Abstract:
You want to download a file from FTP, process the data into a staging table in your database and archive the file ... I'll show you how to do all that with BIML. I'll share the code I use and show you just how easy it is to simplify your ETL with BIML.
Speaker(s): Tim Costello,
Abstract:
In this introduction to SharePoint session, attendees will learn about the building blocks of SharePoint, such as: What is a list? What is a library? What is a web part? Should I view/edit documents in the browser or in the client? What is versioning? How do I check out and check in a document? Additionally, attendees will learn how to create, modify, and switch views, as well as set up and manage alerts. This session will include demos in Office 365, but the concepts apply to all versions of SharePoint, from 2003 to 2016.
Speaker(s): Theresa Eller,
Abstract:
Learn the new features of SQL 2016 that not only apply to 2016 but can also help manage and tune your older versions! This advanced session covers the query store and many new features of Management Studio, as well as a deep dive into the query plan and optimizer itself. Join me as I cover the noteworthy tuning tools and techniques that every DBA and developer should know!
Speaker(s): Daniel Janik,
Abstract:
Introduction to Toastmasters International and what they can do to enhance your Leadership and Speaking abilities.
Speaker(s): Jim Brown,
Abstract:
Do you have what it takes to be a Jeopardy Champion? The first ever SQLSaturday Baton Rouge game show, where we will need 3 volunteers to be our SQLSaturday Jeopardy contestants, picked out of the audience at the start of the session!
Speaker(s): William Assaf,
Abstract:
A beginner-level historical account of how and why the web has arrived at its current state. This includes an examination of the evolution of HTML, CSS, and Javascript, including a discussion of likely future trends.
Speaker(s): George Mauer,
Abstract:
Continuous integration and continuous delivery are two practices that can drastically reduce any software company's testing and deployment times. In this talk, we will be discussing several tools (including TeamCity and Octopus Deploy) that you can use to streamline these tasks, as well as how you can go from having nothing to a baseline project set up using a template that you've previously created on a publicly accessible development environment in less that 5 minutes. The days of copying and pasting files to a server to deploy your code are over.
Speaker(s): Brandon Cornett,
Abstract:
There have been many data lingua franca over the years (EDI, CSV, XML). Let's meet a new comer JSON (aka Jason). JSON is the web developers new best friend, providing a schema free way to transmit and persist data. SQL Server 2016 has provided new functionality to work with JSON. In this session we will look at how to read a JSON document using the OPENJSON function. We will also look at other methods for extracting information from JSON. Finally, we will look at how to generate JSON documents from TSQL queries.
Speaker(s): Russel Loski,
Abstract:
I'll go through the problem (needing a quick and easy way to get a database set up to start developing), the solution (Google Spreadsheets and how to get setup for development) and then I'll show a couple examples of the projects I've developed with it. I'll also make good on my promise of using your DBA budget allocation for bacon.
Speaker(s): Adam Culpepper,
Abstract:
Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session. This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.
Speaker(s): Michael Viron,
Abstract:
What are the secrets to having a better SharePoint experience? In this session, we will take a look at the secrets, tips, and tricks a large healthcare organization employs to improve their employees' SharePoint experience. Topics include selecting a browser, granting permissions properly, avoiding prohibited characters in file names, replacing folders with metadata, preparing for the list view threshold, saving your skin with versioning, and more. Demos will be conducted in Office 365 but concepts apply to SharePoint on-premises as well.
Speaker(s): Theresa Eller,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/KennethClement
Ken Clement has been an I.T. professional for over three decades in roles including software and database design, development, analysis, architecture, and management. He has successfully applied these technologies to diverse problem domains and in the process acquired a firm practical and theoretical understanding of the often opposing developer and database professional perspectives. While he has worked with several database technologies, the most notable is SQL Server which he has been involved with practically from its inception. He has over the years been a technical presenter at various conferences.
LinkedIn: http://www.linkedin.com/in/jameyj
Contact: http://STATCowboy.com
Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.
LinkedIn: https://www.linkedin.com/in/calvinfab
Contact: http://envoc.com/think/archive/author/39
Serving as the President of Envoc (pronounced “invoke”), Calvin Fabre heads up a stellar team of almost 30 Envoceans aimed at helping businesses and individuals attain “a better reality.” For over 10 years, Envoc has been creating beautiful custom software you can’t “buy off the shelf” and seeing a client’s brand from creation through consumption whether in web design, print, brand strategy corporate dashboards, portals, or mobile applications.
LinkedIn: https://www.linkedin.com/in/christineassaf
Contact: https://www.hrtact.com
Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master's degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of "expressiveness" in the workplace that creates connectivity.
LinkedIn: https://www.linkedin.com/in/altjames
Contact: https://jamesalt.com
James is an Enterprise Application Architect with the Office of Technology Services at the State of Louisiana, leading the effort to modernize application development. He also works freelance as a mobile developer at Alterity LLC, building apps for regional clients.
LinkedIn: https://www.linkedin.com/in/jeremymabbott
Contact: http://jeremyabbott.github.io
I#39;m a developer at Shreveport development shop, Praeses, where I work as a project architect, developer, and recruiter. I work hard to deliver clean, extensible, and maintanble solutions to customer#39;s business problems. I#39;m passionate about software as a profession and craft, and work to cultivate that mindset in my team members through constant training.
LinkedIn: https://www.linkedin.com/in/mechelleroberthon
A University of Louisiana alumnus and current graduate student in Training and Performance Improvement, Mechelle specializes in creating custom content for role-specific training applications, which ensures relevance and the most impactful ROI for attending students. Mechelle has past experience as a career development instructor, is a member of the Association of Talent Development and serves as the VP of Human Capital for the International Society of Performance Improvement. She has quickly become a top requested facilitator among LANTEC’s clients due to her energetic and engaging teaching style. In January 2016, Mechelle was promoted to a management position of Instructor Supervisor.
LinkedIn: http://www.linkedin.com/in/theresaeller/en
Contact: http://www.techresa.com
Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.
Contact: https://github.com/togakangaroo/Blog
George Mauer is a software developer, speaker, teacher, writer, and comedian with an interest in the various techniques that can make software simple, extensible, and communicative. He is the owner of Humble Pi Software and currently a senior developer with Surge Consulting. He speaks regularly on Javascript, C#, Agile and other subjects, at usergroups, and to his cat.
LinkedIn: https://www.linkedin.com/in/lori-brown-15a6944?
Contact: http://blog.sqlrx.com
Lori is the SQLRx Practice Manager (sqlrx.com) and a Senior Consultant for Integrated Services, Inc., located in Dallas Texas(isi85.com). Lori has more than 18 years of experience with SQL. At ISI, she provides SQL Server expertise in performance tuning, disaster recovery/high availability, SQL upgrades and installation and DBA services. She has taught courses on SQL Server administration and performance tuning for many different companies. Lori has conducted numerous performance studies and has developed the methods and code used in SQLRx’s RemoteDBA offering. Ms. Brown has also published articles in SQL Server Magazine, contributed to SQLServerCentral.com and is a regular blogger on the SQLRx blog (blog.sqlrx.com)
LinkedIn: http://www.linkedin.com/pub/mike-byrd/1/aa0/bbb
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies. Presenter at many SQL Saturdays over last 6 years in United States, Europe, and Australia. Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced). Video presentations (for local SQL Server user groups or SQL Saturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
LinkedIn: http://www.linkedin.com/in/jennifermccown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Lizzie is a Quality Assurance and Support Manager with Envoc in Baton Rouge. She#39;s coming up to a decade in the business of software testing and still loves to log bugs!
LinkedIn: http://www.linkedin.com/in/arcanecode
Contact: http://arcanecode.com
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate's SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.
10+ years of Project Management experience for IT projects, Non-profit campaigns, amp; Non-IT projects Specializing in project set-up, team management, resource planning, business process improvement, project monitoring amp; controls, and project triage.
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Contact: http://www.sqlrx.com
Jeffry Schwartz is the Senior Systems Architect for ISI’s SQL Rx team, a group of professional consultants specializing in performance, optimization, tuning, and capacity planning for Windows Server and Microsoft SQL Server systems. Over a 37-year span, he has won numerous awards for the development and delivery of state-of-the-art consulting services, including more than 930 performance and capacity planning studies. Customers include Microsoft, who awarded SQLRx Data Management Solutions Partner of the Year in 2008 for his WinPerf Windows and SQL Server performance analysis software suite.
LinkedIn: http://www.linkedin.com/in/thenirajkumar
Contact: http://www.leadproje.com
Niraj Kumar currently serves as Director of Business Engineering at Blue Cross amp; Blue Shield of Louisiana, leading a team of Managers, Engineers and Analysts. Prior to this role, He led sales enablement initiatives at Rackspace, a cloud computing and IT hosting company. Previously, he held various management positions in manufacturing, supply chain, operations, business analysis, and product development. Niraj is passionate about business startups and entrepreneurship. He has mentored and judged startup competitions for many years. He also served as a guest lecturer to business students, sharing his knowledge of team building, branding and project management. Niraj blogs abut project leadership at www.leadproje.com.
LinkedIn: https://www.linkedin.com/profile/preview?locale=en_USamp;trk=prof-0-sb-preview-primary-button
Contact: http://www.melvinlusk.com
Mel Lusk is a technologist specializing in database administration, enterprise software, and IT project management. He has almost 20 years of experience in the IT industry, with almost 15 years working with SQL Server. He is currently the SQL DBA Manager for GCR, Inc. He holds a Bachelor#39;s of Science degree from Southeastern Louisiana University, as well as the following industry certifications: Microsoft Certified Solutions Associate: SQL Server 2012 Microsoft Certified IT Professional: DBA Microsoft Certified Database Administrator Microsoft Certified Technology Specialist Microsoft Certified Professional Oracle Certified 11g Database Associate Oracle Certified MySQL 5.0 DBA ATMAE/NAIT Certified Technologist ITIL
LinkedIn: https://www.linkedin.com/in/sfulcher
Contact: http://www.crocodiledigital.net/blog/
Stephen Fulcher is a serial entrepreneur focused on delivering technology products and services that transform business strategies. After working with Microsoft as a Principal Engineer and Regional Director, Stephen founded Crocodile Digital to bring game-changing technology to businesses. Along the way, he has been a speaker at numerous technology conferences, developer meetings and product launches. He can be reached at<EMAIL_ADDRESS>LinkedIn: http://www.linkedin.com/profile/view?id=29648544amp;trk=hb_tab_pro_top
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
LinkedIn: https://www.linkedin.com/in/andie-saizan-mcp-4a28b816
I have an Associates degree in Information Systems and I've been writing code for 11+ years. I am also a Microsoft Certified Professional and Microsoft Specialist: Programming in C#. I'm a highly motivated individual, and I'm very passionate about my career. I LOVE programming and the challenges it brings. I enjoy taking business needs and bringing to life solutions that help businesses operate and function more efficiently.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Steven McGee is a highly successful technology leader and innovative problem-solver with extensive experience in project management, enterprise data and systems development and information technology service management. He is currently the Enterprise Agile Coach at Blue Cross Blue Shield of La - Led multiple software development projects from concept to deployment, with both onshore and offshore teams, and both departmental and global client base. - Worked through the evolution of project delivery methods from waterfall, spiral, iterative/incremental, time boxed, to agile methods. - Managed large highly-critical Data, Communications, and Air Traffic Control Centers - Led several PMOs with Quality Ma
LinkedIn: https://www.linkedin.com/in/schaneville
Steve has 17 years of experience delivering enterprise grade solutions using Microsoft technologies. He served as lead architect at Amedisys for nearly 8 years, and has recently transitioned into consulting at Sparkhound (and I#39;m really liking it! :-). In recent years he#39;s become a strong advocate for unit testing and he *actually believes* that writing unit tests saves time rather than consumes it.
LinkedIn: http://www.linkedin.com/in/jasonrowlen
Jason was born a long time ago, in a town far, far away.... Rescued as an infant from the cold desolation of the ice-world of Illinois, Jason was raised by his birth parents in the sweltering swamp-land of Baton Rouge, Louisiana. He began his career as a software developer in 2002, after graduating from Southeastern Louisiana University with a B.S. in Computer Science. Currently working as a Senior Software Developer at Blue Cross, Jason has previously worked as a developer for Equifax, Amedisys, and as an independent contractor. Jason enjoys road trips with his family, outdoor activities involving fire and meat, obsessing over Star Wars, and spending way too much time and money at the movies.
LinkedIn: https://www.linkedin.com/in/michaelviron
Michael Viron has a wide range of experience as a senior IT manager amp; business owner. As Director of IT amp; Software Engineering at KAMedData, Inc, he has been heavily involved in coordinating numerous product launches amp; both company amp; division startups. A key team member, his main responsibilities include technical operations, project management, security, short and long range technical planning, and development. As owner of General Education Online, he handles both IT and business operations.
LinkedIn: http://www.linkedin.com/in/sqlrockstar/
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
LinkedIn: http://www.linkedin.com/in/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
MS SQL server professional with 15 years experience. MCTS
LinkedIn: http://www.linkedin.com/in/theresaeller/en
Contact: http://www.techresa.com
Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.
LinkedIn: https://linkd.in/svena
Contact: https://svenaelterman.wordpress.com
Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.
LinkedIn: https://www.linkedin.com/pub/alex-clavelle/68/510/2b5
Senior in computer science at LSU, currently working as an intern Developer at Envoc. I love to cook and code, oftentimes simultaneously!
LinkedIn: http://www.linkedin.com/pub/daniel-janik/12/15b/606/en
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.
LinkedIn: https://www.linkedin.com/in/quintonjason
Contact: http://quintonjason.com
Quinton is a Interactive Director at Xdesign. When he’s away from the computer.
LinkedIn: https://www.linkedin.com/in/patrick-thompson-749a8659
Patrick Thompson is a Partner and General Manager of Sparkhound, overseeing operations and business development and growing Sparkhound’s footprint in Louisiana, Arkansas, Alabama, Mississippi and Florida. With more than 27 years of experience, he has held senior leadership positions at Fortune 500 and 1000 companies, including Accenture, Turner Industries, CBamp;I (formerly the Shaw Group) and Amedisys. In his spare time, he enjoys movie time and hanging on the beach with his family.
LinkedIn: https://www.linkedin.com/in/lynseygwin
As a designer and developer, I am a problem-solver who executes with efficiency and empathy as well as an advocate for the client and user. My professional passion is consult with clients to discover the best solution for their needs then working with them to execute and monitor their direction. My goal is to always be challenged.
LinkedIn: https://linkedin.com/profile/view?id=28634794
Contact: http://adamculpepper.net
Front-End Web Developer, JavaScript Dev, #jQuery book author, @refreshbr organizer, runner, kayaker amp; Body Mod enthusiast.
LinkedIn: https://www.linkedin.com/in/jdavisphd
Dr. James Davis is an experienced software developer, entrepreneur, combat veteran, and lecturer. He has a PhD in Information Systems Decision Science from Louisiana State University along with the PMP, CSP, and CSM project management certifications. He has been the lead technology partner in multiple successful start-ups and volunteers with Operation Code The Futures Fund. Dr. Davis is the director of the M.S. in Analytics program at LSU and enjoys writing books about using Python for entrepreneurship data science.
LinkedIn: http://www.linkedin.com/in/mikefrobbins
Contact: http://mikefrobbins.com/
Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.
LinkedIn: https://www.linkedin.com/in/robert-canzonire-355740a0
Contact: http://www.sqltigers.com
Robert Canzonire is an Advisory Database Administrator for Blue Cross Blue Shield of Louisiana. He is the chair leader of the Virtual Chapter of Data Architecture for PASS. He holds several certifications including MCSE, MCSA and MCITP. He started with SQL Server in 1995
LinkedIn: http://www.linkedin.com/in/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Data Architect and BI Architect. Experience building Data Warehouse and ETL platforms, BI Analytics and OLTP systems. He is currently a Director of Product Manager at Idera, responsible for the development of the multi-platform tools.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
LinkedIn: https://www.linkedin.com/in/nocentino
Contact: http://www.centinosystems.com/blog/
Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.
LinkedIn: http://www.linkedin.com/in/karenlopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
LinkedIn: https://www.linkedin.com/in/stacyvicknair
Contact: http://www.stacyvicknair.com
As the Software Engineering Manager at Netchex, Stacy focuses on two main things: people and process. In both responsibilities Stacy believes that he acts in service to those he works with throughout the organization and hopes that he helps shape an environment that his team members are proud to be a part of. Stacy is certified as a Professional Scrum Master (PSM-I), Distinguished Toastmaster (DTM) and has numerous Microsoft certifications for software development and application life cycle management. Stacy was also awarded the Microsoft MVP award six years in a row from 2009 to 2015 based on his contributions to the tech community both locally and online.
LinkedIn: http://www.linkedin.com/pub/tim-costello/8/b38/a02/
Contact: http://www.timcost.com
Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.
LinkedIn: https://www.linkedin.com/in/keyurvadhvana
Keyur worked with Microsoft technologies over 8 years. He has deep knowledge of SharePoint architecture and development. He has been working with SharePoint 2003, 2007, 2010, 2013 and Office 365. He is also passionate about solving existing problems with SharePoint and providing custom coded solution for client specific requirement.
LinkedIn: https://www.linkedin.com/in/patrick-thompson-749a8659
Patrick Thompson is a Partner and General Manager of Sparkhound, overseeing operations and business development and growing Sparkhound’s footprint in Louisiana, Arkansas, Alabama, Mississippi and Florida. With more than 27 years of experience, he has held senior leadership positions at Fortune 500 and 1000 companies, including Accenture, Turner Industries, CBamp;I (formerly the Shaw Group) and Amedisys. In his spare time, he enjoys movie time and hanging on the beach with his family.
IT professional for over 20 years specializing in Information Security. Active member in Toastmasters
Contact: http://sqlpadre.wordpress.com
Robert has been working with databases since SQL Server 2005. After 4 years as a .NET developer using SQL Server, Robert became a DBA out of necessity, a true "Accidental" DBA! Robert has presented at his local SQL Server User group, SQL Saturdays and PASS Virtual Chapters. As a Microsoft MSCA and an Idera ACE, Robert enjoys administrative tasks, configuring SQL Server for optimal performance, troubleshooting problematic SQL queries and making those query run faster than the speed of light. In the event of "free time", Robert enjoys camping, playing his guitars and spending time with his family.
LinkedIn: http://www.linkedin.com/in/russloski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
Contact: http://lancetidwell.com
Lance Tidwell, from the Austin, TX, area, has worked as a SQL Server DBA for the last 11 years. During his time as a DBA he has found his passion for all things SQL, but specifically for performance tuning. He has a life-long quest to always be learning new things; currently this quest has lead him to explore more about the Data Analytics/ Data Science areas.
LinkedIn: https://www.linkedin.com/in/cody-gros-55b2b5114
Contact: http://www.gorogueit.com
Cody Gros has been working with SharePoint for the past 10 years. He has been involved in many SharePoint implementations including Intranet Sites, Enterprise Content Management, Extranet Sites, as well as building custom applications on the SharePoint platform. Heavily involved in the SharePoint community, he’s a leader of the Baton Rouge SharePoint User Group (BRSPUG) and speaks at various user groups and SharePoint Saturdays around the region.
LinkedIn: ?https://www.linkedin.com/in/nicole-payne-jack-2b537b53
Nicole is a former Orleans Parish School System teacher where she briefly taught elementary-aged students before realizing her calling was in inspiring adult learners. After receiving a bachelor of arts degree with dual concentrations in Special Education and Elementary Education from Xavier University of Louisiana, she has worked in the field of Organizational Development for the last 16 years, specifically in Human Resources. Education, teaching, and learning are high on her list of priorities, so much so that Nicole is a recent graduate of Nova Southeastern University’s Fischler College of Education, having received a doctorate degree in education (Ed.D) with concentrations in Organizational Leadership and Human Resources Development.
Eric Trivette is a software developer at Sparkhound that has been developing software with the Microsoft stack since 2006. A graduate from LSU and Baton Rouge native, Eric got started in programming as a kid with a copy of Visual C++ 6 and has been hooked ever since. When not working, Eric can be found with an alcoholic beverage in his hand while participating in one of his many hobbies which include things like bowling, kickball, homebrewing, and others.
LinkedIn: https://www.linkedin.com/in/trace-armstrong-69021929
Trace has over eight years in web development experience with a concentration in SharePoint Branding, Site Architecture, Records Management, Workflow development, and Power User solutions. When he is not working he enjoys watching hockey, football, going out to dinner with his wife, and playing with his dog Sadie.
LinkedIn: https://www.linkedin.com/in/christineassaf
Contact: https://www.hrtact.com
Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master's degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of "expressiveness" in the workplace that creates connectivity.
LinkedIn: https://www.linkedin.com/pub/brandon-cornett/49/541/208
Brandon is a lead software developer at Turner Industries. He brings years of experience in the consulting field to the enterprise, working on internal projects to help support employees of the business. His stack of choice is .NET, and he's more recently taken an interest in React for web and mobile applications. Brandon assists with classes at Southeastern Louisiana University, has attended Xamarin conferences, is an active speaker at local .NET user groups, and has spoken at many SQL Saturday conferences in the past.
LinkedIn: https://www.linkedin.com/in/williamdassaf/
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA's. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of "SQL Server Administration Inside Out" by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
Contact: http://zendeveloper.blogspot.com
Brian#39;s formal education is in music, but he is an eighteen year software development veteran. His unorthodox presentation style is both inspirational and entertaining.
LinkedIn: https://www.linkedin.com/pub/brandon-cornett/49/541/208
Brandon is a lead software developer at Turner Industries. He brings years of experience in the consulting field to the enterprise, working on internal projects to help support employees of the business. His stack of choice is .NET, and he's more recently taken an interest in React for web and mobile applications. Brandon assists with classes at Southeastern Louisiana University, has attended Xamarin conferences, is an active speaker at local .NET user groups, and has spoken at many SQL Saturday conferences in the past.
LinkedIn: https://www.linkedin.com/in/valdetero
Seth Valdetero is a Senior Developer at Sparkhound. He has been in the mobile app space for several years. He is the president of the Baton Rouge .NET User Group. You can usually hear him speak at user groups or conferences about Xamarin and mobile app development.
LinkedIn: http://www.linkedin.com/in/mikefrobbins
Contact: http://mikefrobbins.com/
Mike F Robbins is a Microsoft MVP on Windows PowerShell and a SAPIEN Technologies MVP. He is a co-author of Windows PowerShell TFM 4th Edition and is a contributing author of a chapter in the PowerShell Deep Dives book. Mike has written guest blog articles for the Hey, Scripting Guy! Blog, PowerShell Magazine, and PowerShell.org. He is the winner of the advanced category in the 2013 PowerShell Scripting Games. Mike is also the leader and co-founder of the Mississippi PowerShell User Group. He blogs at mikefrobbins.com and can be found on twitter @mikefrobbins.
The following is a list of sponsors that helped fund the event.
LSU E. J. Ourso College of Business
Blue Cross Blue Shield of Louisiana
Champion Technology Services, Inc.


Of course, there's the capability of displaying images. In this release, images lack of the expected alignment features to behave just as expected on an HTML context, but they will do just fine for inline contexts, tables and some others.
Inserting images
We all know that the
src
attribute of theimg
HTML tag can be a relative or absolute path to an image on the same or any other server. Here things are slightly different. Images can come from other sources:
- File Paths: If you place a path to a file, the Renderer will try to load it using
Image.FromFile
- Static Properties: Obtains the image from a static property that returns an
Image
object- Static Methods: Obtains the image from a static method that takes no arguments and returns an
Image
Positioning Images
You can use Images anyway you like, apply borders margin and padding as for any other box.
Some examples of image positioning:
Just an image: Image with border and background: Stretched Image: Huge padding and border: Image in line with the text


VRT -- Virtual Format
Driver short name
VRT
Driver built-in by default
This driver is built-in by default
OGR Virtual Format is a driver that transforms features read from other drivers based on criteria specified in an XML control file. It is primarily used to derive spatial layers from flat tables with spatial information in attribute columns. It can also be used to associate coordinate system information with a datasource, merge layers from different datasources into a single data source, or even just to provide an anchor file for access to non-file oriented datasources.
The virtual files are currently normally prepared by hand.
Driver capabilities
Supports Create()
This driver supports the GDALDriver::Create()
operation
Supports Georeferencing
This driver supports georeferencing
Supports VirtualIO
This driver supports virtual I/O operations (/vsimem/, etc.)
Creation Issues
The CreateFeature(), SetFeature() and DeleteFeature() operations are supported on a layer of a VRT dataset, if the following conditions are met :
the VRT dataset is opened in update mode
the underlying source layer supports those operations
the SrcLayer element is used (as opposed to the SrcSQL element)
the FID of the VRT features is the same as the FID of the source features, that is to say, the FID element is not specified
Virtual File Format
The root element of the XML control file is OGRVRTDataSource. It has an OGRVRTLayer (or OGRVRTWarpedLayer or OGRVRTUnionLayer) child for each layer in the virtual datasource, and a Metadata element.
An XML schema of the OGR VRT format is provided in ogrvrt.xsd.
When GDAL is configured with libXML2
support, that schema will be used to validate the VRT documents.
Non-conformities will be reported only as warnings. That validation can
be disabled by setting the GDAL_XML_VALIDATION
configuration option to "NO".
Metadata element
Metadata (optional): This element contains a list of metadata name/value pairs associated with the dataset as a whole. It has <MDI> (metadata item) subelements which have a "key" attribute and the value as the data of the element. The Metadata element can be repeated multiple times, in which case it must be accompanied with a "domain" attribute to indicate the name of the metadata domain.
OGRVRTLayer element
A OGRVRTLayer element should have a name attribute with the layer name, and may have the following subelements:
SrcDataSource (mandatory): The value is the name of the datasource that this layer will be derived from. The element may optionally have a relativeToVRT attribute which defaults to "0", but if "1" indicates that the source datasource should be interpreted as relative to the virtual file. This can be any OGR supported dataset, including ODBC, CSV, etc. The element may also have a shared attribute to control whether the datasource should be opened in shared mode. Defaults to OFF for SrcLayer use and ON for SrcSQL use.
OpenOptions (optional): This element may list a number of open options as child elements of the form <OOI key="key_name">value_name</OOI>
Metadata (optional): This element contains a list of metadata name/value pairs associated with the layer as a whole. It has <MDI> (metadata item) subelements which have a "key" attribute and the value as the data of the element. The Metadata element can be repeated multiple times, in which case it must be accompanied with a "domain" attribute to indicate the name of the metadata domain.
SrcLayer (optional): The value is the name of the layer on the source data source from which this virtual layer should be derived. If this element isn't provided, then the SrcSQL element must be provided.
SrcSQL (optional): An SQL statement to execute to generate the desired layer result. This should be provided instead of the SrcLayer for statement derived results. Some limitations may apply for SQL derived layers. An optional dialect attribute can be specified on the SrcSQL element to specify which SQL "dialect" should be used : possible values are currently OGRSQL or SQLITE. If dialect is not specified, the default dialect of the datasource will be used.
FID (optional): Name of the source attribute column from which the FID of features should be derived. If not provided, the FID of the source features will be used directly.
Logic for GDAL >= 2.4: Different situations are possible:
<FID>source_field_name</FID>
A FID column will be reported as source_field_name with the content of source field source_field_name.
<FID name="dest_field_name">source_field_name</FID>
A FID column will be reported as dest_field_name with the content of source field source_field_name. dest_field_name can potentially be set to the empty string.
<FID />
No FID column is reported. The FID value of VRT features is the FID value of the source features.
<FID name="dest_field_name"/>
A FID column will be reported as dest_field_name with the content of the implicit source FID column. The FID value of VRT features is the FID value of the source features.
Logic for GDAL < 2.4: The layer will report the FID column name only if it is also reported as a regular field. A "name" attribute can be specified on the FID element so that the FID column name is always reported.
Style (optional): Name of the attribute column from which the style of features should be derived. If not provided, the style of the source features will be used directly.
GeometryType (optional): The geometry type to be assigned to the layer. If not provided it will be taken from the source layer. The value should be one of "wkbNone", "wkbUnknown", "wkbPoint", "wkbLineString", "wkbPolygon", "wkbMultiPoint", "wkbMultiLineString", "wkbMultiPolygon", or "wkbGeometryCollection". Optionally "25D" may be appended to mark it as including Z coordinates. Defaults to "wkbUnknown" indicating that any geometry type is allowed.
LayerSRS (optional): The value of this element is the spatial reference to use for the layer. If not provided, it is inherited from the source layer. The value may be WKT or any other input that is accepted by the OGRSpatialReference::SetUserInput() method. If the value is NULL, then no SRS will be used for the layer.
GeometryField (optional): This element is used to define how the geometry for features should be derived.
If not provided the geometry of the source feature is copied directly. The type of geometry encoding is indicated with the encoding attribute which may have the value "WKT", "WKB" or "PointFromColumns".
If the encoding is "WKT" or "WKB" then the field attribute will have the name of the field containing the WKT or WKB geometry.
If the encoding is "PointFromColumns" then the x, y, z and m attributes will have the names of the columns to be used for the X, Y, Z and M coordinates. The z and m attributes are optional (m only supported since OGR 2.1.1).
The optional reportSrcColumn attribute can be used to specify whether the source geometry fields (the fields set in the field, x, y, z, m attributes) should be reported as fields of the VRT layer. It defaults to TRUE. If set to FALSE, the source geometry fields will only be used to build the geometry of the features of the VRT layer.
The GeometryField element can be repeated as many times as necessary to create multiple geometry fields. It accepts a name attribute (recommended) that will be used to define the VRT geometry field name. When encoding is not specified, the field attribute will be used to determine the corresponding geometry field name in the source layer. If neither encoding nor field are specified, it is assumed that the name of source geometry field is the value of the name attribute.
The optional nullable attribute can be used to specify whether the geometry field is nullable. It defaults to "true".
When several geometry fields are used, the following child elements of GeometryField can be defined to explicitly set the geometry type, SRS, source region, or extent.
GeometryType (optional) : same syntax as OGRVRTLayer-level GeometryType.
SRS (optional) : same syntax as OGRVRTLayer-level LayerSRS (note SRS vs LayerSRS)
SrcRegion (optional) : same syntax as OGRVRTLayer-level SrcRegion
ExtentXMin, ExtentYMin, ExtentXMax and ExtentXMax (optional) : same syntax as OGRVRTLayer-level elements of same name
If no GeometryField element is specified, all the geometry fields of the source layer will be exposed by the VRT layer. In order not to expose any geometry field of the source layer, you need to specify OGRVRTLayer-level GeometryType element to wkbNone.
SrcRegion (optional) : This element is used to define an initial spatial filter for the source features. This spatial filter will be combined with any spatial filter explicitly set on the VRT layer with the SetSpatialFilter() method. The value of the element must be a valid WKT string defining a polygon. An optional clip attribute can be set to "TRUE" to clip the geometries to the source region, otherwise the source geometries are not modified.
Field (optional): One or more attribute fields may be defined with Field elements. If no Field elements are defined, the fields of the source layer/sql will be defined on the VRT layer. The Field may have the following attributes:
name (required): the name of the field.
type: the field type, one of "Integer", "IntegerList", "Real", "RealList", "String", "StringList", "Binary", "Date", "Time", or "DateTime". Defaults to "String".
subtype: the field subtype, one of "None", "Boolean", "Int16", "Float32". Defaults to "None".
width: the field width. Defaults to unknown.
precision: the field width. Defaults to zero.
src: the name of the source field to be copied to this one. Defaults to the value of "name".
nullable can be used to specify whether the field is nullable. It defaults to "true".
unique can be used to specify whether the field has a unique constraint. It defaults to "false". (GDAL >= 3.2)
alternativeName: the field alternative name. (GDAL >= 3.7)
comment: the field comment. (GDAL >= 3.7)
FeatureCount (optional) : This element is used to define the feature count of the layer (when no spatial or attribute filter is set). This can be useful on static data, when getting the feature count from the source layer is slow.
ExtentXMin, ExtentYMin, ExtentXMax and ExtentXMax (optional) : Those elements are used to define the extent of the layer. This can be useful on static data, when getting the extent from the source layer is slow.
OGRVRTWarpedLayer element
A OGRVRTWarpedLayer element is used to do on-the-fly reprojection of a source layer. It may have the following subelements:
OGRVRTLayer, OGRVRTWarpedLayer or OGRVRTUnionLayer (mandatory): the source layer to reproject.
SrcSRS (optional): The value of this element is the spatial reference to use for the layer before reprojection. If not specified, it is deduced from the source layer.
TargetSRS (mandatory): The value of this element is the spatial reference to use for the layer after reprojection.
ExtentXMin, ExtentYMin, ExtentXMax and ExtentXMax (optional) : Those elements are used to define the extent of the layer. This can be useful on static data, when getting the extent from the source layer is slow.
WarpedGeomFieldName (optional) : The value of this element is the geometry field name of the source layer to wrap. If not specified, the first geometry field will be used. If there are several geometry fields, only the one matching WarpedGeomFieldName will be warped; the other ones will be untouched.
OGRVRTUnionLayer element
A OGRVRTUnionLayer element is used to concatenate the content of source layers. It should have a name and may have the following subelements:
OGRVRTLayer, OGRVRTWarpedLayer or OGRVRTUnionLayer (mandatory and may be repeated): a source layer to add in the union.
PreserveSrcFID (optional) : may be ON or OFF. If set to ON, the FID from the source layer will be used, otherwise a counter will be used. Defaults to OFF.
SourceLayerFieldName (optional) : if specified, an additional field (named with the value of SourceLayerFieldName) will be added in the layer field definition. For each feature, the value of this field will be set with the name of the layer from which the feature comes from.
GeometryType (optional) : see above for the syntax. If not specified, the geometry type will be deduced from the geometry type of all source layers.
LayerSRS (optional) : see above for the syntax. If not specified, the SRS will be the SRS of the first source layer.
FieldStrategy (optional, exclusive with Field or GeometryField) : may be FirstLayer to use the fields from the first layer found, Union to use a super-set of all the fields from all source layers, or Intersection to use a sub-set of all the common fields from all source layers. Defaults to Union.
Field (optional, exclusive with FieldStrategy) : see above for the syntax. Note: the src attribute is not supported in the context of a OGRVRTUnionLayer element (field names are assumed to be identical).
GeometryField (optional, exclusive with FieldStrategy): the name attribute and the following sub-elements GeometryType, SRS and Extent[X|Y][Min|Max] are available.
FeatureCount (optional) : see above for the syntax
ExtentXMin, ExtentYMin, ExtentXMax and ExtentXMax (optional) : see above for the syntax
Example: ODBC Point Layer
In the following example (disease.ovf) the worms table from the ODBC database DISEASE is used to form a spatial layer. The virtual file uses the "x" and "y" columns to get the spatial location. It also marks the layer as a point layer, and as being in the WGS84 coordinate system.
<OGRVRTDataSource>
<OGRVRTLayer name="worms">
<SrcDataSource>ODBC:DISEASE,worms</SrcDataSource>
<SrcLayer>worms</SrcLayer>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding="PointFromColumns" x="x" y="y"/>
</OGRVRTLayer>
</OGRVRTDataSource>
Example: Renaming attributes
It can be useful in some circumstances to be able to rename the field names from a source layer to other names. This is particularly true when you want to transcode to a format whose schema is fixed, such as GPX (<name>, <desc>, etc.). This can be accomplished using SQL this way:
<OGRVRTDataSource>
<OGRVRTLayer name="remapped_layer">
<SrcDataSource>your_source.shp</SrcDataSource>
<SrcSQL>SELECT src_field_1 AS name, src_field_2 AS desc FROM your_source_layer_name</SrcSQL>
</OGRVRTLayer>
</OGRVRTDataSource>
This can also be accomplished using explicit field definitions:
<OGRVRTDataSource>
<OGRVRTLayer name="remapped_layer">
<SrcDataSource>your_source.shp</SrcDataSource>
<SrcLayer>your_source</SrcLayer>
<Field name="name" src="src_field_1" />
<Field name="desc" src="src_field_2" type="String" width="45" />
</OGRVRTLayer>
</OGRVRTDataSource>
Example: Transparent spatial filtering
The following example will only return features from the source layer that intersect the (0,40)-(10,50) region. Furthermore, returned geometries will be clipped to fit into that region.
<OGRVRTDataSource>
<OGRVRTLayer name="source">
<SrcDataSource>source.shp</SrcDataSource>
<SrcRegion clip="true">POLYGON((0 40,10 40,10 50,0 50,0 40))</SrcRegion>
</OGRVRTLayer>
</OGRVRTDataSource>
Example: Reprojected layer
The following example will return the source.shp layer reprojected to EPSG:4326.
<OGRVRTDataSource>
<OGRVRTWarpedLayer>
<OGRVRTLayer name="source">
<SrcDataSource>source.shp</SrcDataSource>
</OGRVRTLayer>
<TargetSRS>EPSG:4326</TargetSRS>
</OGRVRTWarpedLayer>
</OGRVRTDataSource>
Example: Union layer
The following example will return a layer that is the concatenation of source1.shp and source2.shp.
<OGRVRTDataSource>
<OGRVRTUnionLayer name="unionLayer">
<OGRVRTLayer name="source1">
<SrcDataSource>source1.shp</SrcDataSource>
</OGRVRTLayer>
<OGRVRTLayer name="source2">
<SrcDataSource>source2.shp</SrcDataSource>
</OGRVRTLayer>
</OGRVRTUnionLayer>
</OGRVRTDataSource>
Example: SQLite/Spatialite SQL dialect
The following example will return four different layers which are generated in a fly from the same polygon shapefile. The first one is the shapefile layer as it stands. The second layer gives simplified polygons by applying SpatiaLite function "Simplify" with parameter tolerance=10. In the third layer the original geometries are replaced by their convex hulls. In the fourth layer SpatiaLite function PointOnSurface is used for replacing the original geometries by points which are inside the corresponding source polygons. Note that for using the last three layers of this VRT file GDAL must be compiled with SQLite and SpatiaLite.
<OGRVRTDataSource>
<OGRVRTLayer name="polygons">
<SrcDataSource>polygons.shp</SrcDataSource>
</OGRVRTLayer>
<OGRVRTLayer name="polygons_as_simplified">
<SrcDataSource>polygons.shp</SrcDataSource>
<SrcSQL dialect="sqlite">SELECT Simplify(geometry,10) from polygons</SrcSQL>
</OGRVRTLayer>
<OGRVRTLayer name="polygons_as_hulls">
<SrcDataSource>polygons.shp</SrcDataSource>
<SrcSQL dialect="sqlite">SELECT ConvexHull(geometry) from polygons</SrcSQL>
</OGRVRTLayer>
<OGRVRTLayer name="polygons_as_points">
<SrcDataSource>polygons.shp</SrcDataSource>
<SrcSQL dialect="sqlite">SELECT PointOnSurface(geometry) from polygons</SrcSQL>
</OGRVRTLayer>
</OGRVRTDataSource>
Example: Multiple geometry fields
The following example will expose all the attribute and geometry fields of the source layer:
<OGRVRTDataSource>
<OGRVRTLayer name="test">
<SrcDataSource>PG:dbname=testdb</SrcDataSource>
</OGRVRTLayer>
</OGRVRTDataSource>
To expose only part (or all!) of the fields:
<OGRVRTDataSource>
<OGRVRTLayer name="other_test">
<SrcDataSource>PG:dbname=testdb</SrcDataSource>
<SrcLayer>test</SrcLayer>
<GeometryField name="pg_geom_field_1" />
<GeometryField name="vrt_geom_field_2" field="pg_geom_field_2">
<GeometryType>wkbPolygon</GeometryType>
<SRS>EPSG:4326</SRS>
<ExtentXMin>-180</ExtentXMin>
<ExtentYMin>-90</ExtentYMin>
<ExtentXMax>180</ExtentXMax>
<ExtentYMax>90</ExtentYMax>
</GeometryField>
<Field name="vrt_field_1" src="src_field_1" />
</OGRVRTLayer>w
</OGRVRTDataSource>
To reproject the 'pg_geom_field_2' geometry field to EPSG:4326:
<OGRVRTDataSource>
<OGRVRTWarpedLayer>
<OGRVRTLayer name="other_test">
<SrcDataSource>PG:dbname=testdb</SrcDataSource>
</OGRVRTLayer>
<WarpedGeomFieldName>pg_geom_field_2</WarpedGeomFieldName>
<TargetSRS>EPSG:32631</TargetSRS>
</OGRVRTWarpedLayer>
</OGRVRTDataSource>
To make the union of several multi-geometry layers and keep only a few of them:
<OGRVRTDataSource>
<OGRVRTUnionLayer name="unionLayer">
<OGRVRTLayer name="source1">
<SrcDataSource>PG:dbname=testdb</SrcDataSource>
</OGRVRTLayer>
<OGRVRTLayer name="source2">
<SrcDataSource>PG:dbname=testdb</SrcDataSource>
</OGRVRTLayer>
<GeometryField name="pg_geom_field_2">
<GeometryType>wkbPolygon</GeometryType>
<SRS>EPSG:4326</SRS>
<ExtentXMin>-180</ExtentXMin>
<ExtentYMin>-90</ExtentYMin>
<ExtentXMax>180</ExtentXMax>
<ExtentYMax>90</ExtentYMax>
</GeometryField>
<GeometryField name="pg_geom_field_3" />
<Field name="src_field_1" />
</OGRVRTUnionLayer>
</OGRVRTDataSource>
Other Notes
When the GeometryField is "WKT" spatial filtering is applied after extracting all rows from the source datasource. Essentially that means there is no fast spatial filtering on WKT derived geometries.
When the GeometryField is "PointFromColumns", and a SrcLayer (as opposed to SrcSQL) is used, and a spatial filter is in effect on the virtual layer then the spatial filter will be internally translated into an attribute filter on the X and Y columns in the SrcLayer. In cases where fast spatial filtering is important it can be helpful to index the X and Y columns in the source datastore, if that is possible. For instance if the source is an RDBMS. You can turn off that feature by setting the useSpatialSubquery attribute of the GeometryField element to FALSE.