Videos uploaded by user “PASS AppDev”
Building REST API with SQL Server using JSON functions
SQL Server 2016 and Azure SQL Database provide built-in functions that enable you to easily transform JSON documents into relational format and vice versa. Exchanging JSON documents between client applications and SQL Database is now easier than ever. In this session you will see how to create REST API using built-in JSON functionalities in SQL Server 2016 and Azure SQL Database.
Views: 11547 PASS AppDev
Graph data processing with SQL Server 2017 and Azure SQL DB
Microsoft has introduced Graph Database Processing to SQL Server 2017, which will facilitate users track many-to-many relationships between entities, to gather powerful insights from different pieces of connected data. This is well suited for applications where users need to extract information from different pieces of connected data, for example, IoT, fraud detection, recommendation engine, predictive analysis etc. In this session, we will learn the new features and demonstrate them by going over some use cases.
Views: 1197 PASS AppDev
What’s new in Entity Framework Core 2 0
Entity Framework (EF) Core is the lightweight, extensible, and cross-platform version of Entity Framework, the popular Object/Relational Mapping (O/RM) framework for .NET. This talk will give a quick look at the new features for .NET Core 2.0. We will look at the new release, how to install it and show sample projects covering the following topics: Improved LINQ Translation, Owned Entities and Table Splitting, Global Query Filters, DbContext Pooling, String interpolation in raw SQL methods, Explicitly compiled queries, Self-contained entity configurations in code first.
Views: 705 PASS AppDev
Self service data prep in Power BI
Matthew Roche presents on the new Power BI feature.
Views: 364 PASS AppDev
T-SQL Swiss Knife: Using the ScriptDom T-SQL Parser by Arvind Shyamsundar
Want to find out how exactly many DELETE statements in your database? Even better, how many of those are missing a WHERE clause? Or maybe you want to check your code for the usage of the COMPUTE clause, but Upgrade Advisor does not help you do so? Or maybe you want to 'pretty print' your SQL scripts? Many such requirements can be easily taken care of by using the TransactSql.ScriptDom parser which ships with SQL Server 2012. This session is for DBAs and developers who want to dig DEEP into the T-SQL code with simple C# and PowerShell scripts. And thereby end up making their jobs (and lives) easier!
Views: 27 PASS AppDev
Historical CRUD and Application Business Events
Every time you update or delete a record in classic relational database you lose information. In particular, you lose the state of the entities which was current until you changed it. For many years this automatic loss of information didn’t represent a problem for companies. But now, in the days of big data and business intelligence, any data you lose is potentially money you lose. Until the release of SQL Server 2016, for updating the state of a system you had two options: lose old data or shift to another persistence paradigm like Event Sourcing. SQL Server 2016 provides an intriguing middle ground as it introduces concepts like temporal tables and native JSON serialization and indexing that combined with existing columnar indexing make it suitable to be the storage of choice even for event-driven systems. However, the real question is do you need plain CRUD or domain-specific CRUD? If it’s the latter, you need to move towards Event Sourcing.
Views: 101 PASS AppDev
Data Time Travel with SQL Server Temporal Tables
Many times developers have to support users by answering the “What happened to the data?”  The task of retrieving data from a specific point in time is not an easy one.  Often this involves retrieving a backup and restoring the data in question (hopefully!).  SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups.  With a few T-SQL commands a historical table can be created, automatically updated, and readily accessed.
Views: 52 PASS AppDev
Working with SQL Server for Linux Cross Platform
You're welcome to explore the latest build of SQL Server for Linux. Connect to SQL Server looking into the tools available for both Linux and Windows. Maximo will provide samples on querying for database information using Python and PowerShell between two environments. This will be a demo intensive session you will not want to miss!
Views: 205 PASS AppDev
Index Methods You're Not Using by Jes Borland
There are index methods in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! Using examples, I'll show you how filtered indexes, compressed indexes, and indexed views work; how they can improve performance; and what situations each is best used in. If you have a solid knowledge of index basics and want to add to your collection, this is the session for you!
Views: 19 PASS AppDev
Isn't That Spatial   Spatial Data for the Application Developer by Jason Horner
This session is a whirlwind tour of the spatial features introduced in Sql Server 2008 from an application developers perspective. We will cover the basics of working with spatial data in both T-SQL and from .net including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance. Jason is a Microsoft Certified Master for Sql Server and has been working with SQL Server for over 10 years, He began working with SQL Server as a DBA / Application Developer in 1999, starting with version 6.5. He made transition to delivering BI solutions in 2002 and began working with spatial data in 2008. His latest focus has been architecting large-scale spatially enabled BI solutions.
Views: 8 PASS AppDev
How to Use Parameters Like a Pro and Boost Performance by Guy Glantser
Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren't aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance. In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.
Views: 19 PASS AppDev
Continuous Integration with the Database by Ike Ellis
In this talk, we spend time introducing the key concepts and importance of continuous integration. Along the way, we'll talk about the importance of testing, source control, and deployment scripts. We then discuss why all of those things are challenging with the database and how to overcome those challenges.
Views: 15 PASS AppDev
For the Better Developer:  When indexes are not enough
If you want optimum performance in SQL Server, you have to use indexes. But what if you already implemented indexes and your solution is still slow or it doesn’t scale like you want? Or, if you're on Azure, it is just requiring too much resources, which in turns means just more money to be spent on it? You may have to rethink the way you write your queries. How you write your queries is directly related to how you approach and solve your business problems, and more often than not thinking outside the box is the way to unlock incredible performances. But what this exactly means in a database? And how a developer can do that? In this session, you’ll see how using some lateral thinking and a set-based approach will open up a whole world of possibilities. Thanks to this demo intensive session, you'll never be the same after switching on this new mindset!
Views: 145 PASS AppDev
Introduction to Azure Cosmos DB  Microsoft’s Globally Distributed, Multi Model Database Service
At Build 2017 Microsoft announced Azure Cosmos DB, the industry’s first globally-distributed service that enables you to elastically scale throughput and storage across any number of geographical regions while guaranteeing low latency, high availability and consistency – all backed by industry leading, comprehensive SLAs. Azure Cosmos DB allows you to use key-value, graph, and document data in one service, at global scale and without worrying about schema or index management. Join this upcoming webinar to learn more about Azure Cosmos DB, what it offers developers and how it can help you quickly build your modern applications.
Views: 645 PASS AppDev
Lower expenses and improve daily work using Azure Elastic Pools & Azure Elastic Jobs
Using elastic pool, management tasks are simplified by running scripts in elastic jobs, which enables us to execute Transact-SQL scripts across a group of databases. Elastic Database jobs allow us to aggregate data from a collection of Azure SQL Databases into a single destination table/report. It improves performance by reducing the overhead of connecting to each database separately. During this session, we will review the services "Azure Elastic Pool" and "Azure Elastic Database job". We will demonstrate how to create, manage, and monitor Elastic Pools and multiple databases inside a pool as individual or as a group, using Elastic Job. We will discuss cases in which can be optimized by using these services, and we'll show a Real-life Case Scenario in which using a small trick in design we succeeded to reduce the amount of Resource Units by 90%! Join the meeting to discuss and learn how to improve performance, lower expenses, and improve daily work using Azure Elastic Pools & Azure Elastic Jobs.
Views: 36 PASS AppDev
Microsoft SQL Server 2014 Countdown:  In Memory OLTP for Database Developers
SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this database developer-focused session, we discuss the new memory-optimized tables and indexes. You will learn how to access memory-optimized tables using interpreted Transact-SQL and how to optimize data access using the new natively compiled stored procedures. Finally, you will learn how to work with the new lock-free transaction semantics for in-memory OLTP.​
Views: 15 PASS AppDev
Visual Studio 2013 Launch by Ben Hoelting
Visual Studio 2013 and .NET 4.5.1 enable developers to get the most of the latest Microsoft platforms, and create compelling modern applications and services. This month we will introduce you to the latest version of the IDE. We will start with a general overview of the new IDE. Next we will discuss what's new for developers as well as the latest advancements for web application development. Don't miss this opportunity to learn how to be more productive with Visual Studio 2013. Ben Hoelting is the Technical Director at Aspenware, a C# MVP and a Telerik Insider. He graduated from Colorado State University in 1997 with a BS in Computer Information Systems and a Minor in Computer Science. Ben joined the IT industry in 1996 as an intern and has worked with .NET since its inception back in 2002. Ben is a Microsoft Certified Technology Specialist (MCTS) for Web and Windows .NET 4.0. Finally, Ben is very involved in the local .NET community and is the leader of the South Colorado .NET User Group.
Views: 6 PASS AppDev